CODEWITHSUNDEEP
sql-serverssisflatfiledestination
Caroline Roy
Caroline Roy

Reputation: 1

SSIS task Flat File Destination is saving .000 instead of 0.000

I generate a tilde-delimited flat file out of several sql server 2008R2 tables. The columns I am having issues with are cost and price with $0 values. The SQL tables are set as [NUMERIC] (15,3) and so I do see "0.000" in them. When I use the Flat File Destination tasks, the numbers show up as ".000" which will get rejected by the feed. Any clue why this is happening and how to fix it?

Upvotes: 0

Views: 563

Answers (1)

Mark Wojciechowicz
Mark Wojciechowicz

Reputation: 4477

Convert the values to string in SQL, i.e.:

SELECT Convert(varchar(14), price) as Price
From my tb

You may need to fix the output column metadata to make sure it's a string, as well as the metadata in the destination flat file.

Upvotes: 0

Related Questions