SQL Server Integration Services 2008: Importing Excel Data Using Derived Column Transformation
Posted
on Internet.com
See other posts from Internet.com
Published on Mon, 10 May 2010 04:00:00 +0100
Indexed on
2010/05/10
12:24 UTC
Read the original article
Hit count: 410
Filed under:
The complexity involved in transferring data between Excel and SQL Server results from different and sometimes incompatible data types. The Import and Export wizard mitigates potential issues introduced by these incompatibilities by taking advantage of Data Conversion Transformation. Marcin Policht describes another approach that produces an equivalent outcome by employing Derived Column Transformation instead.
© Internet.com or respective owner