Post reply

Execute Stored Proc in SQL task pass variables as parameters

  • April 26, 2010 at 8:04 pm

    #142784

    Here is my dilemma. I have created a couple of variables at the sequence container scope. I am trying to populate these in my data flow from row count transformations, one variable at the beginning after the source, one at the end before the destination. I then want to execute a stored proc task after the data flow runs for my row counts, and pass those as parameters for my stored proc.

    I am using OLE DB connection in my sql task, and I am using exec dbo.MyStoredProc @ParameterName = ?, @ParameterName2 = ?. I also have the parameters set up in the parameters section and the names are 0 and 1. I set it up similar to this blog posting, except mine are both input parameters.

    Everything seems to be running fine, however my stored proc doesn't seem to be running as it is not populating a table with the row counts.

    Is what I am trying to accomplish feasible?

  • April 26, 2010 at 8:20 pm

    #1157960

    I figured it out, my table had varchar length less than some of the values so there was truncation and therefore the proc didnt load the data. Weird there was no error though in SSIS. I guess it doesn't pass back errors.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply