Migrating SQL Server to access database using DTS

[Martin captivasystems]

How can I use DTS to migrate some tables and views from SQL server to a new access database? I want to be able to do this programmatically, so that the windows application user can create an access database from an existing SQL server. Thanks, Martin

[Yulianto]

Search for "creating package dts" or see the samples in SQL Server manual. Or google for it. I found this[^] and this.[^]. Is this help?

---

Work hard, Work effectively.

[Selahattin Bostanci]

Just create your dts package with sql server and then have look at this article. http://sqldev.net/DTS/DotNETCookBook.htm[^] Article is about calling dts packages programatically with .NET.