I am a total noob to SSIS...I am creating a new package that takes data from an OLE DB source and overwrites the data in another OLE DB source. I set up my connections and dataflow tasks, but how do I truncate the destination table and import all of the data from the source? Or would it be easier/better to just import any new records?
Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.