I have a DTS package which exports data from SQL(2000 sp4) to Access
2000 all toll their are 40 Transform Data Tasks (each representing a
table). 39 of the 40 work perfectly the last one
executes but does not send any data or give any errors. I am using a
Global Variable (the same one for each Transform) in a simple way
simply...

Select * From tblCity Where MarketCd = ?

I click the parameter button to associate the parameter and save
everything, run my package, after it finish's executing I go to the
transform that does not send data and click the parameter button and my
global variable is no longer selected??? Help!

Hello scott.rick (AT) cit-net (DOT) com,

If it maps in 39 and not the 40th and you are sure you put the variable in
there at design time then there is no reasonable explanation for this. Things
to try

If you map the ? to the variable at design time and close the datapump and
then reopen in design time. Still there?
Use a different variable?

The thing is that if there was no variable there at runtime then the pump
should fail as the statement would be rubbish.

Is the package set to fail on first error?

Allan

Thanks for the response! I have tried the options you mentioned,
mapped the variable, closed, reopened and it is still there...doesn't
dissappear until I actually run the package. Used a different
variable...same results. This particular Transform is towards the
beginning of the package and the remaining steps execute so the package
(and global Variable) is not failing just this step...and actually it
tells me it executed...just no records (and yes there are records in
there that should get pulled). I tried one other thing, hard coded the
value for that one Transform and ran it...this time the Transform
failed with a 'LA'(the value I hard coded in) is not a defined Global
Variable...so I put the ? back in and tried again and got the original
results. At that point I went to the Transform associated the ? to the
Global Variable and ran just that Step and it worked...ran the whole
package and it went back to the original problem...I'm at a loss at
this point? Any other things I should try?


Allan Mitchell wrote: