I have a simple workflow that takes an Input tool (CSV) to an Output tool. The output is an ODBC connection to SQL Server running an append. The workflow runs and states 26 records were written with no error message... but when I check on SQL Server, there are ZERO records. Can anyone provide insight why this is happening?
- The connection is ODBC with Windows Authentication, it tests successfully
- I have access to the database and table, I can write/edit/delete records via the SQL Manager
