Rubbish Appear when impored using Format file

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

SSIS and Import/Export (2005)

Rubbish Appear when impored using Format file

Author

Topic

gripusa
Starting Member

3 Posts

Posted - 2007-11-26 : 06:07:48

Hi All! I am using Bulk Insert to obtain data from the text file. This works
perfectly if i try to import it using standard/default Bulk Import . However,
if i try to import using Format file by specifying the two columns (as data
is in two column format) , the import works successfully but applying a
select statement only returns garbage in the rows. What is exactly happening,
i could not able to understand.

tm
Posting Yak Master

160 Posts

Posted - 2007-11-26 : 10:44:47

Need more info to be able to help.
Data example, format file, bcp file, table structure and also example of the garbage you are getting.

gripusa
Starting Member

3 Posts

Posted - 2007-11-27 : 05:31:19

Ok Solved, the issue with Unicode. I was using NVarChar while it should be VARChar/Char types.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources