Hi guys,
I need to write about 30 excel files (xlsm) into a sql server database. Each excel files has the same structure, but have different data inside.
I have a workspace that reads the excel file and write data int othe database, without any problem. I tried running a workspace runner to run the 30 excel files. The problem is that it only writes NULL value data. It writes the good amount of entries, but each attribute is NULL.
I have FME desktop 2015.1, and SQL Server 2014.
Thanks,
maxime
+28So if I understand correctly, you have a workspace (A) that if you point it to one excel file, it processes correctly, but if you call the workspace via the WorkspaceRunner (B) it writes null values to the SQLServer database.
Do you actually need the workspaceRunner or can you point to multiple excel files in the A workspace? ie if you read in two excel files at once, does it process correctly?
Thanks, it worked without the WorkSpace Runner. I pointed to multiple XLSM files, and all entries are now in the database.
Thank you!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
