Using destinations and understanding choices

- Understanding Destinations,…more important, what we're looking at here…is SQL Destinations.…What I want you to get out of this…is that as the products move forward…what used to be true…in a previous iteration of the product…may no longer be true,…and what I'm going to show you here is…back in the day…in SQL, if memory serves me, 2005,…for optimized performance…to load data…we used the SQL Destination…in an SSIS package,…rather than the OLE DB Destination.…

However, over the years…OLE DB has had a number of improvements.…So today, I would suggest using OLE DB.…The reason is that OLE DB…connection to load data…allows me to load locally,…that is, the package is running…on the same instance of SQL,…or remotely,…and so let me show you…what we're going to do.…To do this little demonstration,…what I've got here…is I've used a truncate table,…T-SQL, and what I'm going to do…is I'm going to load data multiple times…into the same table.…

So to do that, I'm going to have…to truncate it on out.…Truncate means, really, just to delete…