Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Daily SQL Articles by email:
Sign up
Content with tags
Miscellaneous
,
DTS
Items 1 to 11 of 11
Managing DTS packages - Editing, Scheduling, and Viewing Package Logs
In the second of a series of articles that targets the DBA new to an organization, this article looks at how to manage DTS packages.
Read more...
By
Haidong Ji
2006/10/06 (first published: 2003/01/02)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
40,678 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,880 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,661 reads
Comparison of Oracle Drivers
Oracle is usually a dirty word in the SQL Server community, but like it or not, lots of data resides in Oracle databases. And SQL Server is often used to gather this data together in a warehouse of some sort for spinning cubes, generating reports, etc. Haidong Ji looks at the various methods that you can connect to an Oracle driver and compares the speed of each. If you need to get data from Oracle, or may need to, this is the place you want to start.
Read more...
By
Haidong Ji
2004/07/21
|
Source:
SQLServerCentral.com
|
Category:
dts
Rating:
|
Discuss
|
Briefcase
|
15,879 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,880 reads
Trapping DTS errors with Transact-SQL
Joe has written some articles for us, he also some interesting comment on his site - this article looks at trapping errors such as timeouts or divide by zero.
Read more...
By
Additional Articles
2003/05/27
|
Source:
Other
|
Category:
dts
Rating:
Rate this
|
Briefcase
|
2,386 reads
Review of SQL 2000 Fast Answers
A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!
Read more...
By
Andy Warren
2003/04/18
|
Source:
SQLServerCentral.com
|
Category:
installation
Rating:
|
Discuss
|
Briefcase
|
18,208 reads
Managing DTS packages - Editing, Scheduling, and Viewing Package Logs
In the second of a series of articles that targets the DBA new to an organization, this article looks at how to manage DTS packages.
Read more...
By
Haidong Ji
2006/10/06 (first published: 2003/01/02)
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
40,678 reads
Using the Copy Database Wizard
In a follow up article to Rahul's article on 'Copying Databases from Server to Server' Andy looks at another option, the Copy Database Wizard introduced in SQL 2000. Easy to use, but like most wizards it has a couple gotchas you need to know about. Good article for beginners and pro's alike!
Read more...
By
Andy Warren
2002/07/18
|
Source:
SQLServerCentral.com
|
Category:
administration
Rating:
|
Discuss
|
Briefcase
|
10,929 reads
Review of SQL Server 2000 Programming (MSPress)
Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now!
Read more...
By
Andy Warren
2002/06/04
|
Source:
SQLServerCentral.com
|
Category:
installation
Rating:
(not yet rated)
|
Discuss
|
Briefcase
|
6,398 reads
Using FileSystemObject with DTS
This article will show you how to use the FileSystemObject to determine the existence of a file inside DTS.
Read more...
By
Brian Knight
2001/05/23
|
Source:
SQLServerCentral.com
|
Category:
dts
Rating:
|
Discuss
|
Briefcase
|
8,135 reads
Items 1 to 11 of 11
Tags
sql server 7
(9)
administration
(4)
programming
(4)
configuring
(3)
backup and restore
(2)
indexing
(2)
installation
(2)
security
(2)
stored procedures
(2)
triggers
(2)
t-sql
(2)
user defined function (udf)
(2)
data warehousing
(1)
distributed queries
(1)
english query
(1)
monitoring
(1)
openxml
(1)
performance tuning
(1)
replication
(1)
strategies
(1)
system development life cycle
(1)
updategrams
(1)
xml
(1)
xsl
(1)
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.