Lets say I want to create several flat files - one file for each row returned by a sql query. Source data resides in SQL.
In short, my problem is a "reverse" of the many examples out there where data originates from multiple flat files into a SQL database. I want to go from SQL to multiple flat files.
I suppose this means I need a dynamic flat file connection string ... but I'm really stuck. Please help.
Thanks in advance.
Do you want to create many files at the same time? Then create a Flat File Connection Manager for each file.
If you only want to create one file at a time, but use a different file name so as not to overwrite the existing file, like a daily sales file or something like that? The look at the expressions property on the Flat File Connection Manager. You can use a variable to alter the connection string property.
Try Google: "Using Property Expressions in Packages"
|||Like TGnat says, you'll need to use a Flat File Destination Adapter in concert with a Flat File Connection Manager. There's loads of information out there if you google it!
-Jamie
|||
Thanks, I'll check it out.
John
没有评论:
发表评论