SSIS: How to know if the installed Oracle Client is 32bit or 64bit on your SSIS machine

In your SSIS packages, if you need to read from or write to Oracle likely that you most probably hit some Oracle Client related configuration issues. ORACLE_HOME, PATH environmental variables etc. Sometimes you may see a machine needs to run SSIS packages and you see that an Oracle Client is installed but you don’t know…

2

Why my BIDS is slow in design mode ?

One of our customers was saying that their SSIS Project with some complex “Data Flow Task”s with lots of Lookup Transformations was opening very slowly in BIDS (“Business Intelligence Development Studio”) or I don’t know if I should say “Visual Studio” … The very first thing that I check was “validation” part. As you know,…

1