So the user account we are using .. in Active Directory IS set for "Trust this user for delegation to any service (Kerberos only).. but the permission is still getting...

Thanks.. I have passed this off to our IT firm (Cap Gemini)

So I set up the publisher and Distribution on the same box.. <Server> will act as its own Distributor.  I have to wonder if you are running into the double...

Not saying we shouldn't push our vendor to support source control.. but we work mostly in their application making changes, and then the SQL side to support those changes. Heck...

Also if I set the package to a password, then when I push the package up to the server it will fail, unless I go back in and switch it...

• This reply was modified 4 years, 9 months ago by  dwilliscp.

I am using Package Deployment.. so just sending it to SSIS the old way. When I open up the package, and right clicking and then picking  logging, it shows the...

So I doublechecked and the SQL Server running the job … is using the service account. (same one I tested Visual Studio with)

Also both the file it is reading and...

This is from the Data Flow Path Editor (Metadata)

So here is the table I am trying to write to, the first three rows are the Key and is in the Where stmt