Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS Ignoring Global Variables

Status
Not open for further replies.

christer99

IS-IT--Management
Dec 3, 2001
247
I am trying to use global variables to dynamically set the source for a DBASE import. I have also tried using a query and an INI files. It works when I exe cute the DTS directly local packages, but not when I run it from a command prompt or when I schedule the package. My DTS package is totally ignoring any dynamic properties when being run from the command prompt, when scheduled or when being run from a script. It only works when I run it directly from local packages. Any ideas? I think it is something with security but can't figure out what.

DTSRun /N "ImportDataTM36" /V "{AF389C5D-D02D-436C-B03D-C0CBB601C81F}" /F "C:\ARP\ImportDataTM36.dts" /A "TAMDATA":"8"="D:\TAM" /W "0"
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top