February 19, 2014 at 7:05 am
I have a stored procedure in SQL Server 2005 that I call from an SSIS 2008 package on a different server. The stored procedure completes and then the task in SSIS just hangs. I verified that the process is not running in the SQL Server where the stored procedure resides and I confirmed that all rows were processed. Has anybody ever seen this before and is there a resolution?
Thank you.
February 19, 2014 at 7:15 am
How do you call the stored procedure?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 19, 2014 at 8:10 am
As a follow up to Koen's question, is this occurring when you are running the package from BIDS?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 19, 2014 at 8:12 am
Yes, I am calling the stored procedure from BIDS / SSIS 2008.
February 19, 2014 at 8:14 am
Karen A. Ferrara-426245 (2/19/2014)
Yes, I am calling the stored procedure from BIDS / SSIS 2008.
What kind of task are you calling the proc from? Is it an execute sql task, maybe in one of the datasource types?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
February 19, 2014 at 8:42 am
I am calling the stored procedure from an Execute SQL task.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply