Issue Importing Large Data Sets in Visual Studio 2019 and SQL Server 2019 on Windows 11

Question

Hi everyone,

I recently installed Visual Studio 2019 and SQL Server 2019 on my Windows 11 system. When creating a project that involves importing a large data set with more than 1 billion rows, I encounter some issues.

When using the SSIS process and data packages to import the data, I face the following problems:

• Using the .xls format, only 65,000 rows are imported.
• Using the .xlsx format, the data is not imported correctly.

Could someone please help me resolve this issue? Is there a better way to import large data sets into SQL Server? Using the .xlsx format, the data is not imported correctly.

Thank you in advance for your assistance.

Answer 1

Hello,

You're welcome.

Best Regards,

Molly

Answer 2

thanks your kindness

Answer 3

Hello

Thank you for posting in Microsoft Community forum.

Based on the description, I understand your question is related to the SQL Server.

Since there are no engineers dedicated to SQL Server in this forum. in order to be able to get a quick and effective handling of your issue, I recommend that you repost your question in the Q&A forum, where there will be a dedicated engineer to give you a professional and effective reply.

Here is the link for Q&A forum.

Questions - Microsoft Q&A

Click the "Ask a Question" button in the upper right corner to post your question and select "SQL Server" tag.

Thank you for your understanding and support. If you have any question or concern, please feel free to let us know.

Have a nice day.

Best Regards,

Molly