Create SQL Table on the Fly?

Question

I'm trying to create a SQL table on the fly from a csv file. How do I do this in T-SQL?

Answer 1

Read about BULK INSERT command in BOL.

Answer 2

You can use SQL Server 2005's Integration services to create and schedule a package which executes periodically (in case that's what's required).

When the package executes, it reads from the CSV file and dumps its content in a table of your choice.

Here is an example of how to do it:

http://www.programminghelp.com/database/...

Hope this helps.