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 |
|
withersAFC
Starting Member
2 Posts |
 Posted - 2007-11-26 : 06:45:49
|
Hi guysI've been looking at this for a while now, but no joy. I'm using SQL Server 2000, and the sa account.Ok , the problem!I have a stored procedure which executes a DTS package. Everything here is working ok, the DTS is definitely being executed but if i add the activeX script that does the work it fails.I've played around with it a little and it turns out the following code is what makes execution fail. Set xmlDoc=CreateObject("Microsoft.XMLDOM")If I run the DTS manually it works fine. I'm wondering if it's a permission thing.Once again, any help greatly appreciated. Cheers,withersAFC |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2007-11-26 : 07:19:16
|
| I would say it is as the scheduler runs under different permissions. Does the owner of the job have rights to the file system? |
 |
|
|
withersAFC
Starting Member
2 Posts |
Posted - 2007-11-27 : 05:10:38
|
Hi, thanks for your reply.I managed to get it working in the end. I used this code instead:Set xmlDoc=CreateObject("MSXML2.DOMDocument.4.0")Seems to do the job just as well, and doesn't complain when scheduled.Cheers |
|
|
|
|
|
|
DTS, ActiveX and XMLDOM