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 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Step order in DTS

Author  Topic 

war_shane
Starting Member

1 Post

Posted - 2006-11-15 : 15:43:43
I am importing 20+ csv files into Sql Server 2000. These transformations are running in parallel, so I have 20+ data-transformation-arrows going from the csv source connections to the Sql Server connection (destination).

However, I need to first create the tables that I'm importing to. How to I make the Execute Sql Task execute before these 20+ transformations begin? Obviously the transformations will fail if the tables aren't created first.

Do I have to use 20+ workflow On Success arrows to make this execute first?

Page47
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2006-11-15 : 16:38:42
Yes.

Jay White
Go to Top of Page
   

- Advertisement -