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

N

narges Haghparast

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.Th

Continue reading...
 
Back
Top Bottom