DTS Question - Help !
-
Ok, this is a re-post from the SQL section for a friend, but he and I are both stumped on this, does anyone have any ideas? Jason Weibel wrote: Inside a DTS package I need to execute a self-extracting zip file. I am currently using CreateObject("WScript.Shell") which works when run in VB or executing the DTS package directly. However when a job is used to execute this package the extracted file gets placed to an undetermined directory. So my questions are: Why does the extracted file get placed in the correct directory when I execute the code and not when a scheduled job runs it? What can I do to get the scheduled job to extract the file to the correct directory? I’m stumped on this one any help is greatly appreciated. Nick Parker
-
Ok, this is a re-post from the SQL section for a friend, but he and I are both stumped on this, does anyone have any ideas? Jason Weibel wrote: Inside a DTS package I need to execute a self-extracting zip file. I am currently using CreateObject("WScript.Shell") which works when run in VB or executing the DTS package directly. However when a job is used to execute this package the extracted file gets placed to an undetermined directory. So my questions are: Why does the extracted file get placed in the correct directory when I execute the code and not when a scheduled job runs it? What can I do to get the scheduled job to extract the file to the correct directory? I’m stumped on this one any help is greatly appreciated. Nick Parker
These messages are kind of amusing. What kind of bizarre logic tells you it's OK to post off topic in a group just because the people in the appropriate group didn't immediately do your work for you? -- Eric Move along, nothing to see here.
-
These messages are kind of amusing. What kind of bizarre logic tells you it's OK to post off topic in a group just because the people in the appropriate group didn't immediately do your work for you? -- Eric Move along, nothing to see here.
Eric Kenslow wrote: What kind of bizarre logic tells you it's OK to post off topic in a group just because the people in the appropriate group didn't immediately do your work for you? I guess I wasn't aware that was a real structure to the Message Board/Lounge etiquette. I assumed I would receive some off messages by this, thanks for noting this :) Nick Parker