After sql 2005 SP2 patch, dts.dll not working in C#

[Joos123]

Hi

Using dts.dll and C# code we were importing data from text file to data
base. Every thing was working fine till we run the patch for SQL Server 2005
SP2. After executing SP2 patch, the execution just terminates itself with out completing the entire process. We use the xml config file which will have the steps to execute through the C# code. In my xml config file, we have steps to import data to different databases. When we execute our job through command prompt, its importing data to first server (specified in 1st step) and then just
terminates with out copying the data to rest of the tables as specified on the multiple steps. Please help if some one faced similar issue and have a solution

Thanks in advance

[Plater]

Sounds like a problem in the dts.dll file?
What is it used for?

[Joos123]

Hi,

Thanks for your reply.

Using Interop.DTS.dll, we have written the C# code to push the data from a text file (delimeted) to sql database.

[Plater]

Yes, but why do you need the dts.dll to do a simple task like that?
Parse a CSV file and insert into database can be done with managed code as well?