I am building a DTS Packet that pulls data from a view and uses that
data as a conditional on Server instance A, Then writes the data to a
Table in Server Instance B.  Anyone, have an idea how to do this?
Timothy Juarez

One of our source files has duplicate records  which generate a primary key
constraint violation during the insert. We tried performing a lookup as part
of the transformation, specifying the same connection as the destination.
If the primary key exists in the table prior to the ...

Hi to everybody!
I'm doing a XML Bulk Load of multiple XML files and given that there
are a lot of them, it must fully be automatic. However some of these
files have not been validated and contain errors that stop executing

I was using dts to try to copy a single table (using the copy objects
process) from one SQL DB to another and got this error:
[Microsoft][ODBC SQL Server Driver][SQL Server]EXECUTE permission denied on
object 'sp_grantdbaccess', database 'master', owner 'dbo'

       I used DTS to import data from xls file and i choose Microsoft Excel
97 - 2000 as connection, import xls data to server 2003 database.
       The problem is that all data from xls would consider as numeric when
i doing transformtions to sql server.  so if any letter in ...

I am setting up a DTS packet that looks at a view on one SQL Server
instance and uses a query to insert data, in a table, on another SQL
server instance.  Anyone, know of a way to do this?
Thanks

I want to copy a couple of databases from an SQLServer7 installation
running on an NT4 server to SQLServer2K Developer Edition running on a
WinXP Pro workstation. I'm trying to do this with the "Copy Database
Wizard" but I can't figure out how to tell it where the source

I am really hoping someone will be able to help me with this one. I
want to manually enter a command in a SQL Job within SQL Server which
will run a DTS Package with parameters.
The reason is that my users are able to create scheduled jobs from a

I developed a DTS package some time ago and the user reported that the
package wasn't working anymore. The DTS uses 2 stored procedures
separately to do inserts on a particular table, and when I tried to
open that table to read it ('open table' in Enterprise Manager (this

Within a Dynamic Properties Task, I'm trying to set a Global Variable to the
system date using the query: Select GetDate(). This should work, but it's
not. I can set a variable using a query that selects a date from a table, but
not using GetDate.

I have designed a fairly complex multi-step DTS package. I need to
allow user who don't have a full SQL Server application to run the DTS
package.
While I know how to include the dependent DTS dlls as part of my

I have a simple package created with the Import Wizard that reads rows from
a text file to an sql table. The table has a primary key and the text is not
supposed to have duplicate records, but of course it does.
How can I tell DTS to skip duplicates instead of aborting rolling back ...

i am unable to download the files from sun server using dts package. i
have given user name and password for the root directory in it. what can
be the cause? is the sun server are more secure then the windows server.
if yes then how can i download and upload text file in the sun ...

This is with respect to the error code that DTS generates on error. I have a
DTS packages wherein i've given logging option as log into SQL Server. As a
result all logs can be obtained from sysdtssteplog. But on failure the Error
code depicted is a large negative integer. Is ...

I have an Access procedure that creates 5 .txt files for a DTS package to
import into a SQL Database.  I occasionally get this follow failure.  The
text file for Task 3 is sometimes 0 kb and I wonder if that causes the
failure; however, it seems that Task 5 is the culprit.  ...