Geek asks and answers

How to import a flat file without changing regional settings on the deployment server?

I am trying to read a text file in SSIS (2005/2008). I created a connection to the file and placed the file with the flat file and it works fine in the preview, but when I try to start, I get the error message:

[Derived Column [91848]] 
Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR

So, I determined that there are several columns with decimal numbers that use period as separators. But since I work in a Scandinavian environment, servers expect a comma as delimiters.

What works is manually changing the period separator in the regional settings on a Windows server, but this is not an adequate solution.

How to import a flat file using SSIS without changing regional settings on the server on which the package is deployed?

+5
source share
1 answer

You can establish connections to the file on the object. This will apply the English settings when reading this file without affecting other things on your computer. (Look in the Properties window, not in the Editor dialog box). LocaleID

Right-click on the flat file connection in the section Connection Managersand select Properties. You can also select the flat file connection manager and click F4to view the properties.

Flat file connection manager

Set LocaleIDaccording to your preference.

LocaleID property

+6
source

More articles:


All Articles