Schedule a DTS package that uses ODBC 
Author Message
 Schedule a DTS package that uses ODBC
Hi All,

I have an ODBC datasource that I use as the connection for
a dts package and wish to schedule that package. However,
I haven't been successfull in scheduling such a job. Are
there issues with using an ODBC connection in a scheduled
job??



Sat, 22 May 2004 05:50:40 GMT
 Schedule a DTS package that uses ODBC

Not necessarily issues but you need to remember that it will
be running under the security context of the SQL Agent
account and it's running on the server. When you test it
from your PC, it's running on your PC and under your
security context. Issues related to this are typically what
causes problems when running DTS packages as jobs. Packages
execute on the PC where execution was initiated and under
the security context of whatever user executed the package.
In terms of the DSN, you also need to make sure that you set
up a system DSN on the server with the same settings as
whatever you had set it up with on the PC where the package
was being executed.

--Sue

On Mon, 3 Dec 2001 13:50:40 -0800, "Terry Pino"

Quote:

>Hi All,

>I have an ODBC datasource that I use as the connection for
>a dts package and wish to schedule that package. However,
>I haven't been successfull in scheduling such a job. Are
>there issues with using an ODBC connection in a scheduled
>job??



Sat, 22 May 2004 11:27:55 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. scheduling wizard for DTS package uses unknown cmd line parameter

2. Using SQL Agent to Schedule Execution of a DTS Package

3. Schedule a DTS package using Transact SQL

4. Scheduling DTS Packages via DTS, SQLDMO COM Object

5. Scheduling DTS Packages via DTS, SQLDMO COM Object

6. DTS Package won't schedule / Help with DTS

7. DTS Package won't schedule / Help with DTS

8. Using DTS from VB - DTS.Package not defined?

9. using a dts to run several other dts packages in SQL 7

10. Making 1 packages for DTS 7 and DTS 2000 using VB

11. Unable to schedule DTS Package

12. Schedule DTS Package


 
Powered by phpBB® Forum Software