Post reply

.csv file name dynamically

  • October 15, 2009 at 10:35 am

    #135779

    Dear All,

    I am dumping the data from Table to .CSv file by using the flat file connection manager as destination.

    I am doing this everyday,hence i need to change the filename dynamically as 07UI(Todaydate).csv.

    Please guide me how can we do this.

    Thanks,

    Gangadhar

  • October 15, 2009 at 12:25 pm

    #1066430

    Select your Destination Flat File connection in the connection manager, press F4 to pull up the object properties, and use the Expressions feature to set the Connection String property of the connection to your chosen file name.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

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

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