CODEWITHSUNDEEP
sql-serverexcelssisssis-2012
erfan
erfan

Reputation: 57

Export file is not what it should be?

I have 12 tables and I export the tables using SSIS into a existing excel file. But the results in the excel file is not the same as the sql tables. I'm not sure but I think the problem is when I export cause it show me this:

enter image description here

the table values are:

enter image description here

and after exporting the excel file is showing me this:

enter image description here

this is now the excel result, they are all correct except the first one. The service Type should be 'PS' like the rest of them but its not? enter image description here

Upvotes: 0

Views: 37

Answers (1)

ɐlǝx
ɐlǝx

Reputation: 1394

Excel sometimes keeps a strange formatting and skip lines,
in these cases it may be necessary to prepare an empty CLEAR new template file ( xls ) by deleting the lines in a "brutal way" (select all the rows from the header at the end of the file, right-click and then delete) and run the export again.

Upvotes: 2

Related Questions