I've created dts that sends data from one server to another
I got an error: BACKUP LOG permission denied in database 'destination
database'
Whad is wrong?

I need to load various excel file into SQL server. For every excel file
i have mapping table mapping excel column to SQL column. I am currently
dynamically generating insert statement from this mapping table and
then use to load records into sql server. For taking data from excel i

Good day,
I hope someone can help.
I am using the FTP task from SQL Server 2000 DTS.
I have an application in place that every day creates a log file with the

Hello, I want to create a DTS, it must import multiple csv files from the
same Folder into two different tables.  The  files  are "LDP_" + 3 letter
code( like LDP_CCC,LDP_XXX) and "ADP_" +3 letter code (Like ADP_AKC,ADP_MEM)
. I know how to load it to the database, I am using ...

I want to transfer some views from one server to another.
But I want the views to be materialized into tables on the
destination server. The views are different with different
structures (different number of columns, name...etc). I

I have a DTS job which copies 20 tables from a Sybase database to Microsoft
SQL Server database.
The sybase connectivity is a ODBC Connection, and SQL server native
connection.

I would like to ask what is the syntax error in this:
sql = "UPDATE Weeks SET WeekStart = "& ww &"" & vbCrLf & _
    "FROM CurrentWeek WHERE Weeks.WkNo = CurrentWeek.Wkno + 1"
ww is a global variable

I have a lot of packages executed from 1 package.
when I execute the main package interactively, my 2 processors are used at
100%
(execution directly from the DTS designer)

I build a fancy DTS package to migrate data from a source database S
to a destination database D.  But, I can't touch D right now, so I
actually build the package to use destination X.  Everything works.
Now, I try to use a dynamic connection to set the destination initial

I am looking for some advice/ or examples on the best approach for Importing
a text file to a SQL Server DB using DTS and a GlobalVariable for the
pathName.
I plan on executing this DTSPackage from a VB.NET application.

We had some serious server problems and ultimately had to reinstall
SQL Server 2000 on a Windows 2000 Server box.
Initially, we installed SQL server under a domain account named
srmsql. Under this installation we created everything, (DBs tables,

I thought I knew a lot about DTS, but I realize what a novice I am
after reading this news group.
I am not new to DTS, but new to Global Variables.  I am trying to loop
through a global variable rowset and update data in a table.

Is it possible to ftp  to a remote UNIX site and execute a shell script at
that site?

I'm new to DTS so I appreciate any help.  So far I haven't been able to
figure this out.
I want to left join one table (TableA) to 3 other tables (TablesB, C, D) .
(I need all the data in Table A returned).

I want to use a (Parent) package to call on several other (Child) packages. I
need to return from these Child packages specific Global Variable values in
order to determine what additional Child packages I need to call on.
In addition to this I need to pass some Parent Global ...