Newbie with conditional flat file export question 2

[alexjones]

To date, I have only created simple class-room exercise type export packages.

Here's a simplified version of the situation. The developers on a project have a seven-column SQL Server global temporary table from which they wish to export five-field flat files. Four of the columns are common to all files. The column to be added as the fifth field is to be determined by the value of a variable. The field name for that field is also dependent upon the variable value.

Also, they wish to restrict the size of the flat files to no more than 500 rows each, so each export must be able to create multiple flat files per variable value.

Can this be accomplished using data flow transformations?

Any suggestions as to how I might begin would be greatly appreciated.

 

[drtree]

SandieJ,

There are probably multiple ways to go about this, but I would set up a data flow, with multiple Flat File destinations, which would be picked depending on the value for your variable. So, you'd also need to set up your precedence constraints so that they executed based on the value of an expression, and not based on failure/success.
Check out

http://www.sqlis.com

- it's a really good website and may be of some help to you.

 

[MDXer]

Not seeing your data or fully knowing what would cause the split of the data into a a different file or use a different column I would probably tackle this in a Data flow script task that would be a destination. You could code all the business rules you need to.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[alexjones]

Thanks for your responses. I shall pursue your suggestions. And thanks for the web site referral!