SSIS issue: Decimal fields are imported from csv files without the decimal part

Problem:

Decimal fields are imported from csv files to the database tables without the decimal part.
(12.547 --> 12.000).

The data imported via SSIS.
This is the definition ion the Flat File Connection Manager:

Solution:
Declare the fields in the Flat File Connection Manager as Numeric, with the correct precision and scale:

Why decimal declaration is not fit to decimal fields? Ask Microsoft :)

Quotation marks in an exported csv file from sql

As probably known, we can export data to a csv file from the export wizard.

But, if the text columns have the “,” – that it is the column separate sign – all the csv file will be not arranged.

One possible solution is to declare Quotation marks to all columns, and it will help to separate the columns.

Include columns headers in csv files via grid results

There are few ways to save query results to files.

One of them is direct from the grid results:

But, when you will do it, you will find the csv file without the columns names:

Not so nice…

The solution is quite simple: declare in the options to get also the headers:

Done. Try again – but again – no columns header!!!

Now what?

The solution for that is the most common solution in the IT world: restart – restart SSMS.

Next time – you will get the headers.