DTSBulkInsert | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTSBulkInsert

Hi, Does anyone know of any limitations involved in DTSBulkInsert?
A co-worker of mine said there are limits but don’t remember what they are.
If you do please inform. Thank you.
As far as I’m concerned no issues at my end using that process in DTS.
What is your requirement of data import? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hello,
Thanks for your reply.
Actually the data were sitting on a IBM. Someone else extracted them into a
text files delimited by comma. From what I understand, some text files were too
large for DTSBulkInsert store procedure to handle. I can’t imagine SQL Server having
problem importing bulk text files since it’s supposed to be a powerful database.
That is why I want to know what limitations there may or may not be when importing
bulk files.
quote:Originally posted by satya As far as I’m concerned no issues at my end using that process in DTS.
What is your requirement of data import? Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

The BULK INSERT statement can be executed within a user-defined transaction. Rolling back a user-defined transaction that uses a BULK INSERT statement and BATCHSIZE clause to load data into a table or view using multiple batches rolls back all batches sent to SQL Server. Until now I nerver had issues with BULK INSERT and its an advantage for such bulk imports of data. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Hi, Thank you for your reply.
quote:Originally posted by satya The BULK INSERT statement can be executed within a user-defined transaction. Rolling back a user-defined transaction that uses a BULK INSERT statement and BATCHSIZE clause to load data into a table or view using multiple batches rolls back all batches sent to SQL Server. Until now I nerver had issues with BULK INSERT and its an advantage for such bulk imports of data. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

]]>