tSQLDWHBulkExec - doesn't recognize the text file format

Anonymous — Thu, 23 May 2019 17:46:25 GMT

Hi, My goal is to load data from on-premise to Azure Data warehouse. As I follow this article : https://www.talend.com/blog/2017/02/08/leverage-load-data-microsoft-azure-sql-data-warehouse-using-polybase-talend-etl/ I got everything work great up to the the point tAzureStoragePut. Got the file to blob storage, then move to tSQLDWHBulkExec, for some reason, this component doesn't recognize the textFile format. So the data that got load to table only have one column with | in it. I check my data warehouse, there is no external data source or external File formats got created, ̣I assume this Talend component would auto create these files to use Polybase. So if Talend doesn't auto create these files, is there a way for me to set Talend to use external data source and External File Formats I created in Azure Data warehouse?

I am also open to other suggestion to get my end goal work.

Thank you for your help.

Niva

Re: tSQLDWHBulkExec - doesn't recognize the text file format

Anonymous — Thu, 23 May 2019 19:49:54 GMT

Never mind,

I found the answer. Got to configure the File Format for this component in Advanced settings.

topic Re: tSQLDWHBulkExec - doesn't recognize the text file format in Talend Studio

tSQLDWHBulkExec - doesn't recognize the text file format

Re: tSQLDWHBulkExec - doesn't recognize the text file format