Post reply

load data to excel

  • July 2, 2007 at 10:20 pm

    #117691

    am using ssis recently just want to know how we can load the data to excel file dynamically. i mean the package has to create a folder with todays date and load the excel file there? this i can do in dts but how in ssis(UserID=450339)

  • July 3, 2007 at 1:56 am

    #716778

    You will have to use a script task or a file system task to create the folder. The name and path of the folder can be derived from a variable / variable with expression.

    Likewise, the Excel dest would have to have a variable as a connection string to point to the new file.

    Look at Variables and expressions in BOL.

    Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

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

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