|
How to change owner of DTS Package
|
Total Hit (2744) |
Here is an example to change ownership of a DTS Package of SQL Server. You can use undocumented stored procedure msdb.dbo.sp_reassign_dtspackageowner to change ownership. This stored proc requires 3 parameters. First parameter is @name which is name of package. Second parameter is @id which unique I
....Read More |
Rating
|
|
|
How to move, copy, and back up full-text catalog folders and files
|
Total Hit (1502) |
Full-text catalogs and indexes are not stored in a SQL Server database. Full-text catalogs and indexes are stored in separate files that the Microsoft Search service manages. The full-text catalog files are not recovered during a Microsoft SQL Server recovery. Additionally, you cannot use the Transa
....Read More |
Rating
|
|
|
|
How can I check if a file exists?
|
Total Hit (662) |
Checking for the existence of a file before trying to import it can be very useful in ensuring your systems run smoothly. You can use the Scripting FileSystemObject to check for the presence of a file using ActiveX Script. If the file exists you can obviously import it or initiate an alternative pro
....Read More |
Rating
|
|
|
Tutorial : Problems With IDENTITY() and the DataPump task.
|
Total Hit (722) |
Just recently we have seen a number of posts in the newsgroups concerning problems with IDENTITY columns when inserting data into a table using DTS. This walkthrough should hopefully explain most of the problems we can encounter and give you some useful information about behind the scenes stuff as w
....Read More |
Rating
|
|
|
Tutorial : Write File Transformation
|
Total Hit (729) |
In this article we will show you how to export a file stored in your SQL Server table out to disk. For this we will need two tables. One will be the table that holds the file and its name and the other is a dummy table that we need when using the WriteFile transformation.
....Read More |
Rating
|
|
|
Tutorial : Introduction to Workflow
|
Total Hit (705) |
This article will give you a quick overview of the three types of workflow precedence constraints available and also highlight a couple of common problems associated with workflow. The most basic feature workflow gives you is the ability to control in which order your tasks will be executed. If all
....Read More |
Rating
|
|
|
|
Tutorial : Introduction To Global Variables
|
Total Hit (734) |
Global Variables allow you to make your DTS packages more flexible. Some of their uses include.
1. Storing Values passed around within a package.
2. Accepting values from outside the package to be used inside it.
3. Holding not only single values but multiple values in a recordset.
....Read More |
Rating
|
|
|
Tutorial : A Tour Of ActiveX Script
|
Total Hit (644) |
One of the ways to gain a lot of Flexibility in DTS is to use an ActiveX script. They can be found in the transform Data Task, the Data Driven Query Task and as a standalone task. When we look at the actual screens there is a lot to see and some of the things can be daunting especially if you have n
....Read More |
Rating
|
|
|
Tutorial : Building a Package in the DTS Designer
|
Total Hit (710) |
The point of this tutorial is to give us an introduction to the DTS designer. If you're serious about DTS or want to explore more of its many features then it won't be long before you end up here. This tutorial was created using SQL Server 2000 but users of SQL Server 7 will still find it useful. Wh
....Read More |
Rating
|
|
|
Tutorial : Importing A Text File Using The DTS Wizard
|
Total Hit (686) |
This tutorial came about from watching the Newsgroups and realising that although people had heard of DTS they were unsure as to what it is and where to find it. We wanted to explain DTS to people and give them an understanding of what it does so they can go away and use it themselves.
....Read More |
Rating
|
|
|
Tutorial : How to Use Lookups in DTS
|
Total Hit (612) |
When you see people in the newsgroups answering a question with a query and the query includes a question mark then you may be forgiven for thinking that the person who is replying doesn't know what value goes in here. Here we present a different answer and yes you guessed it the solution we present
....Read More |
Rating
|
|
|
Tutorial : Sample Custom Task Project
|
Total Hit (627) |
The ability to write your own custom tasks is often overlooked when designing a solution and yet it can offer so much flexibility. This is a sample Visual Basic project of a relatively simple custom task. It doesn't do very much, but it does have a user interface and several properties. The UI allow
....Read More |
Rating
|
|
|
A Practical Guide to SQL Server Yukon Beta 1 DTS
|
Total Hit (1550) |
To understand the new features in "Yukon" Data Transformation Services (DTS), one must in many ways take a step back from the knowledge of prior DTS releases and come to the product with a fresh perspective. It is not that the new release is entirely different than its predecessors, but the similari
....Read More |
Rating
|
|
|
Data Transformation Services (DTS) in Microsoft SQL Server 2000
|
Total Hit (676) |
Database administrators often import, export, and transform data in support of tasks such as data consolidation, archiving, and analysis; for application development purposes; and for database or server upgrades. Data Transformation Services (DTS) in SQL Server 2000 provides a set of graphical tools
....Read More |
Rating
|
|