Checkout the Multi-Phase feature of the Transform Data task, or you could also use the Data Driven Query Task.  Both are very handy for cases such as yours. 

You can use a ExecuteSQL Task and assign the rowcount to a global variable in the paramters mapping/output parameter tab.  Then evaluate the new global variable in a workflow ActiveX...

Thank you! 

I have a couple thoughts.

(1) There is a 'Close Connection on Completion' Property you can set for the Transform Data Task.

(2) Why wouldn't you...

You could also use UNION and combine all the separate selects into one statement.

You can set the data source dynamically using the Dynamic Properties task. Typically you would assign the desired connection value to a global variable(s) and then use the Dynamic...

You cannot use the built-in FTP Task to send files back to the FTP site. It only works to receive files via FTP.

When you schedule a package to run as a job it will run on the Server instead of your local machine. Make sure the Server running the dts job...

True, it could fail for any reason. But you can write the record to an error log and research it later and let your job continue to run.

Could you use a Data Driven Query Task instead of the ExecuteSQL Task? Then you could trap the insert failures and 'skiprow'

I can think of 2 methods. (1) Load to staging table, then select distinct and insert into main table. (2) Use the data driven query task. And...

Why would you havbe a "unique" index that you allow duplicates?

Could you call your stored proc from another proc (handling the 'error' in the new proc), then execute the new...

Was the data dropped from the prior run? If not, then the Drop was not successful.

I did not setup a named range in Excel before using the...

quote:

---

Corey, that's amazing. Did you find this documented anywhere. I would like to explore this further.

Regards

Stefan

---