October 13, 2008 at 2:52 pm
I am trying to get a SQL Task to call a stored procedure on the server. I have the following set:
Connection Type: OLE DB
Connection: connection to sql server
SQL SourceType: Direct Input
SQL Statement: dbo.procedure_name
IsQueryStoredProcedure: True
Problem is nothing is happening. The procedure is a simple one, truncate four tables. It works fine when I execute it logged on to SQL Server. Connection info also works because I can insert data into the same table.
Additional info, this package worked with issues a month ago. Since then, my pc was swapped out and all software was reinstalled. When I opened the SSIS package for the first time after my system swap, the SQL statement had been erased.
October 14, 2008 at 7:38 am
When you say "nothing happens" do you mean that when you run the package in VS, everything turns green and there are no error messages?
Is there any useful in formation in the execution results tab in VS?
Have you tried running profiler to see if the connection to the database is being established and if the query is being fired?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply