Tuesday, October 9, 2007

REMIX 2007 at Boston

I just returned back home after attending REMIX for two days and it was absolutely wonderful. I got to meet some of the most Geeky people and also gotto see some Geeky stuff. I have a lot of good things to write about it, but this is not the right time. I am really dead tired especially after the awful air traffic at Philadelphia.

If you cannot wait till my posts, you can check out the videos at:

Thursday, October 4, 2007

How to become a DBA from a Developer

Today, I was listening to an audio talk show on RunAsRadio about being a better DBA. This show was hosted by Richard Campbell and Greg Hughes with Brad McGhee as the guest.
Brad gave some real good tips for becoming a better DBA.

Here are a few tips from the show:
  • Love the DBA work. If you are not going to love something, you will never be able to understand it.
  • Take responsibility. This is the only way you will be able to learn something new.
  • Understand your organization's data. This will help you a lot in better structuring your databases.
  • You have to be a good Problem Solver.
  • Read Books...this is one of the easiest ways to learn something quickly. I still prefer books to electronic media.
  • Take Classes/Training.
  • Participate in forums.
  • Be active in your community and attend events (like PASS).
  • Always keep looking for the Dirtiest, hardest jobs. This will help you by giving you new harder challenges everyday.....keeps your brain sharp.
  • Be proactive (prepare for next failure).
These are only a few tips and if you want to know more, you check out the audio here.
Thanks for the great show guys and keep on coming up with such shows....

Wednesday, October 3, 2007

Moving SSIS packages from Development to Production

I built a few packages on my development machine and it worked fine without any major hiccups. Then after moving the packages to the destination server, it started throwing weird errors. I had first changed the connection strings in the package configuration file but still the following errors started showing up :

First Error:

a)
Failed to decrypt protected XML node "PackagePassword" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.

b)Failed to decrypt protected XML node "DTS:Property" with error 0x80070002 "The system cannot find the file specified.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.

This happens because of the package protection level which is by default set to "EncryptWithSensitiveKey". Setting the package protection level to "DontSaveSensitive" helped me to remove these errors. This can be done by right clicking the package in the designer and changing the properties
Also, I setup the proxy sever agent so that the package runs under my account(the one which created the package)

Second Error:

After the first error was resolved, now was the time to run the packages. When I ran the package, it threw an error which was something like this:

SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "*****" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed

The error was happening in an access datasource. I went back into the package configuration file and removed the initial catalog parameter value(which was empty by the way) and voila, it worked.
This post helped me to get through :
https://forums.microsoft.com/msdn/showpost.aspx?postid=73863&siteid=1