Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Posts
    2

    Unanswered: 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?

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401
    Are the SQL Server Startup account and the account you are logged in different ???
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Nov 2003
    Posts
    2
    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.

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    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 ?

  5. #5
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    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?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •