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 MVP
http://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