We help IT Professionals succeed at work.

Create an SSIS to Import Excel into Table

147 Views
Last Modified: 2018-02-06
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.

SSIS Import Log
Comment
Watch Question

lcohanDatabase Analyst
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
SQL Server Data Dude
CERTIFIED EXPERT
Most Valuable Expert 2013
Author of the Year 2015
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Jim HornSQL Server Data Dude
CERTIFIED EXPERT
Most Valuable Expert 2013
Author of the Year 2015

Commented:
Barring any other feedback splitting points across both experts that provided comments.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.