<div>
Barring any other feedback splitting points across both experts that provided comments.
</div>


Barring any other feedback splitting points across both experts that provided comments.

<div>
<div class="content wysiwyg-content">
I am trying to create an SSIS package to take an Excel spreadsheet and automatically import it from a pre-defined folder, the ultimate goal is to have this data inserted into several tables. &nbsp;<br />
<br />
I seem to be bumping into the issue where it does not like my data type conversions. &nbsp; I initially had it working directly from Excel to a database, but I have fields which are text and have a leading zero , which has a very significant different value. &nbsp;So I update every field to match the database types, but then I am receive cannot convert between Unicode and non-Unicode. &nbsp;Then I went and attempted to find the equivalent &nbsp;(I.e. DT_STR = CHAR ) &nbsp;but still having issues. &nbsp;<br />
<br />
Then read that I need to go from Excel -&gt; Text -&gt; SQL import. &nbsp;That did not work either. <br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2017/04_w14/1154687/C--temp-2017-04-04_11-45-25.png" target="_blank" title="SSIS Import Log (92 KB)"><img alt="SSIS Import Log" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2017/04_w14/800_1154687/C--temp-2017-04-04_11-45-25.png" /></a>
</div>
</div>


C--temp-2017-04-04_11-45-25.png

I am trying to create an SSIS package to take an Excel spreadsheet and automatically import it from a pre-defined folder, the ultimate goal is to have this data inserted into several tables.  

I seem to be bumping into the issue where it does not like my data type conversions.   I initially had it working directly from Excel to a database, but I have fields which are text and have a leading zero , which has a very significant different value.  So I update every field to match the database types, but then I am receive cannot convert between Unicode and non-Unicode.  Then I went and attempted to find the equivalent  (I.e. DT_STR = CHAR )  but still having issues.  

Then read that I need to go from Excel -> Text -> SQL import.  That did not work either. 



Create an SSIS to Import Excel into Table

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.