SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

AskSQLTeam
Ask SQLTeam Question

USA
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.

RocketScientist
Official SQLTeam Chef

USA
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

Anonymous
Starting Member

0 Posts

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

Hi

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.
Thanks

Go to Top of Page
  Previous Topic Topic Next Topic  
 New 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.25 seconds. Powered By: Snitz Forums 2000