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 |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2013-05-13 : 10:09:05
|
| Hello,I have a flat file with fixed width columns. My SSIS package gives warning "There is a partial row att the end of the file"And when I open it in Notrepad, yes the pouint does goes to the line below the last visible line of data.I receive this file daily from an outside source. How can I get around this issue?Thanks, Jack |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-14 : 00:44:00
|
| you've add a logic in script task to parse and strip out unwanted lastline character before your data flow task.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2013-05-14 : 10:09:48
|
| Thanks very much, visakh16. I will research how to do this.Jack |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-05-15 : 00:41:29
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
How to Resolve "Partial row at end of the file?"