Hi friends,
Upon attempting to export a view to Excel from SQL Server I find three columns showing error with message "Use Global. Upon double clicking one of the same I get the message:
[Source Information]
Source Location : KHI-1990\SQL_FARAZ
Source Provider : SQLNCLI11
Table: [dbo].[TEMPVIEW]
Column: Main_Record_No
Column Type: bigint
SSIS Type: eight-byte signed integer [DT_I8]
Mapping file (to SSIS type): C:\Program Files\Microsoft SQL Server\120\DTS\MappingFiles\MSSQLToSSIS10.XML
[Destination Information]
Destination Location : C:\Users\faraz.qureshi\Desktop\TempExp.xlsx
Destination Provider : Microsoft.ACE.OLEDB.12.0
Table: `TEMPVIEW`
Column: Main_Record_No
Column Type: Decimal
SSIS Type: numeric [DT_NUMERIC]
Mapping file (to SSIS type): C:\Program Files\Microsoft SQL Server\120\DTS\MappingFiles\AceToSSIS.xml
[Conversion Steps]
Step 1: DT_I8 ...
Go to the complete details ...