DTS package from Access97

[ray_nl]

Hi everyone,
I've got a problem. I'm busy trying to execute a DTS-
package on an SQL7 server from Access97.
I've created two solutions which work fine from the query
analyzer on SQL7. If I try to execute them via a
passthrough query in Access97 nothing happens

There isn't any message mhich says what is going wrong, it
just doesn't do anything. In other parts of the access97
program I use queries and they work fine!

Does anybody know a way to see what goes wrong or what I
have to look into?
The 2 soltions I use are:
1. An xp cmd_shell with a DTSRUN
2. As explained in this article:
http://www.databasejournal.com/features/mssql/article.php/1
459181

If anyone needs more info just ask!
Thanks in advance, Raymond
..

 

[Jose Hernandez]

First of all Do you have permissions to run xp_cmdshell? Are you using the
same account in QA and Access97?
Otherwise On the Query Properties window set Returns Records = Yes this
should give you output regarding your SQL command.

I use this command with a trusted connection;
EXEC master..xp_cmdshell 'DTSRun.exe /E /S YourServer /N DTS_PACKAGE_NAME'

If this does not help post your Query SQL.

HTH

Jose