Passing Parameters in SSIS Oledb

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

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

0	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

0	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

0	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

0	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

0	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

Latest Posts