Post reply

User string contents --> Flat File

  • July 20, 2010 at 1:57 pm

    #141228

    SSIS 2008: I have a user-defined string variable (contents created at run time....) which contains

    concatendated "lines" of data, each terminated by a carriage return line feed. I want to write the string contents to a single text file.

    Is there a Data\Control Task that can be used to do this directly? If not, how would you recommend doing this?

    TIA,

    Barkingdog

  • July 21, 2010 at 8:28 pm

    #1196604

    Barkingdog (7/20/2010)

    SSIS 2008: I have a user-defined string variable (contents created at run time....) which contains

    concatendated "lines" of data, each terminated by a carriage return line feed. I want to write the string contents to a single text file.

    Is there a Data\Control Task that can be used to do this directly? If not, how would you recommend doing this?

    TIA,

    Barkingdog

    Out-of-the-box there isn't such task. You have two options:

    - implement a simple script to write the content

    - if you can use third-party solutions, check the commercial CozyRoc Stream Task. It does support the described requirement.

    ---
    SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

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

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