I am working on an SSIS project where I create two flat files for submission to a data contractor. This contractor requires a control record be the first line in the file. I create the control record based on the table information being exported.
What I would like to know is, is it possible to utilize the Header Section of the Flat File Destination Editor to insert the control record? And, as it is dynamic, what kind of coding must I do in order to utlise this functionality?
Thanks.
Yes, I would guess that you can do exactly this using the header section.
You can set it dynamically by putting an expression on the [<Flat File Destination Name>].[Header] property of the parent data-flow task.
-Jamie
|||Ok, I see that this can work, but looking at the available variables, functions for expressions, I do not see how I would get the data inserted from another text file (table) already created into this second one.
Truly not trying to be dense here, just "can't seem to see the forest for the trees."
Thanks.
|||That's a bit of a different requirement. You may be hampered by the fact that the maximum length of the result of an expression can only be 4000 chars
The way to do it would probably be to build the text up programatically in a script task.
-Jamie
sql
No comments:
Post a Comment