Still can't get the files. Anyone else have any luck ?

Oops ! my bad... I have it working now...

ThanX for the great script

AmcAmx

Martin,

I got it working ! FINALLY !!! Here is what I had to do....

The variable that I created to store the SQL...

The Data Flow Task does not have...

Martin,

Very interesting thing I have here.... Seems my OLE DB Source Connection does not have those properties although my SQL Server Destination does... hmmm....

Here are some...

Martin,

Ok.. guess my idea will not work as it seems that you cannot change the OLE DB OpenDataSet property during execution (or at least I am not...

Martin,

Thank you again for the help. What you are saying makes total sense. The problem I am having is the implementation. Currently (as a test)...

Martin,

I was able to complete the following items:

-- Create one permanent staging table

-- Create an SSIS package that does the following:

-- Truncate the staging table

-- Select all data from the...

Martin,

Yes the tables all have the same layout. I was considering doing a massive UNION but even that comes with problms as the Resulting table has a...