CODEWITHSUNDEEP
sql-serverexcelcsvssiscsv-import
gruff
gruff

Reputation: 411

Import excel Accounting data to SQL with SSIS

Every week I am receiving a CSV export which contains Accounting data. This accounting data has parenthesis to represent negative values and the parenthesis carry over into the CSV.

How do I import negative Accounting values to SQL Server with SSIS?

The options I see are:

  1. Request a data type change in the Source file
  2. Handle the data conversion within SSIS

Should I create a function to trim parenthesis from negative values? Is there an SSIS tool which will help convert accounting data types into a SQL INT?

Thank you

Upvotes: 0

Views: 512

Answers (1)

Jason B.
Jason B.

Reputation: 325

Yes there is an SSIS tool, Derived Column Transform. Use the REPLACE function with it, it should get you what you need. Something like this: REPLACE(REPLACE([YourField],'(','-'),')','')

Upvotes: 3

Related Questions