DatabaseDude
Programmer
I have a DTS package that runs properly when executed manually, but fails when executed via schedule.
The error message is "[TimberlineODBC][TimberlineODBCEngine ODBC Driver][DRM File Library]Drive or directory unavailable [IO-WIN 3] Screen\OD.scr" (Complete error message appears below, at the end of the posting)
It uses a system DSN that links to Timberline. The DSN is mapped to T:\Timberline Office\TSDATA\SAMPLE, with a valid username/password.
The package fails when using Windows authentication, and also when using Windows & SQL Server authentication.
Timberline support indicated that it is a problem with drive mapping, and something to do with the startup script on Windows Server.
FWIW I'm lost when it comes to server setup and upkeep, and that's the chores of another person, so you may have to dumb down your response a bit for my benefit
Any ideas?
Thanks in advance!
Bryant
--- Begin error message --
Executed as user: BWPSQL\SYSTEM. ... DTSRun OnStart: Copy Data from MASTER_APM_VENDOR to [TestPO].[dbo].[MASTER_APM_VENDOR] Step DTSRun OnError: Copy Data from MASTER_APM_VENDOR to [TestPO].[dbo].[MASTER_APM_VENDOR] Step, Error = -2147467259 (80004005) Error string: [TimberlineODBC][TimberlineODBCEngine ODBC Driver][DRM File Library]Drive or directory unavailable [IO-WIN 3] Screen\OD.scr Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 4019 (FB3) Error string: [TimberlineODBC][TimberlineODBCEngine ODBC Driver][DRM File Library]Drive or directory unavailable [IO-WIN 3] Screen\OD.scr Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: Copy Data from MASTER_APM_VENDOR to [TestPO].[dbo].[MASTER_APM_VENDOR] Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.
--- End error message --
The error message is "[TimberlineODBC][TimberlineODBCEngine ODBC Driver][DRM File Library]Drive or directory unavailable [IO-WIN 3] Screen\OD.scr" (Complete error message appears below, at the end of the posting)
It uses a system DSN that links to Timberline. The DSN is mapped to T:\Timberline Office\TSDATA\SAMPLE, with a valid username/password.
The package fails when using Windows authentication, and also when using Windows & SQL Server authentication.
Timberline support indicated that it is a problem with drive mapping, and something to do with the startup script on Windows Server.
FWIW I'm lost when it comes to server setup and upkeep, and that's the chores of another person, so you may have to dumb down your response a bit for my benefit
Any ideas?
Thanks in advance!
Bryant
--- Begin error message --
Executed as user: BWPSQL\SYSTEM. ... DTSRun OnStart: Copy Data from MASTER_APM_VENDOR to [TestPO].[dbo].[MASTER_APM_VENDOR] Step DTSRun OnError: Copy Data from MASTER_APM_VENDOR to [TestPO].[dbo].[MASTER_APM_VENDOR] Step, Error = -2147467259 (80004005) Error string: [TimberlineODBC][TimberlineODBCEngine ODBC Driver][DRM File Library]Drive or directory unavailable [IO-WIN 3] Screen\OD.scr Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 4019 (FB3) Error string: [TimberlineODBC][TimberlineODBCEngine ODBC Driver][DRM File Library]Drive or directory unavailable [IO-WIN 3] Screen\OD.scr Error source: Microsoft OLE DB Provider for ODBC Drivers Help file: Help context: 0 DTSRun OnFinish: Copy Data from MASTER_APM_VENDOR to [TestPO].[dbo].[MASTER_APM_VENDOR] Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.
--- End error message --