florian.reischl (3/5/2009)

---

Hello James

Why the detour over the line by line cursor?

DECLARE @xml xml

SELECT @xml = BulkColumn FROM OPENROWSET(

BULK 'D:\Temp\Test\test.xml',

SINGLE_BLOB) AS x

SELECT...

Adi Cohn (3/5/2009)

---

No this is not what I’m saying. You need to write the logic that will know what to do with each line. You can use SSIS...

Adi Cohn (3/4/2009)

---

If you can’t use SSIS, then you can insert the file into a table that has only one column. After that you can read each row from...

gamma (3/4/2009)

---

Short answer is NO,you can't.

You have to create your table (temp ot static)first.

If you do not have a stable data pattern in your text file how useful will be...

gamma (3/3/2009)

---

------'C:\Test\TestBulkInsert.txt' -----

--1, tablname1, datacolumn1, datacolumn2, datacolumn1,

--1, tablname2, 1, datacolumn2, 2, 3

--1, tablname2, datacolumn1, datacolumn2, datacolumn1,

--1, tablname1, datacolumn1, datacolumn2, datacolumn1,

--1, tablname2, 1, datacolumn2, 2, 3

drop table #Sample

create table #Sample(

f1 int,

f2...

Thanks for the reply guys. I have been searching about BULK INSERT, OPENROWSET, OPENXML, BCP and etc on the net but can't find the exact way on how to do...

Thank you for the input Bruce, this is really helpful. I will try to research as much as I can and hope it will lead me to right direction.

If...

er.kalidass (2/16/2009)

---

U can reduce the block time and transaction Log by using single insert statement in Batch instead of multiple insert statements. u can modify the batch such that it...

er.kalidass (2/16/2009)

---

I believe the SQL Express would allow maximum storage upto 4GB.. For batch execution for ur case (multiple table and size>10MB ) needs loads of Transactions.. This will grow...

I know that the best solution to this kind of dilemma is SSIS but upper personnel is a bit strict in terms of licensing because it cost a lot of...