Has anyone had experience querying a package? You are supposed to be able to query using:
SELECT * FROM OPENROWSET('DTSPackageDSO', '/Usa /Ppassword /S /NPackageName /Mpassword', 'Select *')
I would use the package that pulls data from a table in a non-sql database (Progress).
Questions:
1. The documentation in BOL refers to specifying a setting on a parameter on the WorkFlow properties' General tab. But I don't see this.
2. Anyone know how performance is?
3. What type of package design is required? I suppose a connection to the datasource and a Transform data task?
Thanks!