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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-06-15 : 08:18:19
|
| Peter writes "Dear SQLTeam, I hope you can assist with a sequencing problem :Step 1 : Dynamic filename creationon successful completion...Step 2 : Sql Command - creating a series of SQL tableson successful completion...SQL Connnection that has 7 transformation steps running in parallel. Each step runs a SQL query and exports the results to TXT file. Some of the 7 steps require the newly-created table to be present.on completion...Step3 - delete the SQL tablesMy problem is that when I execute the DTS package, the 7 transformations appear to start at the same time as the Create Table step, and spuriously fail as they do not find their requisite table. This is adhoc and most often everything works fine.I have wrapped the create table commands in a begin/commit transaction statement, assuming that there is a commit problem but this has not resolved the matter. The Create table step uses the same SQL connection as the transformation steps, so I tried using a separate SQL connection but this had no impact.Your advice would be invaluable !!regardsPeter" |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-06-16 : 00:09:35
|
| i can think of two ways at the moment1. create a separate step after step 2 for the transformation, this way you ensure that tables are created before the transformation steps gets executed2. you can re-arrange, create table1-->transformation task1, create table2-->transformation task2...--------------------keeping it simple... |
 |
|
|
|
|
|
DTS step starting before previous step concluded