I need urgent help. Very simple SSIS Package.
one Data Flow, Source is SQL and Destination is .CSV (,) Delimited. I am seeing data going through fine through Data viewer. A source has data 0:60 or 0:30 data viewer looks good. However, When I open the .csv file in Excel I am seeing 0.041666667, 0.30.
I create template file and format to all column TEXT and use this temp file as a destination but no luck same issue.