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
 General SQL Server Forums
 New to SQL Server Programming
 Bulk upload - fields truncate

Author  Topic 

adabass
Starting Member

3 Posts

Posted - 2006-11-02 : 19:18:12
I have to upload about a million records from a text file using DTS packages. The file has a predefined format which map to the fields in the database. Some of the fields width exceed the width in the database. Does that mean that it will truncate these fields, or will it fail the whole bulk upload?

Any help will be appreciated. Thanks.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-11-04 : 06:12:19
If you know that column size is not enough, why dont you increase it?

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -