Creating parameterized query in SSIS package
in [Programming SQL]
|
From: Gloria on 17 Jul 2008 07:33 "jhofmeyr(a)googlemail.com" wrote: > Hi Gloria, > > The Property Path is a string which tells dtexec what package property > you are trying to set. In your case it's basically a reference to the > variable you're trying to set, and will look something like: > \Package.Variables\[User::LotName].Properties[Value] > > Good luck! > J > Thanks for the info. I think my problem is with the parameterized query. When I use a hard-coded value in the query and I 'Preview' it, I get the expected data. When I try to parameterize it, I get 'no value for one or more parameters'. In the SQL 2000 version, when you wanted to test a query with a parameter, it would show a dialog box asking for the parameter value. I don't know if SQL 2005 does not do that or I have something wrong. I put a default value in the variables list and it gives me the same error message. To make sure I am doing this right, I am using OLE DB Source Editor. In the query, I put a '?' for the parameter. In the 'Set Query Parameters' dialog, I map Parameters, which is set to 0 to the variable, User::LotName. If anyone sees something wrong, let me know. Thanks, G
From: Gloria on 17 Jul 2008 07:42 "jhofmeyr(a)googlemail.com" wrote: > Hi Gloria, > > The Property Path is a string which tells dtexec what package property > you are trying to set. In your case it's basically a reference to the > variable you're trying to set, and will look something like: > \Package.Variables\[User::LotName].Properties[Value] > > Good luck! > J > SUCCESS!!! Disregard the previous reply to your email...it is working! THANKS! The problem was that my variable was not set and silly me, I was double-clicking an old .dtsx file...Oops! THANKS FOR YOUR HELP
From: jhofmeyr on 18 Jul 2008 04:34
No problem - happy to help :) J |