Just thought I would apologize before anyone bitched.
"CR" <chris@fin2000.com> wrote in message
news:eLrouqtHCHA.368@tkmsftngp13...
> sql2k sp2
> I have a package that is very simple. It works fine untill I schedule it
and
> then try to run it from a job. I created an output file. Here is what it
> says:
>
> DTSRun: Loading...
>
> DTSRun: Executing...
>
> DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1
>
> DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2
>
> DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2
>
> DTSRun OnStart: Copy Data from REPORTBY to [fintracker].[dbo].[REPORTBY]
> Step
>
> DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1
>
> DTSRun OnStart: Copy Data from DEFECTS to [fintracker].[dbo].[DEFECTS]
Step
>
> DTSRun OnError: Copy Data from REPORTBY to [fintracker].[dbo].[REPORTBY]
> Step, 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: [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
>
>
>
> DTSRun OnFinish: Copy Data from REPORTBY to [fintracker].[dbo].[REPORTBY]
> Step
>
> DTSRun OnError: Copy Data from DEFECTS to [fintracker].[dbo].[DEFECTS]
> Step, 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: [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
>
>
>
> DTSRun OnFinish: Copy Data from DEFECTS to [fintracker].[dbo].[DEFECTS]
> Step
>
> DTSRun: Package execution complete.
>
> Any ideas???
> Thanks in advance.
>
>

Report this post to a moderator