Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Create tables from sql queries in a .txt file

Author  Topic 

vamsimahi
Starting Member

29 Posts

Posted - 2008-04-22 : 12:36:48
Hello,

I am new to SSIS. I have a scenario:

I am creating a database using 'Execute SQL Task'. Then i have to create few tables in that database. where,I have my create table SQL queries for 5 tables in a .txt file.

How to approach this task...

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-22 : 22:02:51
Try with execute process task, use sqlcmd to call text file in the task.
Go to Top of Page
   

- Advertisement -