<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2005
»
SQL Server 2005 Integration Services
»
pass SSIS Variables to SQL Procedure in SSIS
pass SSIS Variables to SQL Procedure in SSIS
Rate Topic
Display Mode
Topic Options
Author
Message
Pulivarthi Sasidhar
Pulivarthi Sasidhar
Posted Friday, October 01, 2010 12:13 AM
SSC Eights!
Group: General Forum Members
Last Login: Wednesday, May 08, 2013 5:30 AM
Points: 870,
Visits: 522
hi,
I have two varibles .....
I want to execute the sp with two variables as parameters...
Execute testing.dbo.proc_TEmptest value1,value2
The value1 and value2 are the SSIS values of variables.
Please help how to pass the SSIS variables to SP as parameters
Thanks,
Pulivarthi
Post #996446
Koen Verbeeck
Koen Verbeeck
Posted Monday, October 04, 2010 6:05 AM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 2:11 AM
Points: 9,378,
Visits: 6,473
Try the following:
create a variable of type string. Let's call it str_ExecSP.
Populate this variable with the following expression:
"EXEC dbo.proc_TEmptest " + (DT_WSTR,50) @[User::value1] + " , " + (DT_WSTR,50) @[User::value2]
Then use this variable in an Execute SQL Task. As SQLSourceType, select variable.
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #997483
mp83399
mp83399
Posted Tuesday, August 28, 2012 6:53 PM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, August 28, 2012 6:50 PM
Points: 4,
Visits: 3
You can set up an ExecuteSQLTask. Put the call your sp as :
exec testing.dbo.proc_TEmptest ?,?
(The '?' are the place holders)Now map these two question marks to the SSIS variables in your package by going to the parameters tab in the ExecuteSQLTask.
Post #1351350
Koen Verbeeck
Koen Verbeeck
Posted Tuesday, August 28, 2012 11:40 PM
SSCrazy Eights
Group: General Forum Members
Last Login: Today @ 2:11 AM
Points: 9,378,
Visits: 6,473
mp83399 (8/28/2012)
You can set up an ExecuteSQLTask. Put the call your sp as :
exec testing.dbo.proc_TEmptest ?,?
(The '?' are the place holders)Now map these two question marks to the SSIS variables in your package by going to the parameters tab in the ExecuteSQLTask.
I sure hope the OP solved his problem 2 years ago
How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
Member of
LinkedIn
. My blog at
LessThanDot
.
MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1351396
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
