January 21, 2009 at 9:34 am
We have a standalone application which runs on C#.net & also uses old Vb code.
The vb code invokes dts package dlls to execute a dynamic dts package which reads data from source & writes it into file in xls, access, csv & XML.
We dont have issues writing to XML but when we try to create xls, access & csv after creating the file the application closes by it or crashes. Also, in case of xls there is an error message in application log "
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:No such interface supported
(Microsoft Data Transformation Services (DTS) Package (80004002): No such interface supported
)
Step Error code: 80004002
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:1100
"
Help me here whether this is an 2000 to 2005 problem or any file should be installed to avoid these issues.
January 21, 2009 at 9:53 am
sqldts80.hlp, That is sql2000 DTS.
Is there any way you can get the vb guys to save the VBS output file, instead of executing, then try to import to DTS and see why its failing
January 21, 2009 at 10:04 am
This was working in our older version it starts failing now so we are not sure whether its 2000 to 2005 issue or vb coding issues but the application event logs shows this message & the application closes. Let me import the file & see what I can do.
January 21, 2009 at 10:09 am
also, this code cannot be imported into dts as it is return in vb. It is creating instance of DTS.Package2, DTS.Connection2, & so on....
January 21, 2009 at 1:02 pm
So your using VB Code to create Sql2000 DTS Packages, and your running those code generated Packages against a SQL2005 Server?
There are some issues running 2000 packages in 2005. Although I do not know what all of them are.
January 22, 2009 at 2:14 pm
Yes. The code has been migrated to .net now. We are debugging this since yesterday & couldn't able to find the reason. We make a call to create a dts package (using dts.package2 & related dll's) & pull data from source & write it to excel sheet.
But, the funny part is the dts successfully writes the data into excel all the time though sometimes create table task in excel fails (as seen in the application event log) but the data is still available. Once this stage is complete the excel sheet opens up as per the code from the form & then it crashes out the application (not sure whether dts is the one crashes out but as per our debugging step by step the dts part is the bug).
We are still working on it. Would update if i come across the solution.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply