Post reply

DTS: Querying a package

  • July 8, 2004 at 12:01 pm

    #63409

    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

    #513970

    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

    #514116

    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