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!!!