Reading online and in the newsgroups, I still haven't come across any easy
way to copy a database with identity columns intact.  I can't put the source
DB offline (detach) and I don't provide my developers with full sysadmin
rights or NTFS rights to the backup folder.

can not see how to create a DTS package, using SQL Measurement studio,
thanks.  I have created many using Enterprise manager with sql2000.

SQL Server 2000 SP3
I'm attempting to create a DTS package that exports data from a stored proc
to a text file.  When the package is run I get the
following error:

*simple problem and newbie has no clue..* ;-)
I have to copy data from one sql server table into another sql server
table. I'm using SSIS for the first time...
I'm using a simple data type conversion to move the data from one table

I need to write a DTS package which is date oriented and I'm having problems
getting something coherent. I'm not a big guy in SQL Server, so please excuse
my ignorance.
I need to get some sales information based on the previous day...however, if

what sys table holds description on a dts task?

Hoe do I get the latest DTS version ID with an sql statement?

I'm trying to set up a DTS job to FTP from SQL2000 to Unix.  I seem to only
be able to use UNIX as a source not a destination.
Is there another task I should be using to move a file from SQL to Unix?
Thanks.

Can anyone help with this problem

I'm getting the following message when running a DTS package (SQL 2000)
"Microsoft Data Transformation Services Flat File Rowset Provider, Error
opening datafile: The system cannot find the file specified"
The file is residing on the servers local hard drive. It is a fairly simple

Can anyone help me with the following problem....i have a description filed
that has many spaces in beween words...how can i remove them?
DESCRIPTION
----------------

Does SQL Server2000 DTS support sftp (secure ftp)?
Thanks.
Ron

I would like to know if are there any conditional test to import data into
SQL Server? I am importing data from a text file and I would not like the
data to be duplicated in SQL Server. For example, if a Receipt code alreay
exists in the SQL Server I would not like that ...

I've a question that I can't seem to find an answer on so I figured I'd
see if it can even be done.
We have several DTS packages that are run on schedule through several
jobs. Is there a way in job step to get the error message from a

Code DTS Event handlers in an ActiveX Script in the DTS Package
When executing a DTS Package in VB6 using the DTS Object etc ... You
can install
the DTS Event handlers and add code to them