June 23, 2005 at 1:11 am
Hi all,
I had designed a DTS package for transferring Text file data to my sql server database table.Now i am using this DTS package through my C# code in .net.
I had declared certain Global variables to use my package for number of Text files. I am also using dynamic task properties to set my source object file to a global variable. Also i am using ActiveX script transformations.
The problem i m facing is sometimes the DTS insert only Half records(i.e if there are 10000 records in the file it Inserts only 5000 records successfully and comes back).
Can anybody pls tell me why this error is coming and how can i solve this problem?
Thanking you
Hitesh
June 23, 2005 at 2:38 am
Try checking the log files for any problem with the source records. You might have some erroneous records because of which only half the records are getting inserted
right click the transformation task --> options tab --> select the name for exception file and check Error text , source error rows and dest error rows and execute your package and see if there are any erroneous records.
HTH
Meghana
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply