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. 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.