Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003

    Unanswered: running a query within a DTs package

    IF a run a query from within a DTS package will I have to use complete instructions, i.e. will I have to include in the query the name of the table that i am importing from or will the DTS package assume this?

    If riding in a plane is flying, then riding in a boat must be swimming. To experience the element, get out of the vehicle. Skydive!

  2. #2
    Join Date
    Jul 2003

    Re: running a query within a DTs package

    Are you referring to performing a sql or transact/sql statement from within an execute sql task?

    If so, despite you establishing a connection with one or more servers/dbs (transform data task or not) you should have to specify the table you are referencing... when you are in the execute sql task properties (ie when you double click) you need to specify which server connection you are using in order to reference that specific table. There is a drop down box in the task's properties window called existing connection... pick the connection which references the server/db that contains the table which you will be performing a query on... You don't want to perform an update statement on tblcustomer (located in db1) and not specify the correct connection in which to find it!

    I hope that is what you were asking for if not, give a little shout back with a little more detail and we'll see what we can do.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts