Post reply

Create Excel File each time using SSIS

  • March 16, 2011 at 11:38 am

    #389064

    I am working on the SSIS 2008.

    I Need to create the package. my sourse is TSQL query and the result of that query I need in the EXCEL file with the ReportName_TimeStamp. I know that we can use EXCEL destination but in that i have to create the new connection manager everyday for the next day report.

    EX:

    If my ReportName is ABCD

    then for today I need Excel Sheet with the name ABCD_01/01/2010.

    for tomorrow Excel Sheet with the name ABCD_01/02/2010.

    Can some one please guide me toward resources or any hint?

    Thanks

  • March 16, 2011 at 4:17 pm

    #1299713

    Maybe this link[/url] will provide the information you need.


    Lutz
    A pessimist is an optimist with experience.

    How to get fast answers to your question[/url]
    How to post performance related questions[/url]
    Links for Tally Table [/url] , Cross Tabs [/url] and Dynamic Cross Tabs [/url], Delimited Split Function[/url]

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

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