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.
Tag Archives: SSIS
Resolving SSDT-BI Installation with IsVisualStudio2012ProInstalled() error – SQLServerCentral
SQL Server Data Tools – Business Intelligence for Visual Studio 2013 SSDT BI – Analysis Services and PowerPivot Team Blog – Site Home – MSDN Blogs
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
Using hash values in SSIS to determine when to insert or update rows
Never thought of this: Using hash values in SSIS to determine when to insert or update rows.
Continue reading →SSIS: Dynamic Processing of SSAS Partitions | Benny Austin
Create/write to an Excel 2007/2010 spreadsheet from an SSIS package – SQLServerCentral
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.
Continue reading →Bulk Loading into MDS using SSIS
SQL Server Technet: SSIS: Transfer SQL Server Object using SMO
No BI projects in Visual Studio 2012
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 →