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 |
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
 Posted - 2006-04-11 : 15:00:23
|
| Hey Guys -I have this complex set of DTSs, let me call them them DTS1, DTS2 and DTS3. DTS1, dowloads some files, DTS2 Process the files, DTS3 Move some records to different tables in a db. I need to pass a DTS variable from DTS1, thru DTS2 to DTS3. The variable is called runTime, the values should either be Morning (or M), MidMorning (or MM), Noon (or N) and Evening (or E), I'm currently using string as a data type, but for some reason the variable doesn't make to DST 2 or 3.BTW, I'm using the Execute Package Task.What am I missing ? What are the guidelines when passing variables thru the Execute Package Task ? Should I use ActiveX Instead ?Thanks in advance!---Thanks!Igor. |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2006-04-14 : 03:50:19
|
| It's been a while, but I always used to call packages from script tasks as I seem to remember the ExecutePackage task being a bit flaky. I certainly never had any problems passing parameters around using this method.Mark |
 |
|
|
|
|
|
Passing variable thru 3 packages.