Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
PatDeV
Posting Yak Master
197 Posts |
 Posted - 2009-01-05 : 23:03:07
|
| Hi all,how can i call SP in SSIS package. I tried with Execute SQL Task but not able to do it. i need to pass package variable as the parameter to sp.such as exec sp packagevariableHow can i do it!! please helpthanksPat |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-05 : 23:43:16
|
| Use ? to denote parameter in SQL StatementMap variables according to parameters and datatype in Parameter Mapping tab and then Execute. |
 |
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2009-01-05 : 23:44:37
|
| I am trying this but getting error at +"exec [sp_1] @filename='"+ @[User::FileName] +"'" |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-05 : 23:46:56
|
| Did you use as I said? |
|
|
|
PatDeV
Posting Yak Master
197 Posts |
Posted - 2009-01-05 : 23:52:33
|
| yeah but when i see in the progress i don;t see the acutal value that sp used i only see sp ? and if the sp executed twice the i see twot imes sp ?Thanks |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-06 : 00:11:35
|
| http://www.sqlis.com/post/The-Execute-SQL-Task.aspx |
|
|
|
|
|
|
call sp and pass variable value in SSIS Package