Hi,
I can't possibly find any information of actually how to use a data source object or a data source view object in a package.
After I've added a SQL Server data source object and a data source view object to my project I can't use any of them in almost any of the source or destination data flow component.
I've created an entry for the Data Source in the Connection Manager pane, but the only connection where I can see the Data Source object listed is in the DataReader source component. It lists the Data Source object amongst all available connections to use. Is this all? What am I doing wrong?
Moreover, I can't find any option to add a Data Source VIEW object to anything. How am I supposed to use this kind of object in SSIS?
Thanks for enlightening me!
Axel Dahmen
>> Stay informed about: How to: Use Data Source Object and Data Source View Object?