Raw File Destination in a loop where OLE source is changing

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Raw File Destination in a loop where OLE...

Raw File Destination in a loop where OLE source is changing

Rate Topic

Display Mode

Topic Options

Author

Message

John-476812

Posted Friday, February 15, 2008 3:07 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, May 09, 2013 9:15 AM
Points: 5, Visits: 186

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

Frank Bazan

Posted Monday, February 18, 2008 6:48 AM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 06, 2013 3:02 PM
Points: 268, Visits: 1,055

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
@Bikeride2Africa

Post #456889

« Prev Topic | Next Topic »

Permissions