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.
Subscribe to:
Post Comments (Atom)
Navigating the Data Science Seas: A Journey with Microsoft Fabric
Data science is a vast and exciting field, brimming with the potential to unlock valuable insights. But like any seafaring voyage, navigatin...
-
From the past 3 days I have been working on resolving merged and hidden cells issues when an SSRS reports is exported to excel. ...
-
I was trying to build an SSIS package that one of my colleagues has created. The first error that was thrown was as below: Exception des...
-
Today I was trying Node.js to connect to SQL Server, the connection to the sql server failed with the below error. name: 'ConnectionE...
No comments:
Post a Comment