Nick,

I'm experiencing the exact same issue. You mentioned that once you removed it, the install worked fine. Do you remember what it was that you removed?

I just un-installed SQL...

I was able to get this to work.

Thanks for your assistance.

Ok, I've loaded a Recordset with the distinct Company codes from my table.

Now I'm not sure how to configure the For..Each...Loop task to read the Recordset and dynamically create the...

Thanks for everyone's reply's.

Have a great day..

This is for a data extract to a 3rd party software. So Greg's solution fits our need perfectly.

Thanks,

That worked.

Thank you very much.

I'm new to SSIS and haven't implemented logging yet. After researching this problem, I wish I had.

I received the following error while using SSIS to pull data from one SQL Server to another. This ETL process has been running fine for over 6 months and...