tags:

views:

31

answers:

0
Q: 

Creating multiple Access Databases as Targets in a SQL 2000 DTS Package

I'm new to creating DTS packages with SQL Server 2000 (although I'm not new to programming).

I'm interested in creating a DTS package which dynamically creates a few Access Databases to hold the results of some queries executed against a SQL Server 2000 Database. I've seen a question on here that was answered by the author, so I know its at least possible!

Does anyone have any examples that I could look at and learn from? Or a walkthough of the steps I need? I'm not looking for someone to do this for me, as I'm looking to understand the whole end-to-end process myself, but I tend to learn quicker from examples.

related questions

DTS DB2 Connection Problem
Importing Excel into SS2000; Error on Field; DTS
Catching events from an SSIS package loaded in C#
SQL Server 2000 FTP
DTS- Debugging Tips
Move data accross SQL Servers with DTS packages or linked servers
Open a .BAS DTS Package in SQL 2000?
How can I run sql server stored procedures in parallel?
How do you restore DTS permissions after database restore on SQL 2000
XMLHTTP POST request and System.Reflection
Converting DTS packages to SSIS
What is the best way to execute an MS SQL Server 2000 DTS package from a trigger?
How do I export the SQL statement from a DTS object?
Using SQL Server DTS Package to Conditionally Insert / Update Rows in Destination Table
DTS Packages & a Connection to Access
The SQL Server DTS Connection2 object has an undocumented property, UseDSL. What does it do?
Error when copying a check constraint using DTS
SQL DTS Database Copy Fails
Create SQL Table from Excel spreadsheet
How do you copy a MS SQL 2000 database programmatically using C#?
What Oracle driver should I install in my MS SQL server to be able to use DTS to copy data from the Oracle server to the MS SQL server?
Can the ffmpeg av libs return an accurate PTS?
How to use stored procedures within a DTS data transformation task?
How can I create a human-readable script for every DTS package on a SQL server?
Can DTS Test for Presence of MS-Access Table