Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


GeoffAlbin
2019-03-12T13:17:00Z
I have created both trusted (Trusted_Connection=True;) and integrated (Integrated Security=SSPI;) to try to get this to work. I have tested against SQL 2014, 2016 and 2017.

No matter what i try, i always get a 77777 error.

I can see all the package details. Just when i run the package it always fails. I have even tried to run on 32 bit mode.

I browse the forums and see others have this feature working. Is there something I need to setup that i am missing? can someone please share the steps they took to get this to work?
Sponsor
Forum information
GeoffAlbin
2019-03-12T15:09:18Z
Apparently if i alter my SSIS packages to use SQL credentials and save the password in the package they run.

Does anyone know if there is a way to truly pass VC saved credentials all the way through the package process and not just for reading the SSISDB database?
Support
2019-03-14T12:17:55Z
Originally Posted by: GeoffAlbin 

Apparently if i alter my SSIS packages to use SQL credentials and save the password in the package they run.

Does anyone know if there is a way to truly pass VC saved credentials all the way through the package process and not just for reading the SSISDB database?



If you use Integrated auth you need to combine with a Credential (that has Load profile checked in settings).
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
2026-11-14T11:05:48Z
The subsequent seems including it goes without saying excellent. Almost all these trivial details are meant by employing volume of footing understanding. I love to these individuals drastically. bandar toto macau 
2026-11-14T11:50:11Z
Overall, politicians are split on the issue of whether Twitter is more for business or personal use. The first thing is the fact that you can build up quite a large following of people. chatgpt代充 
2026-11-14T13:35:18Z
Nice read, I just passed this onto a colleague who was doing a little research on that. And he just bought me lunch since I found it for him smile So let me rephrase that: Thank you for lunch! Smart Fresh Air System 
2026-11-14T15:13:13Z
It’s a shame you don’t have a donate button! I’d without a doubt donate to this superb blog! I suppose for now i’ll settle for book-marking and adding your RSS feed to my Google account. I look forward to new updates and will share this site with my Facebook group. Chat soon! edible panties 
Scroll to Top