Sending text files to different destinations dynamically

Discussion in 'microsoft.public.sqlserver.dts' started by Guest, May 11, 2010.

  1. Guest

    Guest Guest

    I am using SSIS 2005 to import a text file, do some lookups and then
    send the output to subfolders on the destination hard drive based on
    certain criteria. Is SSIS 2005 capable of doing this? If so, how?
    Guest, May 11, 2010
    1. Advertisements

  2. Guest

    Todd C Guest

    Generally speaking, I think the answer is YES but I'm not totally sure about
    your scenario.

    When you say "send the output to subfolders" what does that mean?
    Are you taking data from a text file, reading it via a Flat File Source
    Connection, then sending down a data pipeline in a data flow?

    Do you want a Conditional Split transform and multiple flat file
    destinations, each in a different folder?

    Help us understand your package design and/or your intent.
    Todd C, May 13, 2010
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.