I have a batch job running under SQL Server Agent that reads info from a
table, uses an excel sheet as a template, and creates an output excel
spreadsheet, that gets then sent to users.
xp_sendmail @recipients='literaturerequests@mycompany.com',

My DTS package has, in order:
1. a Dynamic Properties task
2. an Execute SQL task
3. a Transform Data task (aka Data Pump task)

I am attemping to update a MS Access table from a SLQ Table using DTS. I have
created a connection for both the Access db and the Server db.
Both contain the table costcenters with these fields costcenternumber and
costcentername.

I want to provide the db_reader database role to some users. The problem is
that, on the same time, I don't want them to be able to export data (e.g. not
able to create and execute DTS Packages or run the DTS Wizard).
Is that possible?

I have windows2000 server
running sql server2000 sp4
with sqlmail installed, configured, and working.
Sql Server Agent is started using a dummy domain account with administrative

does any of you know which assembly do I have do add to my project in
order to have dataflow task components in my c# toolbox, so that I can
edit them in a new package?
Thanks,

Arghhh......the inconsistencies of Microsoft. We have to live with them
don't we?
I have an Excel file.
I created a package to import it into a SQL server database table. I run it

I used to redistribute SQL 2000 DTS package on servers who do not have SQL
SERVER installed as described in the following article:
http://www.sqldts.com/default.aspx?225
I need to run an SSIS package from a webserver and my question is what dlls

We have a huge database on SQL 2005 and there are hundreds of users having
the copy of this datbase on SQL 2000
We used to provide backup dump file for them to restore
Now with SQL 2005, I have read that we can not restore a dump from 2005 on

I need to import data from an XML file to SQL server 2000. Is there any way
of doing this through DTS without having to write code?
Thanks

how can i send a file with the FTP Task direct from the SQLserver 2000
R
Stefan

Firstly apologies for the obscure subject line.
The task I am try to achieve is to copy information from Database A on
Server 1 to Database B on Server 2.
I would like this to be a DTS task (so that Many tables can be updated

Given:
I'm using a DTS Package to import data into a table.  Each row from a text
file gets placed into a corresponding table.
What I need to do:

I have a database that captures real time production data that I'm trying to
keep lean 'n mean.  We don't want our analysts querying this db all day.
So, we've decided to have a second db that we will keep in sync with the
lean 'n mean production db, and the analysts can query ...

I have a large XML document (100Mg) that I want to process through a data
flow process.
Part of the process is to Sort the various relational tables created by the
XML Source - then merge join them.