Tags » Oledb

Oracle, Passwords and SSIS Packages

I have spent the last two weeks banging my head on why I couldn’t get Oracle password to save in the SSIS package despite using the config file or decrypt and a multitude of other options.   234 more words

Technology

'OraOLEDB.Oracle.1' is not registered on local machine

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/95d8e522-75b6-4ee3-a691-d2e76b25d56a/oraoledboracle1-is-not-registered-on-local-machine?forum=sqlintegrationservices

I nearly pulled my hair out finding the solution to this problem.

In the end I installed “32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio” on my 64 bit system, and it solved the problem. 27 more words

SSIS

Loading table stored in DBF format in C#

Downloads

Microsoft OLE DB Provider for Visual FoxPro 9.0 (required, install for DBF support)

DBF Viewer (optional, for viewing purpose)

Loading the data

Once OLE DB provider is installed DBF file can be accessed using… 88 more words

Bez Kategorii

SSIS Project with OLE DB Source and Kingwaysoft Destination

In this project we will create a project SSIS that will update a 10 field of entity, so i added a Data flow that contains an OleDB SOURCE that contains a sql query and a KingwaySoft destination that will update the 10 fields. 30 more words

Microsoft Dynamics CRM 2013

Getting totals from saved reports

So after I’ve run the loop from the previous post I’m left with 8 workbooks sitting in a folder (that’s two values of parameter 2 for each of the four values of parameter 1). 241 more words

Vba