Post reply

SSIS/SQL/Text File

  • September 3, 2008 at 1:31 pm

    #123340

    i am doing an automated job process, need to send an text file to mainframe fTP location

    in that text file i need to add the current date in the first line and the rest of the contents from second line.

    Contents from second line are already present. Just need to add the first line with current date

    How do i do in SSIS as i will FTP once the file is ready thru SSIS?

    Please let me know.

  • September 3, 2008 at 1:58 pm

    #866791

    where are u getting this falt file from ...if u are exporting data from ur db to flatfile and moving it to another location then u can use some expresiions in ssis or give it as getdate() when moving to flatfile

    Thanks,
    Chinna

    Its the Journey which gives you Happiness not the Destination-- Dan Millman

  • September 3, 2008 at 3:17 pm

    #866820

    Chinna

    it is present in a server location. if it is in Database i can do it easily

    Before FTP this file i got to change the date which is present in the first line of the text file with the current date.

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

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