Execute DTS not work... Help me please.

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.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

Execute DTS not work... Help me please.

Author

Topic

prompratan
Starting Member

30 Posts

Posted - 2005-10-30 : 20:52:11

http://img436.imageshack.us/img436/2931/pic3xs.jpg

This link have image for my problem.

First. I use
DTSRun /S"intranet" /U"sa" /P"aaaa" /N"db_hr2-ImportDataC03010204"
run on dos is good work.

Last. I use
EXEC master..xp_cmdshell 'DTSRun /S"intranet" /U"sa" /P"aaaa" /N"db_hr2-ImportDataC03010204"'
run on query analyzer is not work.

Thank you for all answer.

fr33j6ck
Starting Member

1 Post

Posted - 2005-10-31 : 08:29:20

try this without double quotes and spaces separating args.

EXEC master..xp_cmdshell 'DTSRun /S intranet /U sa /P aaaa /N db_hr2-ImportDataC03010204'

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources