Thanks for taking the time. Your suggestions are very much appreciated.

Thank you all for your suggestions. Unfortunately, ganging all the create statements into one stored proc isn't working (although for some reason it create 3 out of 10). ...

Thanks

Thank you. That works beautifully. Can you tell me what "set datefirst 1" is used for? It doesn't change anything if I remove it.

After experimenting for awhile, I determined that only the PRINT statement (PRINT @Variable1 + @Variable2) truncates to 8K. The EXEC statement does not. Problem solved.

Thanks. Yes, I understand. However that isn't possible because each FileName variable passed from the recordset is a fully-qualified file name. Thus, there is no 2nd set...

With all due respect, I don't understand how that would work. It just doesn't make sense to me. Can you explain in more detail perhaps?

Here is an image of the package:

That would be a great solution, but it won't let me. It comes back with an error: "Cannot create connector. Cannot connect the executables from different containers." ...

Thanks for your suggestion and the link. Both tasks are already in the Foreach Loop. I added another File System Task above the one that deletes the file,...

You got it!

All is well in the universe again 🙂

I got it to work by placing my full query, insert and all, in a stored procedure and executing that from the OLE...

In my Data Flow task, I've got my OLE DB Source going into a Data Conversion task and then a Flat File destination. The output of the OLE DB...

One thing I forgot to mention. I can run the full query with the insert statement against the SQL Server 2005 database from Mgmt Studio without any problem. ...

The value is coming from a database call issued in an ExecuteSQL task and passed through to a ForEach Loop Container for use by the Script. Variables have been...