Package fails as SQLAdmin

[xtreemnet]

Hi,

I ma importing a csv file into SQL table on my local server. The package runs OK from my local server when run through SQL server agent.
But it fails when run after deployment to a network server and run through SQL server agent. When executed from the MSDB tree on network server it runs OK.

Can someone plase guide me on my problem.


Thanks,

 

[AlexCuse]

I imagine this would be a permissions or drive mapping problem.

What step is it failing on? Where is it importing the data to? Where is the .csv file stored? There are a ton of things that anyone will need to know to answer your question.

Have a look at this, it will help you to put together the information taht people will need to give you an answer in your posts.

faq183-874

Hope this helps,

Alex



Ignorance of certain subjects is a great part of wisdom

 

[MDXer]

Sounds like permission issues with the SQL agent account.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck