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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan McCauleyEnterprise 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:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Languages and Standards

From novice to tech pro — start learning today.