sql server dts: DTS export data from Sqlserver to MDB -- sql server dts

Re: DTS export data from Sqlserver to MDB

Allan Mitchell
11/13/2004 10:24:58 AM

sql server dts:

Remember DTS is a client application and everything you see and do is
relative to the place that you press the "Go" button. The drive letter you
specify (Z) would seem to be a mapped drive and is therefore speific to a
user so I would try altering the location of the Access MDB to a UNC path

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com

[quoted text, click to view]

DTS export data from Sqlserver to MDB

kids_pro
11/13/2004 11:10:44 AM

Hi there,

I setup a DTS package to export a table from sql server to microsoft acess
database stored on the network drive. Z:\(0) Payment
Cosolidate\Payment_Transfer.MDB

I can execute the DTS package from Enterprise Manager but I want to allow my
boss to be able to export this table by himself so I decided to create a
store procedure and call it from ASP.net page.

However when I execute the storeprocedure using
EXECUTE master..xp_cmdshell 'dtsrun /S localhost /N
Export_PaymentFromSQL_To_MDB /E'

I got an error message saying that :
... Error string: 'Z:\(0) Payment Cosolidate\Payment_Transfer.MDB' is not a
valid path is not a valid path. Make sure that the path name is spelled
correctly and that you are connected to the server on which the file
resides. ...

How can I fix this problem?
Is there any otherway to execute DTS package from store procedure without
using the 'dtsrun utilities'?

Regards,
Kids