Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    2

    Unanswered: Run DTS pkg from stored procedure

    Hi,

    I have created a DTS package which creates a table and imports a file located on a public drive on another server into this table. When I execute this package it runs fine, but when I run this package from a stored procedure it creates the table and then stops.

    I am using the UNC path in the file name and Im executing the stored procedure as an SA user.

    Does anyone have any ideas why this isnt working?

    Thanks,
    Jeano

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    SA does not have access to network sources... Use domain account instead.

  3. #3
    Join Date
    Jan 2004
    Posts
    2

    Reply

    I changed the 'owner' of the DTS package to use NT authentication and ran the stored procedure from Query Analyser under an NT user and its still not working. Is there specific permissions I can give this user to access another network source?

  4. #4
    Join Date
    Jan 2004
    Posts
    49
    see MSDN

Posting Permissions

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