Ivan Paniagua Monroy {Blog about BI, SQL, Azure & Microsoft.NET Technologies}

Archivo para febrero, 2012

Error in SQL Server 2012 (RC0) Integration Package

This is my second error found working with the new Release of SQL Server 2012. This time with the version Release Candidate 0 (RC0, which was recently launched 02-12).

I create a package from Management Studio to import data from txt files (soo simple task), and I create successfully this package with the option that I show here:

Imagen

But I have problems with the data itself, so I need to create another flow, validate data better and filter wrong rows. This can be do with SSIS, SQL Server Integration Package, and this new release comes with Visual Studio 2010 Shell.

This problem was reported through Microsoft Connect now fortunately this problem was solved in the final version.