While SSIS is taking the SQL Server 2005 world by storm, there are many DBAs still working with SQL Server 2000 and its ETL system: DTS. In this article, Jambu Krishnamurthy shows us how to modify the exception handling in a DTS package to get around the limitations of the designer.
2007-12-14 (first published: 2006-12-19)
9,300 reads
A colleague working on an Informix database needed to search TEXT columns using wildcards. While Informix supports wildcards in LIKE and MATCH predicates, this support does not include TEXT columns. The obvious solution—to export the data to SQL Server—does support such searches.
2006-08-03
2,271 reads
SQL Server 2005 has substantially enhanced its ETL capabilities, but many people will still be working with DTS in SQL Server 2000 for many years. New author James Greaves brings us a technique for working with imports and handling files that might not have any data.
2006-03-27
6,805 reads
2006-02-22
1,926 reads
SQL Server 2000's DTS subsystem is a tremendously flexible environment for handling any number of tasks on your SQL Server. Alex Kersha used DTS to implment a task that manages the number of backup files on his server, which is conifgurable with a global variable. Read on and get the code to implement this task on your servers.
2006-02-20
20,360 reads
One would think that when you have to work with Unix text files, they would be the same as Windows text files. That is not quite the case and Peter Ward brings us a look at how this caused a problem in DTS and a way you can fix it.
2006-01-10
9,525 reads
DTS is a great tool in SQL Server 2000 for easily setting up jobs to import or export data. But it can also have security risks. New author Alex Kersha brings us a simple security technique to be sure that you are properly executing your DTS packages in a secure manner.
2005-12-20
5,906 reads
A quick and dirty procedure to allow you to grant execute permissions to a user, or role, quickly and easily.
2005-12-13
9,947 reads
Lots of packages exist that will import data files for you, even if you do not know the file name ahead of time. But most of them expect the files to be there. New author Andre Quitta brings us a technique he has for checking to see if the files are even there before importing them.
2005-12-05
8,496 reads
DTS is a fantastic ETL tool and it is often used to import Excel documents. However this can be a manual process in many cases in setting up the package. New author Sloan Holliday brings us a way that you can leverage Office XP's automation facilities and XML to import data into SQL Server.
2005-11-22
10,978 reads
By Steve Jones
Often we find out about a problem reported by a customer after the incident...
Let’s face it, most of the time, you probably don’t want your SQL Server...
By Steve Jones
I was asked about state-based deployments in Flyway Teams, so I decided to show...
Many job schedulers (e.g., SQL Agent, Airflow, Azure Logic Apps) can report when a...
Comments posted to this topic are about the item The Table Backup
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
I run this code in SQL Server 2022. What happens?
BACKUP TABLE beercount TO DISK = 'beercount.bak'See possible answers