• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 631
  • Last Modified:

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
0
bestway_it
Asked:
bestway_it
  • 3
1 Solution
 
Ryan McCauleyCommented:
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
 
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

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now