• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 103
  • Last Modified:

SSIS Package behaves differently under different user names

Hi there,

I have a basic SSIS package that loops through a file of a specific search term on one server and for each file matching the requirements moves it to another server location on a network path.

Now when I run the package on the production server as a stand alone DSTX package (via a bat file) it works fine. However, when my colleague tries to run the same package in the same way using the admin account on the server it does not move the file but the package reports no errors.

I really have no idea apart from guessing it has something to do with the user but even then I don't know how to begin to approach it.

Thanks,

OS

-ps diagram below
Move-File.jpg
0
onesegun
Asked:
onesegun
1 Solution
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Check the permissions of both accounts. Should be some difference between your accounts.
0
 
onesegunAuthor Commented:
Hi Vitor,

Yes it was somewhat of a permissions issue with my colleagues account. He didn't have access to the server which the package was trying to access to get the files.

I sorted it out with my network admin and now it's fine.

Thanks
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now