Manikanta Puppala commented, 26 June 2023 14:05

Hi team, I am having trouble storing the ILR-validated report in the SQL server. The FIS tool is able to generate the SQL schema and tables, but it is not storing the data into the tables. I have checked the FIS log files for errors, but I have not been able to find any. I have also tried restarting the SQL server and the FIS tool, but the problem persists. PowerShell command that I'm using,  .\ESFA.DC.ILR.Desktop.CLI.exe -f ".\ILR.xml" -c "Server=localhost; Database=ILR.Reports; Trusted_Connection=True;" -o ".\OutputDirectory" config file screenshot,  [image] Tables that generated,  [image]   [image]   [image]   I would appreciate any help you can provide in troubleshooting this issue. Thanks Manikanta. 

1. FIS - Export to SQL Connection String (PDSAT)

Hi team, I am having trouble storing the ILR-validated report in the SQL server. The FIS tool is able to generate the SQL schema and tables, but it is not storing the data into the tables. I have c...