Today I wanted to schedule a data update process to be processed every month for the table I created using DTS last month.
I wanted to populate a brand new database from an exisitng database. I thought I would just schedule a package with a few SQL queries to populate the different tables in the new database. But before I proceededI wantedto find out an efficient and best way to do it.
So I posted my questions in two forums. This is what I found out from the experts:
Before you decide on setting up the DTS package there are several aspects to consider.
Do you want to recover the database from a backup when something goes wrong?
Do you want to just reload everything when something fails?
Do you want to save logging information so that you can recover the database?
Based on the answers to these questions, the best way to create a DTS package for my scenario is to create the tables with the structure and then create the DTS package using many Data Driven Query Tasks that contains the SQL statemetns of select, Insert and Update depending on whatever the case may be.
DTS is an excellent tool to schedule population of data into a database.
Today I had a situation where a few of the subscriptions for a particular report have failed. I needed a script to run only these subscripti...
I have been in hibernation for too long now. I have changed jobs and now hjaving an opportunity to work on SAS code after nearly 11 years. ...
What is Checksum? Checksum is a function available in sql server 2005 and sql server 2008. It is intended to build a hash index based on an ...