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 |
|
slaws
Starting Member
9 Posts |
 Posted - 2011-05-05 : 12:15:43
|
| Hi everyone, I have a problem that is driving me insane! I am importing a Tab Delimited Text file with {CR}{LR} for the row delimiters into a SQL table. Nothing fancy really.When I run the SSIS in Visual Studio 2008 everything imports just fine. When I deploy the package to a .dtsx file everything imports EXCEPT the last row.I've tried altering the text file, removing rows, adding blank rows. I've reviewed the ascii and verified that there is a CR and LF at the end of each row.I'm at a loss here. Anyone experience this? Having a discrepancy of behaviors between the Visual Studio and the deployed version of a package?Thanks in advance for any assistance you can provide.Scott |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-05-05 : 12:40:29
|
| I'm sure you've checked these but:Is there a crlf at the end of the last line (and not just cr or lf)Are you sure you're importing the same file as through visual studioIs the 64 bit and 32 bit involvedIs there anything that looks odd about the last or penultimate line - odd size, odd chanracter.Have you tried moving the file to somewhere else on diskAre you logging how many rows the package thinks it's handlingerror loggingHow big is the file? How many columns, fixed width or column separated/delimitted.If you have one row in the file how many does it import?Are you sure it's the last row that's missing?Are you sure you're running the correct package==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
slaws
Starting Member
9 Posts |
Posted - 2011-05-05 : 15:09:41
|
| Thanks for the response Nigel and all are good questions.Thanks to you I figured out what the problem is: in the output log I am returning: "Warning: There is a partial row at the end of the file." That would be why it is not importing the last row. For this particular file there is nothing in the last 4 columns. But the tab delimiters are still there so each row ends in <tab><tab><tab><tab>. I verifed this by importing a file with the last column populated with text and all rows imported just fine.I guess my question now is why? Every column is represented by a delimiter so it shouldn't be a problem right?I went though and verified everything:Is there a crlf at the end of the last line (and not just cr or lf)-YesAre you sure you're importing the same file as through visual studio-YesIs the 64 bit and 32 bit involved-it is all 32 bitIs there anything that looks odd about the last or penultimate line - odd size, odd chanracter.-nothing oddHave you tried moving the file to somewhere else on disk-YesAre you logging how many rows the package thinks it's handlingerror loggingHow big is the file? How many columns, fixed width or column separated/delimitted.--the file contains 41 columns, less than 10 rows and is tab delimitedIf you have one row in the file how many does it import?--It imports nothingAre you sure it's the last row that's missing?--yes, it is always the last row regardless of the contentAre you sure you're running the correct package--yesScott |
|
|
|
|
|
|
Skipping Last Line on Deployed DTSX