March 1, 2002 at 9:51 am
Hello!
I have 3 packages that I would like to schedule as jobs. All works fine when I execute them in SQL Manager, but when I try to run them as jobs only 1 pass. In this one I import data from a local access database, and in the 2 others I try to import data from a Btrieve database. I have to use the following driver: MERANT 3.50 32-BIT Btrieve (*.dta). I have to map to a specific drive, in this case p:\ to find the btrieve files. I found some information that SQL Server Agent cannot see mapped drive letters and bacause of this fail. I have tried to use UNC path but Btrieve doesn't like it (in this case it fails even to execute it in SQL Manager)
I get the following error message:
.... DTSRun: Executing... DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart:
DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart:
DTSStep_DTSDataPumpTask_1 DTSRun OnError:
DTSStep_DTSDataPumpTask_1, Error = -2147008507
(80074005) Error string: Unspecified error
Error source: Microsoft Data Transformation Services
(DTS) Package Help file: sqldts.hlp Help
context: 1100 Error Detail Records: Error: -
2147008507 (80074005); Provider Error: 0 (0) Error
string: Unspecified error Error source:
Microsoft Data Transformation Services (DTS) Package
Help file: sqldts.hlp Help context: 1100
Error: -2147467259 (80004005); Provider Error: 75
(4B) Error string: Error source: Microsoft
OLE DB Provider for ODBC Drivers Help file:
Help context: 0 DTSRun OnFinish: DTSStep...
Process Exit Code 1. The step failed.
What do I have to do fix this?
/Christer
March 1, 2002 at 9:59 am
Hello..
I always copy the files need via BCP first from Dest to source (local folder on Server where SQL is installed), then Run DTS Package using the local copied file..
hopes this helps
March 1, 2002 at 11:20 am
A few suggestions.
1. copy the files to the local drive using some other process.
2. I map drives by loggin in as the SQL Agent/Server account and create the mapping. It should then be there later.
3. Use UNC naming \\servername\share.
Steve Jones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
March 1, 2002 at 5:31 pm
If worst come to worse you could write an external app that can run in the user environment that can see the mapped drive to kick off the DTS package. I had to do this with a package where I could not get rights to the server for SQLAgent. Mine which I will glad to give you runs in the systray and kicks off a batch file which has the command for the DTS package and outputs the run to a text log.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply