Tags » SSIS

QuickTiP: Setup TNS less connection to Oracle in SSIS

Add connection :

Connection String: (DESCRIPTION=(CID=GTU_APP)(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myHost)(PORT=myPort)))(CONNECT_DATA=(SID=MyOracleSID)(SERVER=DEDICATED))) 18 more words

SSIS

Jet Driver Error When Importing Data from Excel Files

Importing data from files is common. Csv file formats are also common but can cause issues with characters such as commas. Excel files offer a nice solution as they are usually formatted properly and do not have issues with characters. 186 more words

Excel

Dyanmics CRM Data Migration using KingswaySoft Tips

I will divide the tips to CRM/SQL & Kingswaysoft parts:

CRM & SQL Optimizations:

  • Disable CRM plugins, audit and/or workflows in your initial load if you can, as they all have certain impact to your data integration or migration performance.
  • 585 more words
Microsoft Dynamics CRM

Introducing BIML - Continued

So I spent yesterday entering the metadata to describe some 70 or so packages that are all part of a big data load that moves data off the mainframe (DB2) into SQL Azure.   96 more words

SSIS

Free Webinars hosted by GroupBy

Developers, Query writers, and DBAs – Register for Free Webinars hosted by GroupBy.  You do not need to attend all the sessions.

https://groupby.org/

Sessions:

Friday, April 21: 111 more words

SQL Server

SSISDB and Catalog - Part 4 - Parameters

Background

With the advent of the Integration Services Catalog, parameters for SSIS packages no longer need to be controlled using a configuration file (usually with the extension of ‘.dtsconfig’). 788 more words

SSIS

Size does matter: SSIS DefaultBuffer

While researching how to improve performance for SSIS code, I found two properties that should always be changed on every SSIS package data task. Unfortunately I could not find anywhere  on the web information on where to make the change, just that I should. 131 more words

SQL Server