This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C17C20.23ABBDA0
Content-Type: text/plain;
	charset="iso-8859-1"

This works well except I keep getting the following error:   "   Error
string:  Error opening datafile: The system cannot find the path specified.
"
I have checked and I can get to the file location from the SQL server, also
the folder and the file are open for public use.
Anyone have any suggustions???
Thanks.
-----Original Message-----
From: vani [mailto:vani@a...]
Sent: Friday, November 30, 2001 8:35 PM
To: sql language
Subject: [sql_language] RE: Executing a DTS package from a stored proceedure


Syntax for executing dts package
EXEC [master].[dbo].[xp_cmdshell] "dtsrun /S Your ip address here /U
username /P password /N dts package name"
 
 
Ex.
 
EXEC [master].[dbo].[xp_cmdshell] "dtsrun /S 234.34.34.216 /U yahoo /P yahoo
/N dts_yahoo"
To run dts package from stored procedure user should have owner
privileges.... Give db_owner privileges 
 
 
 
 
 
 
 
-----Original Message-----
From: GREG ZIMMERMAN [mailto:gzimmerman@w...] 
Sent: Saturday, December 01, 2001 1:47 AM
To: sql language
Subject: [sql_language] Executing a DTS package from a stored proceedure
 
Help..... Is it possible to execute a DTS package from a sql stored
procedure?
Thanks

Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid
=rn_ebooks 

gzimmerman@w...
Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid
=rn_ebooks