Cache InterSystems Database And SSIS

This Post is important as I got an experienced with Cache Intersystems Database and SSIS.  Most of you who don't know about Cache database, this is not relational database. This Database is based on classes and objects and it reside in memory.

CACHE DB CONNECTION :

Cache DB is connected with ODBC connection only. You will find ODBC connection in ADO.NET component.

In my Case Tables were not loading into the SSIS. And I had no clue what are the table names so I have to use SQL command. If you are also in this situation then you can use Access DB it uses an easy way to connect and load to ODBC and it can show you all the tables. Another way is to use SSMS and use link serves to get to the ODBC. I personally would prefer to use Access because of easiness.

Follow the screen shots and once you setup the connection for Cache database in SSIS, Right click the ADO component and select properties and Set the connection manager.

This is should fix the Cache and other ODBC connections to SSIS.

Database Emails

The most incentive stuff a new DBA would like to implement first is always emails. Email are very important part of SQL as it is the efficient way for DBA to know if any anything goes wrong.

But using Emails efficiently is another problem I like to share one story let give him a fake name ABC since I don't want to offend the guy lol:) . Now he planned his email in this way that he would get email of each and everything going on example he received email for each back up , differential backup and transition log. I was surprised when he complaint that his emails are too much for him. As I advised him if he can follow a reverse order example if something goes down then you received email. that going to surely reduce the frequency of sql mails.

Ok let start what to do when Database mails are not working.

First I am not explaining how to start the Database wizard I hope you already know.
What I am trying to focus is when you start thinking why your email is not working I identified those places.

First thing to check, Profile  make sure if you are using the correct profile.
Second, Check the email address, Server and Port number.
I always keep it simple espcially when I know I am in secure intranet I don't use SSL certificate but you can optional.
And one Important part if your emails are hosted that mean some third party is taking care fro Microsoft exchange then you need to provide the credentials no exception but again if you are in intranet and consider you intranet to be safe keep it anonymous.

Now let say you already check above nothing happened.
Go and check you Anti-Virus exclude MSSQL and check port number if its block or unavailable.
You can check port by telnet or ping use command line.