How to execute a DTS package from within Access 2000

FAQ

Profile

How to execute a DTS package from within Access 2000

Database Forums (Home) -> DTS

Next: Value lists that depend on the value of a previou..

Author

Message

JDGUILTY

External

Since: Sep 14, 2005
Posts: 1

(Msg. 1) Posted: Wed Sep 14, 2005 12:45 pm Post subject: How to execute a DTS package from within Access 2000 Archived from groups: microsoft>public>sqlserver>dts (more info?)

I want to know how to execute an existing SQL Server DTS package from within Microsoft Access 2000. Let's say I have an Access form with one control on it, a command button, and I want to execute the package when the button is clicked. Let's call my SQL Server "SERVER1", my database within that server is called "Joe", and my DTS package is called "Bozo". I'm trying to keep this as simple as possible, just so I can get the "basics" down pat. Any help would be greatly apperciated. >> Stay informed about: How to execute a DTS package from within Access 2000

Display posts from previous:

Related Topics:

execute package of a number of execute package tasks - In a project I have created 6 dtsx packages, all doing about the same thing: sql task defines highest date in database and store in variable script task to create an oracle sql statement based on the above date dataflow task to 1.select from oracle...

Execute DTS package in SP - How would I execute DTS package in the SP? Thank you.

Execute SSIS Package - I re-created my DTS package in SQL Server 2005. I now execute the package using: [ Exec Master..xp_cmdshell 'DTExec /f C:\Data\packagename.dtsx' ] It is working fine however, is there another way of executing this package in SQL Server 2005 without..

user unable to execute a DTS Package - Hi, There is a package ' P' that is owned by a user "O"[Domain account with sysadmin/administrator rights]. Another user "U", who is not a sysadmin, but is db_owner of the DB that holds the Packages' objects, was not able to execut...

Execute Remote DTS-Package on different Server - Hello DTS discussion group, i'm going crazy with one maybe simple problem on executing DTS on SQLSERVER 2000. Situation: I have in my local environment a DTS-Package, which starts another DTS- Package. I used both dtsrun as command line task and the..

	Database Forums (Home) -> DTS	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum