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 |
|
masterdineen
Aged Yak Warrior
550 Posts |
 Posted - 2013-04-14 : 15:34:43
|
| Hello there,i have a package with a flat file source importing a txt file delimited with pipes, but the odd pipe is getting through to sql table.how do i update rows with pipes to shift to the left.can i do this using ssis or sqlRegardsRob |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-15 : 02:15:43
|
| what option you've chosen? fixed length or delimited? Also see if row and column delimiters are interpretted correctly inside flat file connection manager------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
pipes getting through with ssis flat file