Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag DTS Rss

<< Newer    Items 41 to 60 of 123    Older >>

Generating Test Data with Integration Services

DTS was one of the most amazing new features of SQL Server 7 and in SQL Server 2005 it has been renamed to Integration Services. This component has some incredible new capabilities, many of which come at a steep learning curve. New author Kristian Wedberg brings us a basic article and some code on how you can SSIS to generate test data.   Read more...
By Kristian Wedberg 2005/08/29 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 14,043 reads

Data Import Functionality Using SQL Server

Building robust functionality with maximum re-use of existing infrastructure and investment with little or no development is the goal for many businesses. This article is about using SQL Server DTS packages to achieve this goal. With minimum development, all the functionality required for data imports can be achieved with DTS programming in SQL Server.   Read more...
By Jayram Tallamraju 2005/08/12 (first published: 2002/10/25) | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 91,822 reads

Push FTP with SQL Server

DTS is an incredible package for moving data in the SQL Server world. One feature that is missing, however, is the ability to send files using FTP to a remote server. This article looks at a technique for sending files via FTP.   Read more...
By Steve Jones 2005/07/01 (first published: 2001/11/01) | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 36,563 reads

Dynamic Properties

One of the most useful tasks in SQL Server 2000's DTS environment is the Dynamic Properties task. Author Kathi Kellenberger brings us a look at how this task can help you accomplish an unusal import task.   Read more...
By Kathi Kellenberger 2005/06/20 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 14,543 reads

Portable DTS Packages

Have you ever faced the situation where you have needed to move a DTS package you needed to move a DTS package from one server to another, say from development to production? In this article by Kevin Feit, he shows you how to make a DTS package portable and save time.   Read more...
By Kevin Feit 2005/05/20 (first published: 2003/05/09) | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 33,890 reads

Importing The Latest File In A Folder Via DTS

Using the Dynamic Properties Task in SQL Server 2000 DTS is a great way to build a flexible package that can handle a variety of situations. Things are much improved in SQL Server 2005 Integration Services, but many of you will need to solve a common problem until you can upgrade. New author David Jackson brings us a technique for finding and processing the latest file in a folder.   Read more...
By David Jackson 2005/04/12 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 12,204 reads

More Portable DTS Packages

There have been a few articles over time on how you can build DTS packages in SQL Server 2000 that are easily moved from one server to another. New author Tito David brings us another technique that not only migrates packages easily between servers, but between your development and production environments.   Read more...
By Tito David 2005/04/07 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 9,152 reads

Flexible DTS Packages with Perl

SQL Server 2000 DTS was a revolutionary programming environment, but one that was not without a few quirks. As often found with many Microsoft products, there were sections in your packages where things were hard coded, making them less flexible. New author Jeremy Brown brings us a look at how you can build extremely flexible packages using Perl.   Read more...
By Jeremy Brown 2005/04/05 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 10,759 reads

The Multi Phase Data Pump

SQL Server 2000 has an amazing ETL tool in Data Transformation Services that is included at no charge, something none of the other database vendors include. DTS has great flexibility to make your job easier, but it has some quirks in this version. The Multi Phase Data Pump is hidden inside the tool, but can provide a great programming environment and Dinesh Asanka brings us a look at what you can do wit this tool.   Read more...
By Dinesh Asanka 2005/03/29 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 11,863 reads

Automating DTS Execution

Database Transformation Services (DTS) in SQL Server 200 was a breakthrough tool, really paving the way for a low-cost, easy to use, ETL tool. However, it was not a true robust programming environment and contains quite a few quirks that are apparent as you get into more detailed packages. New author Gus Carnu addresses one of those issues with a look at the ExecutePackage task.   Read more...
By Augustin Carnu 2005/03/24 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 10,293 reads

You have built a simple package in SQL...

By Steve Jones 2005/02/24 | Category: dts
Rating: (not yet rated) |  Discuss |   Briefcase | 2,217 reads

SQL Server Security Part 1

In this series of articles, Chris Kempster will discuss some of the finer aspects of SQL Server security and also touch on OS, physical and application security to open up this science for general discussion.   Read more...
By Chris Kempster 2005/02/11 (first published: 2002/01/14) | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 50,065 reads

Coupling Outlook to SQL Server

SQL Server has drivers to read almost any data source, but they are not always the easiest to work with. New author Kevin Terry spent quite some time learning how he could pull data from Outlook using DTS and scripting. Most information on the internet requires Exchange to be on the same server as SQL Server to get the data, but this solution works with any configuration, and can pull any information, email address, contact information, etc. from Outlook.   Read more...
By Kevin Terry 2005/02/01 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 18,068 reads

Restore multiple DTS packages

This article examines how to take advantage of VB Script and MS-DOS batch files to restore multiple DTS packages stored in the form of structured storage files from one folder to a SQL Server box.   Read more...
By Additional Articles 2004/10/20 | Source: Database Journal | Category: dts
Rating:  Rate this |   Briefcase | 1,914 reads

DTS: Copy Objects Task

SQL Server DTS may be one of the best tools ever included with a database server. It makes data movement, copying, any sort of ETL task a breeze. At least for the most part. Bruce Szabo found a place where the Copy Objects task sometimes doesn't work as expected. This article looks a problem he had as well as the solution that you can use to ensure that this task works reliably for you.   Read more...
By Bruce Szabo 2004/10/13 | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 8,686 reads

Automating "Save DTS package"

MAK examines how to save all of the DTS packages from SQL Server to a structured storage file automatically.  Read more...
By Additional Articles 2004/10/07 | Source: Database Journal | Category: dts
Rating:  Rate this |   Briefcase | 2,261 reads

Redistributing DTS with your program

Have you ever wanted to run DTS on a workstation or server that doesn't have SQL installed? Here's the items you need to move to make it happen.   Read more...
By Additional Articles 2004/09/15 | Source: | Category: dts
Rating:  Rate this |   Briefcase | 1,469 reads

Locking Down DTS

There's no security role to prevent or allow users to creating DTS Packages. Find out how to lock down DTS on your system.   Read more...
By Brian Knight 2004/09/10 (first published: 2001/04/21) | Source: | Category: dts
Rating: |  Discuss |   Briefcase | 8,285 reads

I built a DTS transformation that exports data...

By Steve Jones 2004/08/17 | Category: dts
Rating: (not yet rated) |  Discuss |   Briefcase | 2,521 reads
<< Newer    Items 41 to 60 of 123    Older >>
sql server 7 (76)    
administration (9)    
miscellaneous (9)    
programming (8)    
backup and restore (4)    
configuring (4)    
integration services (ssis) (4)    
t-sql (4)    
visual basic 6 (4)    
performance tuning (3)    
security (3)    
stored procedures (3)    
data warehousing (2)    
distributed queries (2)    
indexing (2)    
installation (2)    
monitoring (2)    
reviews (2)    
strategies (2)    
triggers (2)    
user defined function (udf) (2)    
64-bit (1)    
ado (1)    
advanced querying (1)    
best and worst practices (1)    
best practices (1)    
blogs (1)    
book reviews (1)    
capacity planning (1)    
configuration (1)    
design and theory (1)    
disaster recovery (dr) (1)    
english query (1)    
error handling (1)    
error log (1)    
handle (1)    
ini (1)    
openxml (1)    
perl (1)    
portability (1)    
product reviews (1)    
replication (1)    
sql server (1)    
sql server 2005 (1)    
sql server 2008 (1)    
sql server 6.5 (1)    
system development life cycle (1)    
updategrams (1)    
vbscript (1)    
xml (1)    
xsl (1)