SQL Taks fails but data is correct at the time of failure

[ynnepztem]

I have a stored procedure to parse a name field. Every once in a while the SQL Data Task will fail stating

[Execute SQL Task] Error: Executing the query "SSISParseTheName2" failed with the following error: "The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

When I look into the database, all of the records where parsed correctly. Does anyone have any ideas? Is there any way to continue processing even though the task failed? I'm using SQL Server 2005.

Thanks, Penny

 

[xlbo]

put some error trapping in there - add an error flow on the SQL task. Attach a script to it and get it to pop up an error message with any details that are relevant

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[ynnepztem]

Thanks but I have no idea how to do that. Can you walk me through it or point me to a URL that can? I've googled it but have not found the "how to's".

 

[ynnepztem]

I solved my issue. When several of the "Execute SQL Task"'s failed. I copied the code from the stored procedure directly into the Task. It worked perfectly from there. Apparently the connection to SLQ Server was timing out.