I am using SSMS (SQL Server 2019 Developer Edition - Latest Build)
Windows 10 & Office 2010 (64 Bit)
I have an existing Table (with historic data) in one of my server instances and I frequently need to add data to this table.
My new data is in Excel Files with same Columns structure as per my existing table in SQL.
So I used the 64 bit import wizard to add data into my existing Table in SSMS.
During the process I saved the wizard as SSIS Package to run again, as I had to manually edit over 50 columns for data types, and I don't want to repeat it every time I import.
When I try to run the wizard again using the SSIS Stored Package it throws back errors