create excel worksheet from Active X Script Task Props

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: chris (anonymous_at_discussions.microsoft.com)
Date: 03/26/04

  • Next message: Baisong Wei[MSFT]: "RE: SORRY Can't open package after changing sa PWD" 
    Date: Thu, 25 Mar 2004 16:23:48 -0800

    sql2k sp3

    In Active X Script Task Props, I can use the
    FileSystemObject to create a file.

    Function Main()
            Dim fso, MyFile
            Set fso = CreateObject
    ("Scripting.FileSystemObject")
            Set MyFile = fso.CreateTextFile("\\packrat\Dept-
    IT\chris\excel\DailyRefundFromSQL\sqlout.xls", True)
    Main = DTSTaskExecResult_Success
    End Function

    Is there something that can replace the FSO to create an
    Excel file in a readable format?

    Sample code would be ideal?

    TIA, Chris

  • Next message: Baisong Wei[MSFT]: "RE: SORRY Can't open package after changing sa PWD"
    • Quantcast