Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSIS Issue with Active X

Status
Not open for further replies.

sendba

Programmer
Sep 7, 2005
113
US
Hi all,

I am trying to migrate a SQL Server 2000 DTS Package to Sql Server 2005 SSIS.
I have a DTS which contains active X script which creates a xls file with columns.

'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************

Function Main()
Dim oExcel
Dim oBook
Dim oSheet
Dim objg

set objg = CreateObject("Scripting.FileSystemObject")
'Set File name and Folder Information
OutFname= "C:\DTS_SSIS_OUTPUT\test.xls"
If objg.fileExists(OutFname) Then
objg.DeleteFile (OutFname)
End If

Set oExcel = CreateObject("Excel.Application")
Set oBook = oExcel.Workbooks.Add
Set oSheet = oBook.Worksheets(1)
oSheet.Name = "Daily_Sales"

oSheet.Range("A1").Value = "DBA"
oSheet.Range("B1").Value = "Postal_Code"
oSheet.Range("C1").Value = "Load Count"
oSheet.Range("D1").Value = "Load Amount"
oSheet.Range("E1").Value = "Reload Count"
oSheet.Range("F1").Value = "Reload Amount"

oBook.SaveAs "C:\DTS_SSIS_OUTPUT\test.xls"

oBook.Close

Set oSheet = Nothing
Set oBook = Nothing
Set oExcel = Nothing
Main = DTSTaskExecResult_Success
End Function

I am getting the following error whenever i execute the script.


SSIS package "Test.dtsx" starting.
Error: 0xC0048006 at Create Test Excel File, ActiveX Script Task: Retrieving the file name for a component failed with error code 0x032C209C.
Task failed: Create testExcel File
SSIS package "test.dtsx" finished: Success.

Please let me know if there is any way to correct this issue

Thanks

 
it's comical when you look at the first few threads of the forum and what? 80% don't belong in this forum? Come on. If you can't manage to post your quetions in the right forum how did you get this far

There is an SSIS forum just for you. This has nothing to do with administration

[sub]____________ signature below ______________
Backups are for sissies!!!!
coming to your keyboards soon[/sub]
 
Thanks for suggestion.
You can be a great guy in managing forum's.

There is a way to tell us.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top