Does anybody know why in some cases you can use both connection types, in others you can't. Like for example, you start a data flow task with a Datareader Source which uses an ADO .NET connection manager, next you want to do a lookup and seems like the only type of connections you can use in a lookup table is the OLE DB.
So OLE DB is placed hard coded in a lookup task, and I thought things changed since the coming of OOP ...
I think ole db is ok
just when i use script component,i use ado.net
|||Your observation is correct -- Lookup currently only supports OLE DB connections. We hope to add ADO.NET connection support in the future.|||Ok
No comments:
Post a Comment