Post reply

SPLIT A FILE DYNAMICALLY

  • February 23, 2015 at 4:14 am

    #398058

    Hi Team,

    Is there any possibilities to split a flat file by given condition dynamically..?

    currently i am using Conditional Split task for splitting flat files. but whenever new condition given i have to open package and have to add condition in the split task.

    eg case:

    i am splitting flat file based on File id.

    Flat file having 5 type of file id (t1, t2,t3,t4,t5).

    if file id column is t1 means ,file has go to one folder. if file id column is t2 means ,file has go to another folder and so on.

    i have used flat file source, conditional split transformation and 5 flat file destination task for this scenario.

    my need is how to add condition dynamically using parameter or other possible ways if file having more file id means(t6,t7). and files with each id has go to different folder. kindly suggest the solution.

    thanks

    Kannan.

  • February 23, 2015 at 7:14 am

    #1779251

    why wouldn't a ForEach loop, that dynamically created a folder based on the FileID work?

    then whether it's 10 or 100 FileId's processed, they all go in the logical folder/bucket?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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