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.
| Author |
Topic |
|
strauss_jon
Starting Member
23 Posts |
 Posted - 2010-07-29 : 11:54:09
|
| HiWhy 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... |
 |
|
|
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...! |
|
|
|
|
|
|
Bulk insert task cant handle final carriage return