SSIS only 255 rows uploaded?

35 pts.
Tags:
Microsoft Excel
SSIS
Hi, I have a simple Data Flow with an Excel Source and an OLE DB Destination to upload data from an Excel file to an SQL table. The Excel file has 8155 rows. Once the package is finished running, the SQL table only shows 255 rows. The data access mode is Table or view - fast load. Any suggestions? Thanks

Answer Wiki

Thanks. We'll let you know when a new response is added.

How many rows does SSIS show have been transfered?

Discuss This Question: 7  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Check out my SQL Server blog "SQL Server with Mr Denny" for more SQL Server information.
    66,185 pointsBadges:
    report
  • SbcOrc
    It shows only 255 rows being transferred. I also tried the Data Access mode as an SQL command select * from `sheet1$` but SSIS still shows the first 255 rows being transferred. If I write an SQL command to fetch me a record after 255 rows, no rows are returned. On the other hand, the same command to fetch me a record in the first 255 rows,returns that row.
    35 pointsBadges:
    report
  • SbcOrc
    I tried to use another Excel file with 30,000 records, just one column, with dummy values, all cells have the General format. All 30,000 rows were uploaded. However, the Excel file with 8155 rows still extracts 255 rows in the Excel Source. All cells have the General format in this file, too. What gives?
    35 pointsBadges:
    report
  • SbcOrc
    Actually, some cells have Text format. If that is the cause of the problem, can you suggest a fix? considering that I am given the Excel file, and cannot set the format of the cells. Thanks
    35 pointsBadges:
    report
  • Denny Cherry
    You can try BCPing in the file. I think BCP will process an Excel file. You can also try setting up a linked server to the Excel file and access the data that way.
    66,185 pointsBadges:
    report
  • Squashjunkie
    I would also add loggin to your package to find if any errors are being reported when the data is uploaded. Add a data viewer to the package in the BIDS to view the rows as they are moving across and see if more rows are being read and moving through your package. Its deifficult to tell where the error is, could be the excel source itself, or your sql destination table. Check that there are no restrictions on your sql table which could prevent the upload of data, and if formatting in your excel sheet is a problem, you can always use a data conversion task to convert the data into the correct format.
    325 pointsBadges:
    report
  • LalithaPrasad
    I am facing the same problem. Only the first 255 rows are being inserted to the destination table. Please help.
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following