Bulk insert truncate the actual line

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 2005 Forums

Transact-SQL (2005)

Bulk insert truncate the actual line

Author

Topic

fuxing
Starting Member

3 Posts

Posted - 2008-04-29 : 14:48:56

Hi all,

I have a problem during the bulk insertion. SQL truncated each line of the file.

The format file is:
9.0
1
1 SQLCHAR 0 8000 "\r\n" 1 if1 ""

Table:

CREATE TABLE #if1 (
[if1] [varchar] (8000) NULL
)

Query:
SET @sqlstr = 'BULK INSERT #if1 FROM ''' + @inputfilepath + '.if1'' WITH (FORMATFILE = ''' + @ifformat + '.fmt1'')'
EXEC(@SQLSTR)

Everything is fine. The only problem is the lines are truncated.

Any ideas?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-30 : 23:00:21

What's row length of data in the file?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources