CODEWITHSUNDEEP
ssissql-server-2008-r2
Gelo Reyes
Gelo Reyes

Reputation: 59

SSIS Get Image from Shared Folder

I have this DTSX Package in SSIS for copying images from shared folder.

DTSX Package

The Get Image Path is connecting to database to get the shared folder path (Im using credentials when accessing this path from explorer), the Foreach Loop container get the images from the image path that is returned by the previous task and while looping the file system task saves the images to my image folder.

When I run this on BIDS, its working. (I used NET USE on DOS command to access the folder with a specific credentials)

Can I add credentials to DTSX Package (specifically to Foreach Loop Container) for this to run on SQL Server Job?

Thanks.

Upvotes: 0

Views: 388

Answers (1)

Robert Anderson
Robert Anderson

Reputation: 1256

In SQL server ManagementStudio, go to security -> credentials. Then add a new Credential for a user that has the read/write permissions to the folder. After the credential is added, you can go into the SQL Server agent job, right click then properties then edit the job step. Then in the "run as"drop down, select your credential.

Upvotes: 1

Related Questions