![]() ![]() ![]() The Excel source component in SSIS determines the input data types by itself, based on the first 8 rows of the Excel file.Some research on MSDN reveals the following information: The first question is, why is the value given as a float when the input clearly shows that the input data are a combination of alphanumeric and numeric values? This happens even when we set the fixed outcome of the source to be alphanumeric: The Excel source suggests that the data type of the CODE column is numeric (float), as shown below. When we try to load this into our database, we notice that rows 9 to 12 are not loaded correctly and are shown as null values. The first thing we notice is that the CODE column consists of two kinds of data types: numeric and alphanumeric (rows 9 to 12). You then try to change the input data type in the Excel source component, but you can’t seem to get the output you want. When you load the data you find that the data type is not aligning as expected and some of the rows are not filled with the data provided. Imagine your client gives you an Excel file as the SSIS source for a new project. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |