SSIS Data Conversion - Update Multiple Rows

Question

First SSIS experience so I'm willing to accept I'm doing things completely wrong here:

Using SSIS:

• I'm importing from an Excel sheet
• exporting to a client's SQL (SQL Server) database
• The data has >250 columns
• The Client's database rows are all various nvarchar lengths like 3,5,8, etc
• I can assume that the excel data will fit into the database properly, so if I truncate I won't lose any data

What I think I have to do here is truncate the data using a "Data Conversion" transform. The problem I have is it's going to take me hours to do this in the "Data Conversion" editor window because I'm dealing with so many columns, when it would only take me a few minutes in a text editor.

Is there any way to bulk update the Data Conversion settings? Am I doing this the wrong way?

Answer 1

The solution I ended up with was: - change the package to not fail on truncation. - Once I did this I could get rid of the transform. - in the database I created a staging table with the excel column names to import to so that I didn't have to manually match everything up in SSIS