Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags DTS, SQL Server 7 Rss

<< Newer    Items 21 to 40 of 91    Older >>
 

DTS Hashing

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.   Read more...
By Alex Kersha 2005/12/20 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 5,781 reads

Granting Execute Access to All Stored Procedures to a Given User

A quick and dirty procedure to allow you to grant execute permissions to a user, or role, quickly and easily.   Read more...
By Tim Mitchell 2005/12/13 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 9,483 reads

DTS Polling

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.   Read more...
By Andre Quitta 2005/12/05 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 8,462 reads

Data Migration : Step by Step

This article by Chris Kempster covers a wide variety of areas concerned with data migration. Primarily, it focuses on process, standards and some of the many issues to consider when undertaking this role.   Read more...
By Chris Kempster 2005/11/25 (first published: 2004/03/24) | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 47,724 reads

Leveraging XP Excel , XML, and OPENXML for Data Imports

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.   Read more...
By Sloan Holliday 2005/11/22 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 10,633 reads

DTS Standards

SQL Server 2000 brought us DTS, a new way of working with data movement for SQL Server DBAs. However, unlike Integration Services and Project REAL, there weren't any great standards for working with this tool and building portable solutions was hard. Jonathan Stokes brings us a great article on how you can create a standard structure for your packages and make them more portable.   Read more...
By Jonathan Stokes 2005/11/21 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 8,593 reads

Overview of DTS Packages

While SQL Server 2005 is greatly changing the paradigm of ETL with Integration Services, SQL Server 2000 and DTS will be here for some time to come. New author Rama Nageshwara brings us an overview of this fantastic data movement toolset.   Read more...
By Rama Nageshwara 2007/12/21 (first published: 2005/11/09) | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 26,839 reads

Have You Been Told Today

SQL Server 2000 has a great job and alert subsystem, but it doesn't do everything. There are times when you want to be notified that something has completed, or not completed. New author Frank Loschiavo brings us a way to ensure that when you run a query you are notified if and when it completes.   Read more...
By Frank Loschiavo 2005/10/20 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 6,121 reads

Using DTS to Generate and Email Excel Reports

Another great article from Joe Sack that looks at a great technique for generating reports in Excel for your users. Using DTS, you can easily setup an ad hoc or recurring schedule for your users. It's a way to quickly build a report that keeps people happy while making you look like a genius.   Read more...
By Joseph Sack 2005/09/23 (first published: 2004/05/03) | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 39,698 reads

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: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 13,942 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: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 91,793 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: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 36,508 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: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 14,526 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: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 33,880 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: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 12,187 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: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 9,151 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: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 10,756 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: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 11,840 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: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 10,290 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: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 49,989 reads
<< Newer    Items 21 to 40 of 91    Older >>
 
Tags
administration (9)    
miscellaneous (9)    
programming (8)    
configuring (4)    
t-sql (4)    
visual basic 6 (4)    
backup / restore (3)    
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)    
ado (1)    
advanced querying (1)    
best and worst practices (1)    
best practices (1)    
book reviews (1)    
capacity planning (1)    
design and theory (1)    
disaster recovery (dr) (1)    
english query (1)    
integration services (ssis) (1)    
openxml (1)    
perl (1)    
product reviews (1)    
replication (1)    
sql server 2005 (1)    
sql server 6.5 (1)    
system development life cycle (1)    
updategrams (1)    
xml (1)    
xsl (1)