topic Re: tMSSQLTableList not populating a table in Talend Studio

tMSSQLTableList not populating a table

talendstar — Sat, 16 Nov 2024 07:26:54 GMT

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

Re: tMSSQLTableList not populating a table

Anonymous — Thu, 18 Oct 2018 06:37:12 GMT

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

Re: tMSSQLTableList not populating a table

mks02 — Thu, 18 Oct 2018 11:49:51 GMT

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.