Data Transformation Services - help! 1

[christer99]

I am trying to get a DTS Package that firsts drops a SQL table, and the copies the same table from Dbase 3 to SQL (2000). I created an Execute SQL task and then a Dbase to Microsoft OleDB sql pROVIDER Transform data task. Everything works fine except that I can't seem to have a workflow where the Execute SQL task comes before the data transformation task. If I right click the Execute SQL task, my only option is to have it execute after the data transformation task. How do I change the workflow so the Execute SQL Task is executed first.

 

[fredericofonseca]

Two ways. (third one too complicate)

while designing the package,

1- select first the SQL task, then the Transform data task, go to the menu workflow and select the one you wish.

2- Select Transform Data task line, right click, select workflow. On following window select New, and add the correct one.



Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[christer99]

Thanks that worked.