How to autenticate to local SQL Express server

I have VWD 2005 Express and SQL 2005 Express installed and I would like to convert my access database to SQL. I tried running the upsizing wizard in access and could not connect to the local sql express server. I downloaded and installed SQL Server Migration assistant for Access and same thing, I can not connect to the server. What credentials do I use, I've tried creating an account on the server using the server management utility and adding the user to every role available but still can not connect to the server.What's the error message? You can test connection of the DSN used in Upsizing Wizard in odbcad32.exe (ODBC Data Source Administrator) to see whether it will succeed.

How to add SQL statements to the package created by Export Data wizard?

How to add SQl statements to the package created by Export Data wizard? I need to add SQL coming from file, the flow would be like this:

1) SQL would drop all objects: (views, tables, stored procedures) etc

2) SQL would create all objects: (views, tables, stored procedures) etc

3) Export Wizard SSIS package would execute

Also is there a dynamic way to add more tables do the package once created in SQL database? I would like to put the whole task on a scheduler too...

Also can I create all steps automaticly by SQL?|||

RADIOGENERIS wrote:

How to add SQl statements to the package created by Export Data wizard? I need to add SQL coming from file, the flow would be like this:

1) SQL would drop all objects: (views, tables, stored procedures) etc

2) SQL would create all objects: (views, tables, stored procedures) etc

3) Export Wizard SSIS package would execute

Also is there a dynamic way to add more tables do the package once created in SQL database? I would like to put the whole task on a scheduler too...

Execute SQL Task allows you to execute SQL statements. Will that do the job for you?

Yes you can add more tables to the package but you will have to build this yourself. I guess you could use the import/export wizard to create a package for your new tables and then copy whatever it creates into your new package.

To schedule execution of your package use SQL Server Agent.

-Jamie

|||OK, I will add two SQL Controls and see how it goes. I will let you know if there are any problems with this.|||

I heard Microsoft is working on the new Data Transfer tool, which could overcome difficulties I have. Would you know when/if it will become available? Thanks so much.

I am taking those free etraing courses, preatty cool. Seems like 2005 has a lot of new cool features. It would be a shame if I need to downgrade.

|||

Radiogeneris, along with the free etraining, it would help if you spent some time reading Books Online. It's vastly improved from SQL 2000, and has many tutorials and examples that can answer many of the questions you've posted throughout these forums. I can understand your frustration with things being different in SQL 2005, but it takes some work on the user's end as well to learn these features.

|||

I was asking simple questions, some of them are not in the online books (I checked). Like why the controls are greyed out...

how to add report "Templates" to list during wizard?

Hi, I'd like to customize the new report wizard to save me time in building reports.

I know that with most of VS there are files I can copy and edit to do that for new projects, forms, classes etc...

where are they for new reports?Hi,

Well, it actually depends on what you are naming "templates" in the Wizard.

1- If you are referring to the Styles you see at the very end of the wizard, you can add new styles editing the following XML file:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Business Intelligence Wizards\Reports\Styles\StyleTemplates.xml

AND the equivalent ones located in the "resource" subfolders like:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Business Intelligence Wizards\Reports\Styles\en\StyleTemplates.xml

Of course, make a copy of each file before editing them.

the only caveat is that I do not know where the "preview" image is stored, therefore your style is "blind". May be you can invest some time to find out or someone can jump in with that info.

2- On the other side, if you refer to the "Table/Matrix" and "Stepped" Wizard tab, I gues it is hardcoded.

3- If you refer to the "item types" you can add when adding a new item (not in the wizard, therefore). You can follow Russell Christopher's in http://blogs.msdn.com/bimusings/archive/2005/12/06/500462.aspx

Hope this helps,

Jordi Rambla
SQL Server MVP (Reporting Services)
SolidQualityLearning Iberoamericana|||

Jordi Rambla wrote:

Hi,

Well, it actually depends on what you are naming "templates" in the Wizard.

1- If you are referring to the Styles you see at the very end of the wizard, you can add new styles editing the following XML file:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Business Intelligence Wizards\Reports\Styles\StyleTemplates.xml

AND the equivalent ones located in the "resource" subfolders like:

C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\Business Intelligence Wizards\Reports\Styles\en\StyleTemplates.xml

Of course, make a copy of each file before editing them.

the only caveat is that I do not know where the "preview" image is stored, therefore your style is "blind". May be you can invest some time to find out or someone can jump in with that info.

2- On the other side, if you refer to the "Table/Matrix" and "Stepped" Wizard tab, I gues it is hardcoded.

3- If you refer to the "item types" you can add when adding a new item (not in the wizard, therefore). You can follow Russell Christopher's in http://blogs.msdn.com/bimusings/archive/2005/12/06/500462.aspx

Hope this helps,

Jordi Rambla
SQL Server MVP (Reporting Services)
SolidQualityLearning Iberoamericana

Yeah, I dug out my copy of the hitchhikers guide to sql rs 2000 and it has this info from the 2000 version and looks like it's almost the same in 2005.

by the way what I have is about 10-15 reports created by another dev where he created each one with a common look, font, page head, foot, title etc...
and the boss likes the look. that guy is now gone -- took a different job.
so I want to capture as much of his settings as I can so that when I create a new report I do not have to spend to much time just chnaging colors and fonts to match what he did.

How to add a line chart while building report

This is my first time with Reporting Services. I was using the wizard and it
only had the options of Matrix or tabular.
I want to add a line chart instead. How can I do so ?
ThanksInstead of using the report wizard, create a blank report. Then add a chart
from the toolbox.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Hassan" <hassan@.test.com> wrote in message
news:OAbD2FjYIHA.6140@.TK2MSFTNGP02.phx.gbl...
> This is my first time with Reporting Services. I was using the wizard and
> it only had the options of Matrix or tabular.
> I want to add a line chart instead. How can I do so ?
> Thanks