I'm with Crosspatch. Do the two step on the data. I use the DataPump extensively and it is very squirrely. If you look at it wrong, it'll mess up your...

All my environment sensitive properties are set via a dynamic properties task in my packages. This includes paths and more specifically connections. As I move through DEV to UA to...

You can't do those transformations in an ActiveX script?

Instead of using a SQL Task, use the DataPump task. Your source is the SQL cut and pasted from the old SQL task. The destination is a text file defined...

This is a DTS Designer (GUI) solution.

1. Use the datapump task to pump data from table one to table two.

3. Use an ActiveX script to add an IF statement...

The quick way is too schedule it from EM. Then go to SQL Agent. The command line for DTSRUN will contain the encrypted package name.

Another solution is to use a DataPump DTS task with an ActiveX transform script. The source is your source table. Define a lookup as the Insert into the single...

I've gotten this error in the past and it was due to the SQL returning an empty result set. Are you sure the SQL returns data?

I found it about two minutes after I posted the question. An example is presented below. I could have set a global variable but then I would be maintaining the...