Error executing SSIS package in SQL Server agent

Question

I have the following problem. I have a SSIS Package that works fine when I execute it from visual studio, but when I execute it through the SQL Server Agent it gives me this error (I have it in spanish so I'll translate it and it might be a bit different from the normal message): "Can't find connection "{(the id of one of my database connections)}". The Connections collection returns this error when it can't find the specific connection element.".

The SQLSERVERAGENT user has privilegies in the project's folder.

When planning the execution, I used the package file as a origin, if that has something to do.

I ran out of ideas and don't know what to do. Any help would be greatly appreciated.

Thanks in advance, Khor

Do you have any local connection strings? Like a flat file being accessed localy that is not in a shared folder. — TsSkTo
– TsSkTo, Commented Oct 29, 2013 at 8:26
I finally made it work, I'm gonna write an answer right now. — Khor
– Khor, Commented Oct 30, 2013 at 8:48

Khor · Accepted Answer · 2013-10-30 08:51:22Z

1

I finally made it work.

The problem was that the user who created the packages had permissions on the server I was accessing with the ODBC to but the SQLSERVERAGENT user didn't.

I changed the user in the SQL Server Agent service from SQLSERVERAGENT to the user who created the packages to make sure that this was the problem and it worked fine, so the solution is either leave the service with this user or give permission on the other server to the SQLSERVERAGENT user.

answered Oct 30, 2013 at 8:51

Khor

3401 gold badge2 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error executing SSIS package in SQL Server agent

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related