SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 FYI: SSIS suddenly not working
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

yosiasz
Flowing Fount of Yak Knowledge

USA
1629 Posts

Posted - 10/22/2013 :  16:29:16  Show Profile  Click to see yosiasz's MSN Messenger address  Reply with Quote
I wanted to share this freakish anomaly we ran into. We had an SSIS package that was failing for a while in production that generated sitemaps. started a project to revive it and suddenly we were getting error saying [sql service agent domain user] not able to login to [database name]. [sql service agent domain user] is sysadmin. wa wa??!?!? tried all kind of junk. Finally opened it in new version of visual studio, deleted a connection and recreated that same connection, changed absolutely no code. deploy to production and voila it works! but I cannot explain in technical terms what really happened. thought I would share this with everyone since it almost drove me off the wall. UID? dtsx is xml but is there something in it that tells sql server hey I am a new version of SSIS?!?!

<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 10/23/2013 :  02:09:44  Show Profile  Reply with Quote
What was the protection level set for the package? Was package stored in MSDb or in file system?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

yosiasz
Flowing Fount of Yak Knowledge

USA
1629 Posts

Posted - 10/28/2013 :  12:47:50  Show Profile  Click to see yosiasz's MSN Messenger address  Reply with Quote
Protection level:EncryptSensitiveWithUserKey. Package was stored on file system

<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

Edited by - yosiasz on 10/28/2013 12:49:33
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 10/28/2013 :  13:10:00  Show Profile  Reply with Quote
quote:
Originally posted by yosiasz

Protection level:EncryptSensitiveWithUserKey. Package was stored on file system

<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion


then unless same user opened and deployed package, the sensitive info wont be available in package while using the above protection level.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

yosiasz
Flowing Fount of Yak Knowledge

USA
1629 Posts

Posted - 11/17/2013 :  00:43:18  Show Profile  Click to see yosiasz's MSN Messenger address  Reply with Quote
brilliant!

Thanks V

<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 11/17/2013 :  11:46:13  Show Profile  Reply with Quote
you're welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000