|
|
 |
How do I enumerate tables in an Access Database
|
| Total Hit (1205) |
If you need to enumerate the tables in an Access database, the easiest method is through the ActiveX Data Objects Extensions for Data Definition Language and Security. The ADOX library, as it is better known, can be used just like other COM objects from within ActiveX script, such as a task or workf
....Read More |
Rating
 |
|
|
|
Working with files and the FileSystemObject
|
| Total Hit (1155) |
The ability to work with files gives us great flexibility in how we use DTS. It allows us to add some intelligence into a package, and cope with unexpected situations automatically. The key to working with files is the Scripting Run Time as this gives us the FileSystemObject, which can be fully expl
....Read More |
| Rating
|
|
|
|
How do I open a file package or template
|
| Total Hit (988) |
In the save package dialog screen there are several Locations available. The Structured Storage File option is useful if you wish to keep the package as a file, perhaps so that it can be added into a source control repository, or for manually copying to another server or transfer media. Whilst it is
....Read More |
| Rating
|
|
|
|
Create an Access Database
|
| Total Hit (1016) |
When exporting data to a text file, if the file does not exist it will be created, or if it does exist it will be overwritten. In contrast, when exporting to an Access database the file and table must exist already. This article will show you how to create an empty Access database ready to receive y
....Read More |
| Rating
|
|
|
|
Open File Dialog Custom Task
|
| Total Hit (1185) |
If you run packages manually and want the ability to select a file through a GUI, this is for you. This is a simple custom task that pops up a standard windows open file dialog box when executed. It assigns the chosen filename to a global variable for use within the package.
....Read More |
| Rating
|
|
|
|
Coping with text files and abnormal column or row delimiters
|
| Total Hit (1292) |
Sometimes you may receive a text file to import that has a row or column delimiter not available in the standard drop-down boxes of the Text File Properties dialog.
The first thing to try in these cases is to type directly into the Row Delimiter or Column Delimiter box. This will work fine if th
....Read More |
| Rating
|
|
|
|
Import all files in a directory using DTS (Multi Pkg)
|
| Total Hit (2298) |
This example shows how you can use two DTS packages to control the import of all files in a given directory. For this, it is assumed that all files have the same format, and that all files are imported into the same table.
|
| Rating
|
|
|
|
|
|
|
|
"File Watcher" for SQL Server
|
| Total Hit (1300) |
SQL Server Database administrators often come across situations where the scheduled DTS jobs failed because the Source File didn't arrive on time. It is a tedious process to cleanup if there are dependent jobs that have run before the first DTS job completed successfully. The intent of this article
....Read More |
| Rating
|
|
|
|
|
|
DTS Servers and Schedulers for MS SQL
|
| Total Hit (2155) |
Learn the basics of creating a DTS server, including how to change the DTS package according to batch schedulers used and the steps required to create and schedule jobs in Autosys and Smartbatch.
|
| Rating
|
|
|
|
SQL Server 2000 DTS Part 9 - DTS Designer Tasks
|
| Total Hit (1969) |
The last installment of this series discussed the basic principles and applications of the Transform Data task. This article continues, focusing on its more advanced features.
|
| Rating
|
|
|
|
|
|
|
|
SQL Server 2000 DTS Part 6 - DTS Designer Tasks and Package Workflow
|
| Total Hit (2139) |
As we indicated in our previous article, we are going to continue discussing various ways of utilizing global variables in DTS Designer tasks. In particular, we will look into their role in exchanging data between packages, using features built into the Execute Package task. As part of this discussi
....Read More |
| Rating
|
|
|
|
SQL Server 2000 DTS Part 5 - DTS Designer Tasks and Global Variables
|
| Total Hit (2045) |
In the previous article of this series, we covered types of DTS Designer tasks that are more straightforward. We will continue this discussion here, focusing on ones that are more complex. However, before we proceed, we will look into the concept of DTS Global Variables, which will help us understan
....Read More |
| Rating
|
|
|
|
SQL Server 2000 DTS Part 4 - DTS Designer Tasks
|
| Total Hit (1996) |
In the previous article of our series dedicated to SQL Server 2000 Data Transformation Services, we covered the first of the essential elements of a package - connection. Now it is time to look into another critical component - task - that is responsible for the processing of data retrieved through
....Read More |
| Rating
|
|
|
|
SQL Server 2000 DTS Part 3 - DTS Designer Connections
|
| Total Hit (2024) |
In our previous article of this series, we presented a way of creating DTS packages with wizards. Despite its simplicity, this approach has some limitations, which you can overcome in two ways - by using DTS Designer or by manipulating DTS object model with programming languages, such as Visual Basi
....Read More |
| Rating
|
|
|
|
SQL Server 2000 DTS Part 2 - Creating DTS Packages using Wizards
|
| Total Hit (2095) |
As we explained in the first article of this series, there are three methods of creating DTS packages - with DTS Designer graphical interface, with programming by directly using the DTS object model, or with wizards available from the SQL Server Enterprise Manager interface. We will focus here on th
....Read More |
| Rating
|
|
|
|
MDX Essentials: Basic Set Functions: The Order() Function
|
| Total Hit (1012) |
This is the twelfth article of the series, MDX Essentials. The series is designed to provide hands-on application of the fundamentals of the Multidimensional Expressions (MDX) language, with each tutorial progressively adding features designed to meet specific real-world needs.
....Read More |
| Rating
|
|
|
|
|
|
Export a Table to a Date Stamped File Name in SQL Server
|
| Total Hit (1176) |
Date stamping is a very common requirement in the IT industry for any data extract created. Through the DTS package with ActiveX script, it is very easy to date stamp a file. In this article, I am going to walk you through how to export a table to a date stamped file.
....Read More |
| Rating
|
|
|
|
Import Files with Date-stamped Filenames or Paths
|
| Total Hit (1238) |
DTS packages are fantastic features available in SQL Server 7.0 and SQL server 2000. One outstanding feature in the DTS package is the ability to run ActiveX scripts. ActiveX gives us an added advantage in handling many situations; we will discuss how to handle three of these situations.
File-nam
....Read More |
| Rating
|
|
|
|
Using DTS to Detect and Process a File
|
| Total Hit (1113) |
There is nothing better than when a new technology lends itself to solving an old problem; well, there may be some things better, but this will have to do for now. One of the classic problems in computing -- classic being defined as a problem I have seen before -- is processing files that were uploa
....Read More |
| Rating
|
|
|
|
DTS How to...Skip Rows during Import
|
| Total Hit (890) |
Firstly you can skip header rows by using the First Row property of the DataPump Task, see Advanced properties sheet. The Text File Connection also has a Skip Rows property, see file Properties of the Connection.
|
| Rating
|
|
|
|
|
|
DTS How to...Transfer Packages between Servers
|
| Total Hit (1103) |
There are two ways to transfer packages between servers. The simple method is to save packages as COM Structured Storage Files, copy them to the new location, then open and save them to the new server. Whilst this works, it is very tedious when you have a lot of packages. You can automate much of th
....Read More |
| Rating
|
|
|
|
DTS Errors
|
| Total Hit (1079) |
«LI»"Could not create component categories manager" Or "Could not create an instance of the DTS package"
«LI»"DTS WIZARD ERROR: CoCreateInstance - Class not Registered"
«LI»"The parameter is incorrect" Or "Invalid class string" Or "The system cannot find the file specified"
«LI»"The license fo
....Read More |
| Rating
|
|