Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SSIS Insert New Data Only to Backup Tables
I did read up on CDC but I don't think my boss will like that, just a hunch. One concern I do have, about copying the full table every time is that the program that is constantly populating the original 6 tables has had the data go missing whenever the program had an update. So that is why I am...- kevinc88
- Post #3
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
SSIS Insert New Data Only to Backup Tables
Hello, I am new to using SSIS and have been tasked with creating a package to be a backup for some tables. Basically I have a total of 6 tables which have data in them that I need to create copies of in another database. I have created the 6 identical tables in the other database but was...- kevinc88
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Integration Services (SSIS)
