I have released a small, free, C# single-class library that can be used with SSIS or in other environments to parse CSV and other similar delimited text formats (such as tab or pipe delimited), and to do so with some tolerance for errors in the use of double quote characters. The repo can be found on github.
In the “better late than never” category… (I missed this because I had given up looking for it. Besides, I am presently trapped in RS 2008 RTM hell.) SQL Server Data Tools – Business Intelligence for Visual Studio 2013 SSDT BI – Analysis Services and PowerPivot Team Blog – Site Home … Continue reading →
Improve SSIS data flow buffer performance.
Never thought of this: Using hash values in SSIS to determine when to insert or update rows.
Neat… SSIS: Dynamic Processing of SSAS Partitions | Benny Austin.
This looks promising. (Trying to use the built-in connection manager might not work so well.) Create/write to an Excel 2007/2010 spreadsheet from an SSIS package – SQLServerCentral.
Bulk Loading into MDS using SSIS.
SQL Server Technet: SSIS: Transfer SQL Server Object using SMO.
This being the day of the Visual Studio 2012 Virtual Launch, I thought I would actually try out the product, which has been sitting in my downloads directory for several weeks. … Continue reading →