Post reply

how to create testfile dynamically and load into file

  • January 24, 2013 at 8:38 am

    #269719

    Hi,

    This is Vivekanand,i have stored procedure in that 5 IF conditions based on filename execute the inside of if class select statement.I want use that SP load into different file created by dynamically using single DFT. code like

    if filename='abc'

    begin

    select * from siva

    end

    if filename='def'

    begin

    select * from sai

    end

    if filename='ghi'

    select * from krishna

    end

    if filename='jkl'

    begin

    select * from ganesh

    end

    using single dataflowtask and create dynamically flatfile(.csv) based filename and load into filename data.

    Thanks,

    Vivekanand.

  • January 24, 2013 at 9:40 am

    #1580604

    Based on my understanding, you have a stored proc with those "if" constructs that acts as source, you want to have a CSV format flat file as destination based on each condition.

    I suppose, those tbls have different metadata, you'd want to use script component to capture result set into a datatable and based on file name condition, write it to a flat file

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

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