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?

    thanks!

    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!


    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!

  • This was removed by the editor as SPAM

  • When you say "name of the table I am importing from", it sounds like you are executing a BULK INSERT or bcp call. If that is true, you need to either use the DTS variables or a specific filename to perform the operation.

    Guarddata-

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply