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...