Hi,
Not sure if this is the right thread or not, but I had a co-worker create some scripts to pull data out of a Timberline database (which I believe runs on SQL server) and drop the info into an access db. It was working fine for a couple of months, now it is not working. If anyone can make heads and tails out of the errors, I would be very much happy.
The errors:
Step 1, DROP TABLES
Executed as user: DERM_NTDOM\admin. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun: Package execution complete. Process Exit Code 0. The step succeeded.
Step 2, COPY 25 TABLES
Executed as user: DERM_NTDOM\admin. ...tart: Create Table [timberline].[dbo].[LEASE_PML_LEASE] Step DTSRun OnStart: Create Table [timberline].[dbo].[LEASE_PML_LEASE_CHARGE_CONTROLS] Step DTSRun OnStart: Create Table [timberline].[dbo].[LEASE_PML_LEASE_CHECKLIST_ITEM] Step DTSRun OnStart: Create Table [timberline].[dbo].[LEASE_PML_LEASE_CUSTOM_FIELDS] Step DTSRun OnFinish: Create Table [timberline].[dbo].[LEASE_PML_LEASE_CHECKLIST_ITEM] Step DTSRun OnFinish: Create Table [timberline].[dbo].[LEASE_PML_LEASE_CHARGE_CONTROLS] Step DTSRun OnFinish: Create Table [timberline].[dbo].[LEASE_PML_LEASE_CUSTOM_FIELDS] Step DTSRun OnStart: Copy Data from LEASE_PML_LEASE_CHARGE_CONTROLS to [timberline].[dbo].[LEASE_PML_LEASE_CHARGE_CONTROLS] Step DTSRun OnStart: Copy Data from LEASE_PML_LEASE_CHECKLIST_ITEM to [timberline].[dbo].[LEASE_PML_LEASE_CHECKLIST_ITEM] Step DTSRun OnStart: Copy Data from LEASE_PML_LEASE_CUSTOM_FIELDS to [timberline].[dbo].[L... Process Exit Code 26. The step failed.
Step 3, COPY 1 TABLE
Executed as user: DERM_NTDOM\admin. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Create Table Results Step DTSRun OnFinish: Create Table Results Step DTSRun OnStart: Copy Data from Results to Results Step DTSRun OnError: Copy Data from Results to Results Step, Error = -2147217843 (80040E4D) Error string: [Timberline][ODBC Driver][DLL]No such database. Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147217843 (80040E4D); Provider Error: 1203 (4B3) Error string: [Timberline][ODBC Driver][DLL]No such database. Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: Copy Data from Results to Results Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.
Thanks in advance.
James
MCP, MCSE
Not sure if this is the right thread or not, but I had a co-worker create some scripts to pull data out of a Timberline database (which I believe runs on SQL server) and drop the info into an access db. It was working fine for a couple of months, now it is not working. If anyone can make heads and tails out of the errors, I would be very much happy.
The errors:
Step 1, DROP TABLES
Executed as user: DERM_NTDOM\admin. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun: Package execution complete. Process Exit Code 0. The step succeeded.
Step 2, COPY 25 TABLES
Executed as user: DERM_NTDOM\admin. ...tart: Create Table [timberline].[dbo].[LEASE_PML_LEASE] Step DTSRun OnStart: Create Table [timberline].[dbo].[LEASE_PML_LEASE_CHARGE_CONTROLS] Step DTSRun OnStart: Create Table [timberline].[dbo].[LEASE_PML_LEASE_CHECKLIST_ITEM] Step DTSRun OnStart: Create Table [timberline].[dbo].[LEASE_PML_LEASE_CUSTOM_FIELDS] Step DTSRun OnFinish: Create Table [timberline].[dbo].[LEASE_PML_LEASE_CHECKLIST_ITEM] Step DTSRun OnFinish: Create Table [timberline].[dbo].[LEASE_PML_LEASE_CHARGE_CONTROLS] Step DTSRun OnFinish: Create Table [timberline].[dbo].[LEASE_PML_LEASE_CUSTOM_FIELDS] Step DTSRun OnStart: Copy Data from LEASE_PML_LEASE_CHARGE_CONTROLS to [timberline].[dbo].[LEASE_PML_LEASE_CHARGE_CONTROLS] Step DTSRun OnStart: Copy Data from LEASE_PML_LEASE_CHECKLIST_ITEM to [timberline].[dbo].[LEASE_PML_LEASE_CHECKLIST_ITEM] Step DTSRun OnStart: Copy Data from LEASE_PML_LEASE_CUSTOM_FIELDS to [timberline].[dbo].[L... Process Exit Code 26. The step failed.
Step 3, COPY 1 TABLE
Executed as user: DERM_NTDOM\admin. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Create Table Results Step DTSRun OnFinish: Create Table Results Step DTSRun OnStart: Copy Data from Results to Results Step DTSRun OnError: Copy Data from Results to Results Step, Error = -2147217843 (80040E4D) Error string: [Timberline][ODBC Driver][DLL]No such database. Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147217843 (80040E4D); Provider Error: 1203 (4B3) Error string: [Timberline][ODBC Driver][DLL]No such database. Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: Copy Data from Results to Results Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.
Thanks in advance.
James
MCP, MCSE
