Post reply

Excel filesize increases when data exported from SSIS Package, how to control it using script task?

  • July 28, 2008 at 2:13 pm

    #130189

    Hi

    I have SSIS Package which exports data from SQL Server to Excel. I drop the table we create in excel and recreate the table using Execute SQL Task.

    Whenever I run the package, the excel size increases gradually, but when I open the file and save it as is the filesize decreases. I had similiar problem in DTS and I used vbscript for this operation.

    Can anyone help me in writing a vbscript in .net which will use the script task in opening the excel file and saving it with the same name at same location.

    If there is any other way , let me know

    Thanks

  • July 28, 2008 at 2:30 pm

    #849438

    Please don't cross post. It just waste people's time and fragments replies. Many of us read all the forums.

    No replies to this thread please. Direct replies to:

    http://www.sqlservercentral.com/Forums/Topic542198-148-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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