SSIS Package : Execute Sql task with a parameter from row count

Dear All,

I have developed SSIS package whith the following components

1. Data Flow Task -  With OLE DB Source Then Row Count  with variable vrbRowCount(int32) then a Destination.

2. Execute SQL TASK  with the follwing Sql and Result set as Single row
    Update wf_cntl
Set src_rowcount = ?
Where tbl_name = 'Invoice_Header'
 
And Parameter mapping
Variable name : vrbRowCount
Direction Input
Dataa Type Long
Parameter: new parameter
Parameter value : 50

It results in an error please help what is the correct settings
bestway_itAsked:
Who is Participating?
 
bestway_itConnect With a Mentor Author Commented:
Thanks guys for your input, the proble was with the Parameter Name,

http://technet.microsoft.com/en-us/library/ms140355(v=sql.105).aspx
0
 
Ryan McCauleyData and Analytics ManagerCommented:
Any chance we can get the text of the error? What you're trying to do seems reasonable, so nothing obvious jumps out, but it's hard to troubleshoot further without the specific error message being given.
0
 
Jason Yousef, MSSr. BI  DeveloperCommented:
Alright, 2 issues here, you're expecting a resultset from updating one record, and you would get nothing!!

and the second is setting the resultset to single row and configured nothing in the resultset property

Have you tried to set the ResultSet to NONE ?
0
 
bestway_itAuthor Commented:
Please close this question as answer was found on the TechNet website. Thank you.
0
 
bestway_itAuthor Commented:
Found the answer.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.