Friday, March 9, 2012

DTS package - Network error

Hey, I am trying to execute a DTS package that imports a flat text file from a remote server to the database.
It works fine from the Enterprise Manager, but form the Query analyzer and my code I am getting the following error:

Error string: Error opening datafile: The network name cannot be found.
Error source: Microsoft Data Transformation Services Flat File Rowset Provider
Error Detail Records:
Error: 67 (43); Provider Error: 67 (43)
Error string: Error opening datafile: The network name cannot be found.
Error source: Microsoft Data Transformation Services Flat File Rowset Provider
Help file: DTSFFile.hlp
Help context: 0

Here is how I execute the dts:
EXEC master..xp_cmdshell 'dtsrun /S <server> /N <package_name> /E'

The file that I am trying to imports is on a different server
Whenever I use the "My Network Places", I can access the file (\\server\folder\filaname).
Also, once again when I execute the package from the enterpise manager it works fine. Any ideas?Are the SQL Server Startup account and the account you are logged in different ?|||Good point but now luck.
I just tried as the same user ("sa") from both enteprise manager and query anlyzer and still doesn't work from the query analyzer.|||Do the startup service accounts (for sql server and agent) have access to that network drive ? Also, what happens if you run dtsrun from the command line ?|||I would guess that your server is a seperate machine from the machine you are running enterprise manager on.

I would guess that this machine does not have access to the network drive you are trying to use.

Is your file referenced using UNC or are you trying to use a mapped drive?

No comments:

Post a Comment