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]

@nthampi

could you give me an example for this table?

[Anonymous]

Hi @apit 

I would create the flow to tDBOutput like below.

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]

@nthampi 

where can I edit the schem like length an so on?

for the moment the connection is failing with the schem, without it is okay.

[manodwhb]

@apit, you just give some name,usually you should get by the DBA or if your a DBA too then you should know about these all.

[Anonymous]

@apit 

Please refer the Edit Schema button and you will get a pop up where you can enter the schema details.

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]

@manodwhbthank you.

@nthampiI'm sorry where do I find an Edit Schema button?

here?

[Anonymous]

Hi,

Please refer here.

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]

@nthampithank you very much for your patience - now I see

is there an option (I think i have seen one) getting this automatically?

[Anonymous]

@apit 

If you are using a tMap before the tMSSQLDBOutput, the schema added in the tMAP will be mapped to this component. Often, the schema in tMap will not have the length defined in the column schema. So when you are selecting the option of create table, it will try to create a String. Since the length will not be there, it will lead to error.

Another method is to create the schema in the metadata area of the Talend repository. In this case, when you are doing drag and drop, the schema will be pre-built and will be already there. In this case also, you need to make sure that schema length is defined if you are selecting "Create table".

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]

@nthampi 

thank you very much - I'm doing it now this way:

my problem is now selecting (SELECT * from test123) shows me 167 rows and not 3009 rows - have you any idea how to get all data?

best regards,

max