I use ado.net connections with Multiple Active Result Sets (MARS) resource set to True and Packet Size set to 32767

to utilize the Balanced Data Distributor - http://www.sqlservercentral.com/articles/Integration+Services+%28SSIS%29/127512/

this article may be of some help

http://www.sqlservercentral.com/blogs/tim_mitchell/2015/04/13/handling-mixed-format-data-files-in-ssis/

DBA From The Cold (4/8/2015)

Yep:-

Msg 2760, Level 16, State...

These are better references

http://www.sqlservercentral.com/Forums/Topic1427878-2799-1.aspx

https://www.simple-talk.com/cloud/cloud-data/azure-sql-database-maintenance/

SQL Server Data Tools - Business Intelligence for Visual Studio 2013

support Visual Studio 2013 and SQL Server 2014.

all in good fun -- even if my choice was different.

CMS.Gov has ICD10 codes http://www.cms.gov/%5B/url%5D

[url]http://www.cms.gov/Medicare/Coding/ICD10/index.html?redirect=/icd10">(http://www.cms.gov/%5B/url%5D

http://www.cms.gov/Medicare/Coding/ICD10/index.html?redirect=/icd10

+1. Too bad about the error.

The link provided is for 2014 --

2012 as referenced in the question does not have the same list on MSDN

http://msdn.microsoft.com/en-us/library/dd206998(v=sql.110).aspx

have you reviewed this information?

http://technet.microsoft.com/en-us/library/ms162810(v=sql.105).aspx

according to http://msdn.microsoft.com/en-us/library/dn511014(v=sql.120).aspx

Memory-optimized tables are fully durable by default, . . .

A second copy of the table data is maintained on disk, but only for durability purposes.

the following link indicates the issue is sql server agent service account does not have sufficient permissions

http://social.msdn.microsoft.com/Forums/en-US/a8902350-55e5-4844-afcc-8493a588ae3f/unexpected-termination-while-running-ssis-packages?forum=sqlintegrationservices

This link has info to resolve ORA-12154

http://www.dba-oracle.com/t_ora_12154_tns_resolve_service_name.htm

There is a CodePlex project "SQL Server Label Security Toolkit"

http://sqlserverlst.codeplex.com/ that seems to be what you are looking for.

+1