topic Import from MS SQL Server. Export to CSV. in Talend Studio

Import from MS SQL Server. Export to CSV.

Anonymous — Sat, 16 Nov 2024 12:25:16 GMT

Hi all,
I am trying to setup Talend Open Studio for Data integration for the below purpose;
Import data from a MS SQL Server table, and export this data into a .csv file.
I am running:
Windows XP 32bit
MS SQL Server 2005 Express
Talend Open Studio for Data Integration 5.0.1
I have successfully setup a connection to the SQL Server and have created a schema for the table I am trying to retrieve data from however the .csv file I have specified is empty and I am receiving this error:
Exception in component tMSSqlInput_1
java.lang.NullPointerException
at ms_sql_server_etl.data_export_0_1.Data_Export.tMSSqlInput_1Process(Data_Export.java:556)
at ms_sql_server_etl.data_export_0_1.Data_Export.runJobInTOS(Data_Export.java:956)
at ms_sql_server_etl.data_export_0_1.Data_Export.main(Data_Export.java:824)
In my job designer I have:
tMSSqlInput_1
Running the query:
"SELECT dbo.\"Stock Group\".\"ID\",
dbo.\"Stock Group\".Code,
dbo.\"Stock Group\".Description,
dbo.\"Stock Group\".\"tc ho/bo delete flag\",
dbo.\"Stock Group\".deleted
FROM dbo.\"Stock Group\""
With it set to use an existing connection, the schema set to the repository and the table name set to: "Stock Group"
I have this connected to a tFileOutputMSDelimited_1
Any help would be greatly appreciated!
Sincerely,
Robert

Re: Import from MS SQL Server. Export to CSV.

Anonymous — Mon, 30 Jan 2012 06:49:22 GMT

Hi Robert
Welcome to Talend Community!
Here are some advices.
No.1 : Use tFileOutputDelimited instead of tFileOutputMSDelimited.
No.2 : Use Metadata->Db Connections to retrieve schema and query, which is more convenient.
No.3 : The query above is wrong. There is no need to type \" here.
Regards,
Pedro

Re: Import from MS SQL Server. Export to CSV.

Anonymous — Mon, 30 Jan 2012 15:32:59 GMT

RSoppa,
What I usually do when making queries for my input component is create them in SQL server and make sure they are working there.
When your just select all columns of a table you can do as pedro suggested by retrieving the query and the schema. In that case you won't even have to modify anything about the query.
Regards

Re: Import from MS SQL Server. Export to CSV.

Anonymous — Tue, 31 Jan 2012 00:16:58 GMT

RSoppa,
What I usually do when making queries for my input component is create them in SQL server and make sure they are working there.
When your just select all columns of a table you can do as pedro suggested by retrieving the query and the schema. In that case you won't even have to modify anything about the query.
Regards

Sorry, I should have mentioned that I was using a simply query to test the functionality of Talend for my purposes. I have a significantly more complex query that I need to execute.
Pedro: What do you mean by using the Metadata > Db Connections? I have retrieved the Schema for the table 'Stock Group' and I'm loading it from the Repository. I have changed to using the tFileOutputDelimited_1 and changed the query to remove the '/' from the query which were inserted when I selected 'Guess Query'. When I remove the '/' I receive even more errors! Changing to the other file output has not removed my original errors either.
I am very new to this program, sorry if what I'm asking is very basic!