INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

HANDLE


PASSWORD
Remember Me
Forgot Password?

Navigation

Join Us!
Keyword Search
Browse Forums
Jobs
Start A Group
Tell A Friend
Donate
Whitepapers

Come Join Us!

  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
E-mail*
Handle

Password
Verify P'word
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Member Feedback

"...Congratulations on a brilliant idea and a great site..."
More...

Geography

Where in the world do Tek-Tips members come from?
Click Here To Find Out!
Home > Forums > Programmers > DBMS Packages > Microsoft SQL Server: Integration Services (SSIS) Forum

 Flat File Source Problem...

thread1555-1321785
victordba (Programmer)
12 Jan 07 14:09
I have a weird thing happening.
I have an .csv file. When I try to load it into a table, I can do it easily in DTS 2000. But when I am trying to do it in SSIS 2005 with exactly the same settings (like Text qualifier, row delimiter etc.), I am getting an error: "The last row in the sampled data is incomplete. The column or the row delimiter may be missing or the text is qualified incorrectly." I looked at the file and it looks complete to me.

What could be the problem ?

P.S. DTS 2000 is on 32-bit Windows, and SSIS 2005 is on 64-bit Windows 2003. Could that we a problem ?
victordba (Programmer)
17 Jan 07 7:57
Guys ? Anyone ?
I can't believe that nobody had this problem with delimited text source file.
IBACFII (Programmer)
22 Jan 07 18:48
I would open the file and take a look. Then I would compare your SSIS data flow to that of your DTS. Then look at the SSIS settings for that file.

Start A New Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Promoting, selling, recruiting and student posting
are not allowed in the forums.
Posting Policies
LINK TO THIS FORUM!
(Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum)
TITLE: Microsoft SQL Server: Integration Services (SSIS) Forum at Tek-Tips
URL: http://www.tek-tips.com/threadminder.cfm?pid=1555
DESCRIPTION: Microsoft SQL Server: Integration Services (SSIS) technical support forum and mutual help system for computer professionals. Selling and recruiting forbidden.

 

Back To Forum

Back To Microsoft SQL Server: Integration Services (SSIS)