February 15, 2008 at 3:07 pm
Hello,
I have written a SSIS package that allows me to dynamically assign the OLE DB source connection in my DFT by building a connection string, and building my SQL command ahead of time. So, I can loop through different databases and tables. I want my destination to be RAW FILES, and I have also dynamically assigned the RAW destination filenames to match the table names, but I am stuck on how to "refresh" the metadata for the destination during run-time. The RAW file destination task does not like it when I change the source table on it because it looses the metadata! Any ideas on how to get around this or make it work as-is?
Any help is much appreciated!!!
-John
February 18, 2008 at 6:48 am
It sounds like you've done a lot of work on this... I regret to have to tell you, but you can't dynamically change the meta data of an SSIS dataflow.
The only way that you change the source or destination objects at runtime, is if they contain the same metadata, which doesn't sound like the case in your situation.
Kindest Regards,
Frank Bazan
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply