I am new in SQL Server.Currently I am using SQL Server 2008.
I have to create a stored procedure that will take different files like .csv,.txt and create a table in my database.
At a single time i am using only one file like .csv,.txt.
Here I am generating a XML file which contains script to create table and how to map data into table.
Here we are using XML as a middle man which gives us idea about file structure and how to map data into table.
Can any one guide me how can i do this thing?
Thanks & Regards
View Complete Post