question

jaylee avatar image
jaylee asked

I want to run someone else's SSIS package

I am trying to run SSIS package that is designed by another developer using SQL Server Agent and getting this error: "Package Execution on IS Server failed...". I have a use account with SQL authentication. The package pulls data from another sql instance to which I do not access. Is there a way for the owner of the package to save his windows credentials in the package so I can execute the package? If that is not possible, what is the workaround? Thanks.
sql-server-2014
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.