A scheduled dts package which contains odbc links to other data sources fails
I have use unc paths this fails. I have read the securtiy papers but this still does not run. I have other dts packages that
run fine but, this package is the source of all the other data that is required.

And what are the errors?
What is the ODBC datasource?
Only when scheduled ?
You read the article re: Executing a package as a job?

http://support.microsoft.com/?kbid=269074

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"shane" <anonymous (AT) discussions (DOT) microsoft.com> wrote

yes i have read the article 269074
DTSRun: Loading..
DTSRun: Executing..
DTSRun OnStart: DTSStep_DTSDataPumpTask_
DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005
Error string: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifie
Error source: Microsoft OLE DB Provider for ODBC Driver
Help file:
Help context:
Error Detail Records
Error: -2147467259 (80004005); Provider Error: 0 (0
Error string:
Error source:
Help file:
Help context:
DTSRun OnFinish: DTSStep_DTSDataPumpTask_
DTSRun: Package execution complete
I have tried udl files these dont work
When i test the odbc connection with the user name and passwork it verify's..
Manually it will run.

This error

80004005

says it is a permissions problem or that the source you are trying to
connect to cannot be seen. Are you using a system DSN ? Have you tried
logging in as the SQL Server Agent account and seeing if you can execute the
package manually?

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"shane" <anonymous (AT) discussions (DOT) microsoft.com> wrote