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

    Question Unanswered: global variables in dtspump task

    I have two connections, an oracle and sqlserver. the dtspump task is pulling data from oracle to sqlserver. I am trying to automate this package by substituting the where clause values to variables since they are based on year and month. My question is - how does one use global variables in a dtspump task? How can I use variables to do this? Can it be done or do I need to use an Active X script for it?

    thanks for any help.
    novice user

  2. #2
    Join Date
    Aug 2002
    May check with SQL DTS website.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

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