February 3, 2009 at 4:16 pm
I have a windows application created using Visual Studio which creates an instance of DTS Package (2000). The steps are below:
1. Create instance of DTS Package using the code below:
Dim oPkg As New DTS.Package2
Dim oSrcConn As DTS.Connection2
Dim oDestConn As DTS.Connection2
2. Create the tasks & transformations.
3. Execute the OPkg.Execute().
4. The dts runs fine but after sometime its closes (or crashes) all windows forms.
From the internet I found that it could be a memory leak problem but can anyone let me know if you had this issue or how to resolve this issue?
When I converted the above steps into DTS package using the method "oPkg.SaveToStorageFile", the dts package is fine from Enterprise Manager.
Appreciate help in advance.
February 6, 2009 at 9:42 am
I fixed this issue. It looks like when you create an object from DTS.Package2 & try to execute it, somehow it corrupts the memory or keeps running something in the background & eventually crashes the windows application (runs in vb.net).
what i did is after I create the dts package (2000) using first object I saved it as structured file & then I re-loaded it into a new object (DTS.Package). When I executed it with new object it ran fine & didn't crash the application.
it looks to me like running 2000 dts package in .net (vb.net, c#) has some issues. but, watever I have my solution.
February 9, 2009 at 4:06 pm
Thanks for the update. I thought there wasn't an issue here, and I suspect it might be something else, but your solution is a good one to keep in mind. I know I've run packages programatically from VS without crashing things. Perhaps there is something with forms, however.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply