SSIS: using a variable name in SQL

[Darth Vodka]

hi

i've declared a vairable varMinDate and now, in an OLE source component, i'm trying to use it like this:-

SELECT Field1 FROM Table1 WHERE BusDay= @User::varMinDate

but i haven't got the syntax right



any ideas?

 

[SQL_Hell]

Hiya

For OLEDb source you need to specify the parameters like so:



SELECT Field1 FROM Table1 WHERE BusDay= ?

Then click on the parameters button and assign the parameter to the variable

 

[Darth Vodka]

ooooh, i see

aha

the parse doesn't seem to work, but it does work overall

can't properly test it atm, but will be this week

thanks a lot