I am trying to write a very simple DTS package which copies all object from
one database to another existing database.
If the target DB is empty all works fine. However if the target DB already
has data I get the following error message:

I'm now  trying to transfer some data from an Oracle database to sqlsever,I
had two questions:
1) There are two providers available( ODBC and OLEDB ) for connecting to
oracle database.which one is better?

I am doing my first dts and I am getting very fustrated.
Need to ftp some files, massage some data, and load it in a table.
Using dts seems very cumbersome
 Reading the files via ftp doesn't work because can't change directories on

I am using the DTS COM object to import a bunch of different text files.
 some are 2 or 3 million rows.  if there's an invalid row (can't find
row delimiter or column delimiter) sometimes DTS will crash and stop the
import... it even does it if I try to import it from the GUI, ...

Hi eb
Seems like some funny credentials problem(?):
I am trying to connect and load an excel sheet in to a sql server table.
Executing the dts package directly works just fine but running the same

Table: tblTestImport
Reference varchar (10) Primary Key
PlannedEnd smalldatetime
CompletionStatus smallint

If transferring multiple tables between source connection and destination
connection I can create these connections once and then define multiple
tasks between those two connections, but I don't appear to have any control
over sequence or "only do this if this other has succeeded".

   I have created a DTS package that copies data via an ODBC connection
into a MSSQL 2000 Server + SP3 on a Win2000 server + SP4. The package runs
as a scheduled job at 15 min intervals due to data volumes and network
bandwidth to keep the transfers small.

I'm new to DTS and am trying to work out the best way to approach a
task. I was wondering if anyone could advise me?
The situation is that we have a folder which, every few hours, will
have a number of .csv files deposited into it, which will all have

Greetings from Serbia,
as subject saids, does anyone had expirience with it?
I need to find a way to export a database, with all tables, and relations if
it is possible to a one or more txt files. This is my first task in this new

I have to pull in some data from a huge table on another server.  I have a
local table containing the acctnumbers I need.  But, I cannot figure out a
way to bring in only the records having an acctnumber in the local table.  I
have tried to configure a lookup, but that doesn't ...

I have an insert trigger into a table, but when I insert data using a DTS,
the trigger is not shot.
If I insert data manually, trigger works sucessfuly.
There's any way to make trigger works using a DTS??

When i am importing a foxpro table, linked by ODBC, i have a problem with
date field.
The definition in foxpro is standard date. The program is from a third
party, so everything is defined and we cannot change anything. We want to

I want to get a file via ftp.  Using the ftp control I connect to the remote
server how ever I can not specify the file, because I can not change to the
directory I need.  The directory does not show up in the file list.  The
directory is hidden.  How can I download the file?  I ...

Hi gurus,
When I try to use ActiveX script to load a DTS package from one server
(package.LoadFromSQKServer) and then save to another server
(package.SaveToSQLServer), I can succeed in doing this but the layout of the