Search:
Search questions and share your knowledge with the world here on Questionpoint.

Interview Question in Microsoft Transact-SQL

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

Answers to "Create SQL Table on the Fly"

RE: Create SQL Table on the Fly?
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.
Vote for this answer ::

RE: Create SQL Table on the Fly?
Read about BULK INSERT command in BOL.
Vote for this answer ::

Notify me whenever an answer is posted for this question Update Alert Setting

Search questions and share your knowledge with the world here on Questionpoint.