Post reply

Loading from multiple sources into a flat file

  • June 7, 2010 at 10:52 am

    #97380

    Hi,

    Can any one help me with this issue.

    I hav 3 different tables and i want to load the data from these tables into a single flat file by appending one after the other. I tried the following way

    I took three data flow tasks and 3 flat file destinations and i used the same flat file connection manager for all the

    flat file destinations and in the control flow task i set the precedence constraints on the data flow tasks.

    but it is not working.

    Please suggest me something.

    Thank you in advance.

    Kevin

  • June 7, 2010 at 12:38 pm

    #1177197

    You say id did not work, What happens? does the output get over written? do you get an error?

    This will help formulate the next set of questions or ultimatley a response.

    Dan

    If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

  • June 7, 2010 at 3:30 pm

    #1177244

    the result gets over written.

  • June 7, 2010 at 3:45 pm

    #1177249

    @Dan.Humphries:

    I got it this time. I forgot to uncheck the overwrite data in the file checkbox.

    I would appreciate if you could tell me if there is any better way of doing this.

    Thank you

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

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