Am exporting data from a SQL procedure to flat file. My issue is
i have a column called Test with data 1e2, 1e1, 1e3 .....
.When i export to flat file, data for this column looks like 1.00E+02,1.00E+01,1.00E+03...... .
What should i do to get exact data into flat file from SQL proc. Any help is appreciated.Thanks.
相关问题
- SQL Server Import Wizard doesn't support impor
- Bulk insert from excel to sql for selective fields
- What other dependencies do I need to install in Vi
- Deployed SSIS Package not reflecting changes made
- Building SSIS solution using visual studio online
相关文章
- SSIS solution on GIT?
- How can I manually fail a package in Integration S
- See complete tooltip error message for Data Flow S
- Save content of Email body in outlook to a file
- What is Big Data & What classifies as Big data? [c
- What is the actual use of buffer temp and blob tem
- Object Variable in script tasks
- SSIS Script Task Not Running Excel Macro With AddI
This solved my issue,
Created a excel template with Test Column as text.
In SSIS, Created OLEDB Source, Data Conversion and Excel Destination tasks. In Data Conversion i converted Test Column to Unicode String DT_WSTR. I executed the package and it populated data into the template i created with 1e1,1e2...in Test column.
Make sure the column in your
Flat File Connection Manager
hasDataType
ofstring [DT_STR]
. This will avoid the implicit conversion done on your column by SSIS. See the image below: