Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Raw File Destination in a loop where OLE source is changing Expand / Collapse
Author
Message
Posted Friday, February 15, 2008 3:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: 2 days ago @ 9:02 AM
Points: 5, Visits: 196
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
Post #456543
Posted Monday, February 18, 2008 6:48 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, February 28, 2014 4:38 AM
Points: 268, Visits: 1,072
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
Post #456889
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse