create staging table

[Anonymous]

Hi,

I've got a MS SQL 2012 Server and I'm connection successful with the following Parameters:

DB Version: Open source JTDS

Parameters: domain=yourdomain;useNTLMv2=true

if there is a better option I would prefer to use it

=======

I want to load data from a .csv file into a new created table (staging table), this .csv is changing every time if a new supplier sends it (in it are article data), my first question is - how to load this csv into a new table?

After uploading and loading the new data into the correct tables (I think this will be another post) I would like to delete or truncate the table - how to do this?

=======

Thank you for your help!

apit

[Anonymous]

Hi,

 This looks fine. But in previous screen shot for tDBOutput, I could see that Table name is empty. Could you please add table name and show us the results? Also please share a latest screen shot of this component.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

[manodwhb]

@apit ,you should specify the schema name also. why schema is empty?

[Anonymous]

Good catch @manodwhb !

@apit  , Could you please create a metadata connection for your target table? You can then drag and drop the metadata and select tDBOutput. In this way you will make sure that the DB connection is correct.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

@manodwhbbecause I have no idea for the moment what would be the right schem.

@nthampithis is what I did.

[manodwhb]

@apit ,since you need to connect MSSQL sever from outside and verify the schema.check below links.

SELECT * FROM sys.schemas

https://stackoverflow.com/questions/226042/how-do-i-query-if-a-database-schema-exists

http://www.informit.com/articles/article.aspx?p=1216889&seqNum=2

[Anonymous]

@manodwhbthank you!

this is what I get - can you help me?

[manodwhb]

@apit ,which schema you want to use to load that table or are you going to create a new table?

[Anonymous]

@manodwhbwill be a new one

[Anonymous]

@apit 

Schema name, Table name and data structure (input data schema) are some of the mandatory information while creating a table. So if any of this information is missing or not correct, you will not be able to load data to an existing table or create any new table. If you are creating any new table, make sure that length values should be populated for all String components.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂