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.
CACHE DB CONNECTION :
Cache DB is connected with ODBC connection only. You will find ODBC connection in ADO.NET component.
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.
