Post reply

Dynamically set Flat File connection

  • November 5, 2012 at 12:14 pm

    #270459

    Hi All,

    I have a requirement where i will have to export data to a text file. this data export is being configured for multiple locations. I have to somehow set the column delimiter dynamically because some locations need comma delimited and some need pipe delimited. Can someone please suggest me on how to aaproach this one.

    I know we could do this through scripting. some sample scripting will be helpful to get me started.

    Thanks!

    Kevin

  • November 5, 2012 at 2:41 pm

    #1556210

    I don't remember if this in 2005 or not, but in the connection properties there is a delimiter value that can be set by an expression. Right click on the connection manager (not the flat file task, but the actual connection definition) and go to properties. Look for Expressions and click the elipsis and see if Row Delimiter is a property that you can set with an expression.

  • November 5, 2012 at 2:50 pm

    #1556213

    If my other suggestion doesn't work you could also create 2 target files tasks and use a conditional split that would channel the data to the correct output format.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply