troubleshooting Question

SQL Upload issue using SSIS

Avatar of SmashAndGrab
SmashAndGrab asked on
DatabasesMicrosoft SQL ServerSSISSQL
2 Comments2 Solutions155 ViewsLast Modified:
hi,

I am using an SSIS package to upload some CSV data to my SQL table.

Here is the error:
SSIS Error

Attached is the table structure (I have numbered the columns so you can see which column 97 is).  See file "SQL-Table-Design.ODS".

Attached is the CSV file that contains the data that is failing: See file "CSV_data.csv".



The datatype of EVERY single field in the table is set to VARCHAR(MAX)  - I understand this is bad database design but I just wanted a 'catch all' structure.
Any help or advice is appreciated.

Many thanks

Stuart
SQL-Table-Design.ods
CSV_data.csv
ASKER CERTIFIED SOLUTION
Deepak Chauhan
SQL Server DBA

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros