OLE Db Source and Variables

I created a OLE DB Source, and created a sql command text.

The issue is with parameters, I have to use the '?' to identify.

What if I have multiple variables of the same type scatter around, how can I define that?

Somthing like this would be good...

Declare @.month
set @.month = ?

select blah,@.month where month=@.month

or

How could I use the ADO Syntax and just put @.month?

Thanks,

Mardo

Hi Mardo,

OLE DB only supports '?' style parameters. You can use ADO style named parameters if you define an ADO.NET connection manager. Ensure you set the ConnectionType property of the Exec SQL Task to ADO.NET in order to reference the new connection manager.

Cheers,

Nick

http://nickbarclay.blogspot.com

|||another solution would be to use variables and expressions to dynamically create the sql statement.|||Execuse my ignorance but I only see a OLE DB Data Flow Source. I understand that ADO.NET can used name paramters but I can only seem to use that in Data Flow Destinations.

Marty|||

Guys, my apologies for being a bit misleading.

The .NET connection manager can be used in conjunction with the Execute SQL task (in the control flow) - when using this type of connection manager you are able to use named parameters. The OLE DB source adapter (in the data flow) is specifically OLE DB i.e. it must use an OLE DB connection manager to access the DB. As Duane posted earlier you can also "use variables and expressions to dynamically create the SQL statement", other than that you will have to use "?" as parameter placeholders.

Cheers,

Nick

http://nickbarclay.blogspot.com