Thank you Lowell!

All the similar rows should go into one table. In my example, row 1 and 3 will be in table and 2 will be another table. but my metatable will...

Yes there are tables with 4 or 5 or more columns as well as you doubted.

I have just provide a simple example here.

But the maximum column names (with csv) will...

Hi,

Yes please see the Create table script for source table and the insert script as well

CREATE TABLE yt

([ID] int, [Name] varchar(14), [text] varchar(21))

;

INSERT INTO yt

([ID], [Name], [text])

VALUES

(1, 'SID,DOB', '123,12/01/1990'),

(2, 'City,State,Zip',...

Thank you!! Jeff

PaulB-TheOneAndOnly (9/22/2010)

Pre-create the path all the...

Path does not exist..... but it worked in the older version(on server based)....the problem is when i am converting to Filed based its failing

and yes i have sufficient privilages