sql-serverssisetloledbconnectionssis-2017

SSIS OLE DB Destination Editor - Create New Table not an option?


I am trying to have upload a CSV file to my SQL Server via SSIS. Previously- like a few months ago- I was able to click 'New' on the destination editor to create a generic table based on the imported data. Is that option no longer available for some reason? I updated everything and made sure my credentials are correct and that I have read/write access but can't seem to get anything working. I'm using Visual Studio 2017 with SSDT.

My screen used to look like this :

OLD DB Destination Editor with 'New' table option

But now it looks like this :

OLE DEB Destination Editor with no new button


Solution

  • I faced the same issue previously. The reason was that the TargetServerVersion was not set correctly. Make sure that this property is set to the same version of the SQL Server instance you are using.