Tags » SSIS

Issue: DATE column as DT_WSTR in SSIS in lookup

It appears that OLEDB provider for SQL Server is incorrectly mapping DATE column from SQL SERVER into DT_WSTR (wide string). Same query using SQL native provider 11.1 (SQLNCLI11.1) is correctly mapped as… 128 more words



The tenth foundation week in Stonyhurst Southville International School was filled with multiple events including a benefit concert, sports fest and a fitness event – … 441 more words


How To Remove Duplicate Records In SQL Server Using SSIS

There are multiple ways to remove duplicate records in SQL Server.We can eliminate duplicate rows by using Sort and aggregate transformation. First we’ll create some sample records. 312 more words


Tutorial: SQL Server Integration Service

Here is another tutorial I wrote a while back on SQL Server Integration Services. It is a step by step tutorial on creating and deploying your first SSIS package that will leave you with a good understanding of not just a simple how-to, but also how to go about achieving more complex workflows in SSIS. 6 more words


SSIS - {Package inserts Bit data type column '1' as '-1' and '0' as '0' in Int data type column}

Quick Tip:

This issue occurs while we moving data from Bit column (Source) to Integer column(Target). If we look the metadata of the columns in SSIS package, It shows  90 more words

Data Migration

SSIS - {The column cannot be processed because more than one code page (1256 and 1252) are specified for it}

Second post in 2017.. hoping for more posts in upcoming days.

Recently, I faced this issue while migrating records from Source database to Staging database. 103 more words

Dynamics 365

SSIS - Unicode data is odd byte size for column 4. Should be even byte size.

This one was interesting and if it wasn’t for a quite obscure article on page 3 of a Google search (who even goes to page 3 anymore) it would have taken me a lot longer to figure out the problem. 308 more words