Home
DTS FAQ
Administration
Connections
Execution
Tasks
Microsoft KB
Troubleshooting
Workflow
Tutorials
SQL 2005
Resources
Download
Links
Search
About
Copy Link
Newsletter
Add Favorite
Print
del.ico.us
Digg this
Professional SQL Server 2005 Integration Services
Connections
Connections are where our data is either coming from or going to. Some connection types you find in DTS have their own special way of doing things. In this section we address some of those features helping you to produce packages with the minimal amount of fuss. We also look at how to take charge of connections and make them work for you
How do I enumerate tables in an Access Database
26 Aug 2003
Intermediate
7.0/2000
36569
Hits
Working with files and the FileSystemObject
21 Apr 2003
Intermediate
7.0/2000
340819
Hits
Create an Access Database
13 Jan 2003
Intermediate
7.0/2000
64307
Hits
Open File Dialog Custom Task
30 Dec 2002
42401
Hits
Coping with text files and abnormal column or row delimiters
4 Jun 2002
45520
Hits
Find an Access Database (from anywhere on the file system)
14 May 2002
Beginner
7.0/2000
19510
Hits
Deleting an Excel WorkSheet from within a package
15 Apr 2002
37452
Hits
Importing a Named Range From Microsoft Excel
6 Apr 2002
58912
Hits
How can I dynamically set the Access System Database
16 Mar 2002
25475
Hits
How to check the file date
8 Mar 2002
Intermediate
2000
48543
Hits
Connecting to an AS400 with DTS
22 Sep 2001
34563
Hits
How can I change the filename for a text file connection?
18 May 2001
80430
Hits
How can I change the filename for an Access Connection?
18 May 2001
22419
Hits
Why can't I read the Password property from a DTS Connection?
18 May 2001
22231
Hits