Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS

Status
Not open for further replies.
VBXL

VBXL

Programmer
Joined
Jul 10, 2001
Messages
198
Location
GB
I have a server called EXAMPLE-33, how do i make a DTS package work using the xmlcmd command

i.e

EXEC master..xp_cmdshell "dtsrun /SEXAMPLE-33 /Usa /NDTSExmaple"
 
Sort by date Sort by votes
I have found the error for this problem but now i have another problem. When i set up a text file to import using mapped drives i get the following error message

Error string: Error opening datafile: Access is denied.

Why ???

It works when i use local drives
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

WMXTeam
  • Locked
  • Question Question
Convert DTS package to .Net
Replies
0
Views
226
WMXTeam
WMXTeam
smatthews
  • Locked
  • Question Question
Getting Server Does not Exist Error on SQL 2k DTS package running on SQL 2005
Replies
5
Views
347
smatthews
smatthews
sa0309
  • Locked
  • Question Question
SQL 2000 DTS transformation
Replies
0
Views
144
sa0309
sa0309
bmann
  • Locked
  • Question Question
Problem Opening 2000 DTS Packages using SQL Server 2005 HELP!!!!
Replies
2
Views
238
SQLBill
SQLBill
peac3
  • Locked
  • Question Question
dts package
Replies
1
Views
170
markros
markros

Part and Inventory Search

Sponsor

Back
Top