July 8, 2004 at 12:01 pm
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!
smv929
July 8, 2004 at 11:06 pm
Right Click on Workflow, go to "Workflow Properties" / "Options" tick DSO Rowset Provider.
Don't choose "Properties" as that won't give you what you want.
DB
The systems fine with no users loggged in. Can we keep it that way ?br>
July 9, 2004 at 9:44 am
Got it! Thanks.
smv929
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply