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.
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?