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 2008 Forums
 SSIS and Import/Export (2008)
 Bulk insert task cant handle final carriage return

Author  Topic 

strauss_jon
Starting Member

23 Posts

Posted - 2010-07-29 : 11:54:09
Hi

Why can't the bulk insert task handle a final carriage return? My Oracle spooled output (the input to this bulk insert task) creates this as part of its formatting and it falls over on the last CR (it inserts fine when i manually remove this character). Is there a way of getting round this, i would prefer not to use a data flow task.

Thanks in advance, Jon

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-07-29 : 13:53:22
then you'll have to open the file and remove it. i guess you could use a script task to do it, but data flow task would be a lot quicker.

by the way, why don't u want to use a data flow task? not much easier than that...
Go to Top of Page

strauss_jon
Starting Member

23 Posts

Posted - 2010-07-29 : 14:12:23
Thanks for your reply.

Because I read somewhere that data flow doesn't bulk insert so would be slower than the bulk insert task? Am I right on this one? If not, i will pursue a data flow task...!
Go to Top of Page
   

- Advertisement -