Automatic import CSV files

[Roland Lee]

Dear all,

I'm new to SQL server. I would like to ask how to do the following. Now I have many CSV files in a directory, which are uploaded through ftp from my client computers daily. How can I automatically import those CSV files to the SQL server? Can I do it by a script or a stored procedure or something else?

Your help would be much appreciated.

Thanks,
Roland Lee

[MAK]

DTS Package will do that wonder.
BCP will also do that wonder.
-MAK


------------
Roland Lee at 3/22/01 9:44:00 PM

Dear all,

I'm new to SQL server. I would like to ask how to do the following. Now I have many CSV files in a directory, which are uploaded through ftp from my client computers daily. How can I automatically import those CSV files to the SQL server? Can I do it by a script or a stored procedure or something else?

Your help would be much appreciated.

Thanks,
Roland Lee

[Roland Lee]

Dear MAK,

Can you elaborate a little bit more?

Thanks,
Roland

------------
MAK at 3/22/01 9:51:27 PM

DTS Package will do that wonder.
BCP will also do that wonder.
-MAK


------------
Roland Lee at 3/22/01 9:44:00 PM

Dear all,

I'm new to SQL server. I would like to ask how to do the following. Now I have many CSV files in a directory, which are uploaded through ftp from my client computers daily. How can I automatically import those CSV files to the SQL server? Can I do it by a script or a stored procedure or something else?

Your help would be much appreciated.

Thanks,
Roland Lee