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"
DTSRun /N "ImportDataTM36" /V "{AF389C5D-D02D-436C-B03D-C0CBB601C81F}" /F "C:\ARP\ImportDataTM36.dts" /A "TAMDATA":"8"="D:\TAM" /W "0"