October 7, 2009 at 2:07 pm
I've tried this multiple ways, and nothing works so far. I've got a SSIS package that extracts data from some Firebird databases using an ODBC connection. The Firebird driver only seems to recognize a mapped drive, not UNC connections. It works fine in the designer, as long as I've got the drives mapped. I've tried a sql task that connects the drives using xp_cmdshell, tried running a job that maps the drives in the first step of the job, and tried using persistent connections. When it gets to the data flow step, it fails because it can't find the mapped drive. Any suggestions?
October 7, 2009 at 2:12 pm
You might want to look at using a Linked Server.
October 7, 2009 at 2:42 pm
Lynn Pettis (10/7/2009)
You might want to look at using a Linked Server.
Still wants a mapped drive.
October 7, 2009 at 2:59 pm
Can't you map it at the OS level and just set it to reconnect at logon?
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply