FDM Import script not loading data from SQL table to FDM table
I am using FDM 11.1.2.1 and trying to import data to FDM from MS SQL table. Location and importformat are setup, but fishing turn grey without error message and import table is empty. The following is the error message when executing from script editor. Am I missing something in configuration.
** Begin FDM Runtime Error Log Entry [2016-01-26 13:25:04] **
-------------------------------------------------------------
ERROR:
Code............................................. -2147217900
Description...................................... Incorrect syntax near '('.
INSERT INTO (PartitionKey, CatKey, PeriodKey, DataView, Account, Entity, UD1, UD2, UD3, UD4, UD5, UD6, UD7, Amount) SELECT N'750' PartitionKey, '' CatKey, N'11/30/2015' PeriodKey, N'Periodic' DataView, N'Ord. deprec. TBP' Account,CoCd,[Year],Per,Ar,Asset,Class,Cost_Ctr,Location,Ord_deprec_TBP FROM [Source].[dbo].[SourceTable]