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

[manodwhb]

@apit ,what is the operation on Action on Data ? can you check the count with select count(*) from test123 ?