"shane" <anonymous@discussions.microsoft.com> wrote in message
news:D29AA48A-F8D7-4666-9C65-61C9FDFD70AE@microsoft.com...
> 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

"shane" <anonymous@discussions.microsoft.com> wrote in message
news:4ABEEF01-6E68-4F2A-9DAA-46523C391139@microsoft.com...
> yes i have read the article 269074.
> DTSRun: Loading...
> DTSRun: Executing...
> DTSRun OnStart: DTSStep_DTSDataPumpTask_1
> DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147467259 (80004005)
> Error string: [Microsoft][ODBC Driver Manager] Data source name not found
and no default driver specified
> Error source: Microsoft OLE DB Provider for ODBC Drivers
> Help file:
> Help context: 0
> Error Detail Records:
> Error: -2147467259 (80004005); Provider Error: 0 (0)
> Error string:
> Error source:
> Help file:
> Help context: 0
> DTSRun OnFinish: DTSStep_DTSDataPumpTask_1
> 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.