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.
| Author |
Topic |
|
yaman
Posting Yak Master
213 Posts |
 Posted - 2011-01-13 : 11:24:06
|
| Hello Sir , I have one dts in which we call 20 dts .This dts call at every thursday night .Out of 20, number 14 dts creating problem .This 14 number dts fetch data from MS access and loaded into sql server .Error is -- "W:\Financial Planning\CLI\Contract Analysis Database\Contract Analysis - Current Month.mdb' is not a valid path"When i execute this dts individually this dts running successfully .Please help me out Sir .why this dts is not running using batch file .Yaman |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-01-13 : 11:30:04
|
Is W:\... on the server or on your local machine?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-01-13 : 11:44:15
|
| check dynamic properties task and see if you've configured any variable or anything for path property. check source where you store config values and make sure its getting a valid path in server.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
yaman
Posting Yak Master
213 Posts |
Posted - 2011-01-13 : 12:24:02
|
quote:
Originally posted by webfred
Is W:\... on the server or on your local machine?
No, you're never too old to Yak'n'Roll if you're too young to die.
No , W:\... is remote server path .Yaman |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-01-13 : 14:29:26
|
| Use the unc path. The W: mapping is valid for you, not for the SQL Agent service account. |
|
|
|
|
|
|
Need Help On DTS