Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
talendstar
Creator
Creator

tMSSQLTableList not populating a table

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

Labels (4)
2 Replies
Anonymous
Not applicable

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

mks02
Creator
Creator

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.