Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 Site Related Forums
 Article Discussion
 Article: Running Jobs (UNC vs Drive Letters )
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ask SQLTeam Question

0 Posts

Posted - 07/02/2000 :  00:00:00  Show Profile  Visit AskSQLTeam's Homepage  Reply with Quote
Russell writes "When we create a DTS package to import files from lets say Visual Foxpro and use UNC in ODBC, the package runs fine. However when we try to run the package as a job, it won't run . . .

Article Link.

Official SQLTeam Chef

85 Posts

Posted - 07/03/2000 :  10:02:07  Show Profile  Visit RocketScientist's Homepage  Reply with Quote
Maintaining Jobs

Another thing to consider for maintenance. UNC paths are nice, but server names do change. Store them in a table where possible to reduce the number of code changes you'll need to make when that happens.

Go to Top of Page

Starting Member

0 Posts

Posted - 08/02/2000 :  10:04:47  Show Profile  Reply with Quote
DTS Problem


We are having the same problem with a DTS package setup to truncate SQL tables and transfer the data from an access database to the SQL tables. When running the package from my machine the package can be excuted. But at some point the settings for the filename and tables to populate are lost or reset. This is a sporadic. Also after successfully running the package manually and then scheduling it also fails giving invalid path errors. The server on which the actual package is saved gives a catastrophic error when opening the package properties.
Some guidance on this would be greatly appreciated.

Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000