Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server DTS
|
SQL Server DTS Discussion specific to Data Transformation Service with SQL Server. General SQL Server discussions should use the general SQL Server forum. Readers of the book Professional SQL Server 2000 DTS with questions specific to that book should post in that book forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server DTS section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 11th, 2007, 06:50 AM
Authorized User
 
Join Date: Jun 2005
Posts: 32
Thanks: 0
Thanked 1 Time in 1 Post
Default Deleting data using DTS

Hi,
I am a new bee in DTS.
I would like to delete the data in dBase5.
My dBase5 is reside in a disket.
I delete the data using SQL. But how am I going to tell the DTS to delte from my disket?
Does anyone has idea or suggestion for me?

 
Old May 11th, 2007, 11:09 AM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

Is the dbase5 db on the server or your workstation?

you can create a share and point to it using. use the sql task to execute the command to delete the data.



Jaime E. Maccou
 
Old May 11th, 2007, 06:40 PM
Authorized User
 
Join Date: Jun 2005
Posts: 32
Thanks: 0
Thanked 1 Time in 1 Post
Default

I am using SQL Servver 2000.I have create the sql task to execute the command but I have no idea to tell it to execute from my disket.....






Similar Threads
Thread Thread Starter Forum Replies Last Post
Deleting rows from a data table in datagrid ann03 ASP.NET 1.x and 2.0 Application Design 1 October 23rd, 2007 06:23 AM
deleting data with an action button Vince_421 Access VBA 11 May 24th, 2006 08:02 AM
Deleting Rows in an Editable Data Grid RichardP ASP.NET 1.0 and 1.1 Professional 2 March 1st, 2006 02:19 PM
Deleting Data with SQL Teqlump SQL Language 4 October 6th, 2004 03:58 AM
Deleting data from database jaideepc ADO.NET 0 August 11th, 2004 04:04 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.