Posted on: 11/5/2014 4:03:24 PM | Views : 597

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 ...