The easiest way to do this is to go into SQL Management Studio and NOT BIDS.

^ Unsure why this doesn't work, maybe I need to be on forum for longer

https://www.sqlservercentral.com/Forums/Uploads/image-unavailable.png

I was going to give a screen by screen tutorial.

-Right click on your database

-Hover your mouse over tasks

-Go to Import Data

-Use this wizard to import data (I used a flat file source) into database tables

-Part of the wizard has a convert section which will take care of mostly everything

-Before getting to the finish window, you will be prompted as to whether or not you want to save the package and run immediately.

-I suggest not running the package immediately, saving it, opening it up in BIDS

You may have to change some data types (it seems non-Unicode string [varchar] doesn't like choosing it's size automatically) in bids.

I have run into problems where it required me to edit the package in bids and create an Execute SQL task== utilize the "truncate table" query, other times I did not.

I hope this helps.