February 1, 2009 at 4:59 pm
Hi, how can i exec a stored procedures inside integration services?
Thanks.
February 1, 2009 at 7:30 pm
Add an Execute SQL task. Set the appropriate Connection info, then set the SQL Statement property to
EXEC sp_name
where sp_name is the name of your stored proc.
Phil
February 2, 2009 at 11:58 am
Hi, I execute:
SQL Task 2, Execute SQL Task: Executing the query "EXEC _sp_persons?,
? ,
? ,? ,?" failed with the following error: "Syntax error, permission violation, or other nonspecific error". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Execute SQL Task 2
Why? I 'm writing bad the parameters?
February 2, 2009 at 6:35 pm
That's not a great error message:) Maybe it should just have said: "Something, somewhere, is wrong."
I just tried one on my system. Try this:
Resultset = None
SQLSourceType = Direct Input
SQL Statement = exec sp_helpsort
If that one works, you know that you do not have a generic problem running sp's - just something specific to the one you are trying to run.
If your sp has parameters, how are you setting them?
Phil
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply