SSIS

SQL Server Data IS profiles stored in tables

8

The task of SQL Server Data Profile Information Services stores the results of profiling in an XML document that can be examined with the Data Profile Viewer. In the article SQL Server 2008 Dataprofiling to explain how to use this new Task in SSIS. Although this method is very simple

SSIS: Workaround to two errors for no apparent reason when we insert data in MySql

6

SSIS: Workaround to two errors for no apparent reason when we insert data in MySqlFor whatever reason we may have to develop a Microsoft Integration Services package we move data from any source to a table that is in a MySQL database.

The first aim will do so through an ADO.NET Destination and MySQL provider for the connection. If we do well to insert the data directly, to create the target, select the connection and then select the table appears an error like the following check everything with the preview or try and do the assignments...

 

 

 

Data Profiles of SQL Server Information Services stored in tables

7

The task Data Profile of SQL Server Information Services stores the results of profiling in an XML document that can be examined with the Data Profile Viewer. Article Dataprofiling with SQL Server 2008 explains how to use this new Task in SSIS.

Data profiling with SQL Server 2008

7

One of the many improvements brought about SQL Server 2008 at the ETL with Integration Services is their ability to perform data profiling with its new Data Profile Task.

Syndicate content