August 9, 2005 at 7:59 pm
HI,
I Have a dts package that execute the following ActiveX tasks:
1. Define global variables about 250 !!
2. get one file from a list of 100000 Txt files
3. Process the file ( basically it's concatenating strings, converting dates and amounts to the right format)
3. build an "exec Stored procedure" string dynamically and assign it to an executeSQLTask
4 execute an EXECUTESQL TASK
5. Loop around to step 2 after archiving the processed file.
6.The script is supposed to display a message when there is no more files to process.
My problem is this works fine with a small number of files like 1000 to 2000 files but when it gets to a large number then the package execution terminates without any error nor reason as in most cases only a number of file up to 2000 have been processed.
Connection timeouts are set to 90 s
Any idea why a dts package terminates succesfully before it should normally do ?
I am using SQL2K sp4.
Thanx,
August 9, 2005 at 10:13 pm
Have you turned Logging in your package ON, and log to a local text file? Provide the entire path in the textbox and read the results after completion? This will usually help find the root of the evil.
-Mike Gercevich
August 10, 2005 at 8:17 am
Thanx ,
Finally i found out , the commit transaction and close connection properties of the executeSQL task were checked. so it seems that it was not considered as a package failure if the connection drop ...
J.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply