the data type for "item" column is nvarchar(30).

Please can help me how to you DTS not through wizard through sql scripts?

Thanks in advance.

Regards:

Narendra

Friend, I have created the Template of the Table structure, changed the column names and Table name. Run the scripts in Different Database. When I execute the procedure I...

Mohammed Uddin,

Thanks a lot. I will try the OPENROWSET.

Regards:

Narendra Babu A