Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
christer100
Starting Member
6 Posts |
 Posted - 2005-11-13 : 22:31:00
|
| I have a problem with a DTS package. It works fine executing directly executing it from local packages, but when I run it from the command prompt, in a script or schedule it, it just runs and IGNORES the dynamic properties. I think it something with security, but I tried all day figuring out what's the problem. I have tried both global variables, using a SQL query and a .INI file to assign the dynamic property, which works fine when I execute from local packages so obvioiusly I am doing it at least half right. Again the problem is that when I run it from a command prompt or sechedule it, the DTS package is just taking the default values and ignores any dynamic values. Any ideas. |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
|
|
|
DTS Ignoring global variables?