Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | 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
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

yosiasz
Flowing Fount of Yak Knowledge

USA
1635 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
52326 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
1635 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
52326 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
1635 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
52326 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  
 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.06 seconds. Powered By: Snitz Forums 2000