Passing Parameters in SSIS Oledb

Posted by Nishithraj under Sql Server on 1/15/2010 | Views : 73572 | Status : [Member] | Replies : 7
Freinds,

I need to pass parameters for a sqlquery(not a Stored proc) in Oledb object of SSIS. I have tried to give the parameters as "?" it created corresponding parameters in @[User: format. While running through the option ExecuteSQL its working fine. But if we are running the application(by pressing F5 or directly), the application is not prompting for parameters.

The result is showing empty row too...

Any guess???

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan



Responses

Posted by: Vuyiswamb on: 1/15/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
SSIS is like a CLass Library it does not have an Interface when you will see a popup asking you for a parameter(If that is what you are looking for). If you want to Execute a package that has variables you must first define it in SSIS(Menu-->SSIS-->Variables) you can add variables and the order of the variables is important. Beware that it matters where you clicked at while creating a variable. After you have created a variable you can invoke the package from C# and pass the parameter from there. is this what you expect?

Thank you for posting at DotnetFunda

Vuyiswa Maseko

Thank you for posting at Dotnetfunda
[Administrator]

Nishithraj, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nishithraj on: 1/15/2010 [Member] Bronze

Up
0
Down
Vuyiswamb

Thanks for your information

Do you have any links which explain the same scenario...

Remember that I'm just connecting through the OLEDB object of Data flow.

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan

Nishithraj, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 1/15/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
look at this
http://msdn.microsoft.com/en-us/library/ms141670.aspx

http://www.simple-talk.com/sql/ssis/passing-variables-to-and-from-an-ssis-task/

Thank you for posting at Dotnetfunda


Vuyiswa Maseko

Thank you for posting at Dotnetfunda
[Administrator]

Nishithraj, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nishithraj on: 1/19/2010 [Member] Bronze

Up
0
Down
After going through several websites I found that this is an issue of SSIS tool. Oledb can't have parameters

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan

Nishithraj, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 1/20/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
but i thought you were going to use the Execute SQL Task. use that to use parameters

Thank you for posting at Dotnetfunda
[Administrator]

Nishithraj, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nishithraj on: 1/20/2010 [Member] Bronze

Up
0
Down
Oh.. Okey, no problems. However the link that you provided me the information about SQL Task and the how to use parameters over there.

Thanks for your information....

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan

Nishithraj, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 1/20/2010 [Member] [MVP] [Administrator] NotApplicable

Up
0
Down
Thank you for posting at Dotnetfunda

Vuyiswa Maseko

Thank you for posting at Dotnetfunda
[Administrator]

Nishithraj, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response