Hi,

I am observing a strange behaviour of an SSIS package I created:
- It reads from a comma separated {CR}{LF} line terminated flat file into a
SQL 2005 table.
- the file contains 19636 rows. When I run the package, there are no errors,
all rows get imported and a short at the imported data looks good.
Now the strange behaviour:
- when I remove the first line of the data file - the package still runs
without errors and says it imported 19635 rows
- when I look at the table in SQL server, only 7778 rows have been imported
and when I look at the imported data, there are rows which seem not to be
correct (data of several rows seems to be imported into one field).
Now my question: where does that problem come from? What could I do to
further track down my problem? I already had a closer look at the text file
(unicode encoded, but no special characters, all lines ending with a carriage
return line break, correct number of separators in the lines etc.)
The version of SQL 2005 I use is described below, I also tried a (probably)
newer version from MSDN I got on 19-Nov-2005.

Thanks in advance for any ideas,

Thomas


Microsoft SQL Server Management Studio (expires in 293 days) 9.00.1314.00
Microsoft Analysis Services Client Tools 2005.090.1314.00
Microsoft Data Access Components (MDAC) 2000.086.1830.00
(srv03_sp1_rtm.050324-1447)
Microsoft MSXML 2.6 3.0 5.0 6.0
Microsoft Internet Explorer 6.0.3790.1830
Microsoft .NET Framework 2.0.50727.26
Operating System 5.2.3790

Hello,

I notice that you didn't use RTM version of SQL server 2005 which version
number is 9.00.1399.06. I suggest that you install RTM version and test it
again.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Sophie,

thanks for the hint, I will try that as soon as possible and report my
experiences to the community (The version I posted was the one of my
developer machine, at a customers site we use 9.00.1399.00, but the problem
there occurs as well).

Best regards,

Thomas

Hello,

Thanks for update. If the issue still exists, please post here the sample
flat file, and the detailed steps to reproduce the issue. I will test it on
my side.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.