Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am using tMSSQLTableList to populate a few tables in Snowflake. However tMSSQLTableList is not populating one of the tables in the list.
The table does exist in both Snowflake and SQL Server. Talend Studio is not throwing any errors.
Any thoughts on what could be going on here?
Thanks
Hi,
Could you please share the screen shots of the Table list component for MSSQL, the current output from this component and the expected table name which is missing? Could you please also verify the table name which is missing is under same schema/user?
Once we get these details, we will do further analysis.
Warm Regards,
Nikhil Thampi
tMSSQLTableList is used to populate a few tables rows, if all tables exists in database it returns the columns, otherwise doesn't return anything (No error will be thrown by Talend, if table not exist or table name mismatch). Please check if table name is correct which you are passing in WHERE clause of tMSSQLTableList.
Its better to attach a screenshot of your job for quick reference.