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	33941 Hits
Working with files and the FileSystemObject 21 Apr 2003	Intermediate 7.0/2000	331478 Hits
Create an Access Database 13 Jan 2003	Intermediate 7.0/2000	59540 Hits
Open File Dialog Custom Task 30 Dec 2002		39347 Hits
Coping with text files and abnormal column or row delimiters 4 Jun 2002		42837 Hits
Find an Access Database (from anywhere on the file system) 14 May 2002	Beginner 7.0/2000	17434 Hits
Deleting an Excel WorkSheet from within a package 15 Apr 2002		34804 Hits
Importing a Named Range From Microsoft Excel 6 Apr 2002		55429 Hits
How can I dynamically set the Access System Database 16 Mar 2002		23486 Hits
How to check the file date 8 Mar 2002	Intermediate 2000	45381 Hits
Connecting to an AS400 with DTS 22 Sep 2001		32042 Hits
How can I change the filename for a text file connection? 18 May 2001		76882 Hits
How can I change the filename for an Access Connection? 18 May 2001		20327 Hits
Why can't I read the Password property from a DTS Connection? 18 May 2001		20288 Hits