I can drag and drop the Send Mail task in a dts package and use it to send
mail to a specific person and it works. The question is, how can I use it to
send multiple emails to various email addresses using a select from a table?
Anotherwords, how can I do a select from a table ...

I want to upload data into 5 dimensions in my Analysis Services
database. I do not want to update the dimensions during the cube
processing I want to build and process the dimensions seperately from
the cubes.

I have quite a strange DTS problem. I wrote a script to load data from
a Excel spreadsheet into a Access database. If I run the script
(doesn't matter if I run it from Enterprise Manager or with vb code),
it just skips some rows from the source file.

I built a custom component (con. mgr.) that uses some external dependencies
(dlls) and properly registered it with SSIS. When I open up BI studio, create
an IS project and bring up the Package designer (and do all the other
required stuff to make it actually visible in the ...

I have a WinForms client which needs to execute a DTS Package on SQl Server
2000. The Sql Server db is on a server. If I run the client on the server it
executes the package ok, however If I run the client from a remote PC, the
OnQueryCancel event gets fired before the execute ...

I would like to know How I can automate an DTS and How I can publish an Cube
with OWC 2003? or I need other tool for this issue?

I am using an Excel connection in my DTS package. After running the
package in DTS Designer, I tried to open the Excel file using the Excel
application. I get a message saying "Excel can't access <filename>".
Any ideas on what caused the error would be appreciated.

...than the domain assigned to the SQL Agent Service account. For example, we
have an account XYZ\SQLServiceAcct that is shown as the owner of the
particular SA job and is also the account running the Agent. It is reflected
in the message text related to several of the job steps, ...

How can I transfer DB diagrams and referential integrity relationships
between databases with the same structure. I copied dtproperties table
from one DB to another but it copies diagrams without foreign keys.

I am using SQL server 2005 (Ver:9.0.1116).
I am unable to find how to create a DTS package from Sql Server
Management Studio.
It is showing "DTS 2000 Packages" in the "Object Explorer" of the Sql

We have a database server (DWPROD) running Windows 2000 with SQL Server
2000(sp3) and mdac 2.7 sp1 refresh.  We are migrating to a new database
server (DWSQL) with Windows 2003, SLQ Server 2000 (sp3) and mdac 2.8.
I have been unable to open dts packages (either structured storage ...

I'm loading data from a flat file into an Sql Server table ... using "Flat
File Source" and "OleDb Destination" controls.
In between I'm using a number of derived column controls to add and
transform data from the flat file.

Can a DTS package be added to a server via the command line using OSQL?
Thanks in advance
John