Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  DTS Text Import vs Bulk Insert

Author  Topic  werowe Starting Member 3 Posts Posted - 2001-03-22 : 13:17:38 I am trying to import a file from a different server into a table in SQL Server using a DTS package. The Text Import task works but trying the same thing w/ the Bulk Insert task fails. The Bulk Insert task generates an access denied or 5 error. What are the differences between these two? Where can I can info about the differences? Finally, why does the text import work and bulk insert does not for the same file? Very puzzling. Thanks, Bill