I have issues concerning calculated cell's performance.
If I create 12 calculated cells in a DTS, the retrieve takes 7 minutes
When I delete those 12 calculated cells and I recreate 12 calculated cells
with the calculated cells creation wizard on the same cube with the same MDX,

I have a series of excel file with several worksheets in each file. The
data that I need to import starts on row 8. Is there a way to get the
DTS to ignore the first 7 rows of data as they are just header data.
Also how can I pull the info from each workbook?

A while back we found a Stored procedure on the net from MS that allowed you
to send mail.
We used this SP in a few of our DTS jobs. We have a Table that we enter in
all of the emails that we want the system to generate for us. Then loop

We are trying to use Meta Data Services as a way to help document our DTS
packages.  We can save the DTS as a Meta Data Services Package, and we can
see it in the Meta Data Services group (under DTS).
However, when we try to open the 'Meta Data' group (under DTS), we get the

All,
Is there any relief from what happens when DTSing an Excel spreadsheet into
SQL 2000 and the zip + 4 values import as NULL?
Thanks.

Is it possible to skip a given number of records in the source dataset,
not just one at a time?
We are trying to replicate some old data in dbf tables.  The only
changes made to these tables from the source application are the

I have created a DTS as part of my month end process to import 40 different
csv files from our various sales offices.
Each file contains the account no and purchase information for the entire
month. eg

I have a dts package (package A) which I can execute from SQL Enterprise
Manager. I then created another dts package (package B) that runs
package A. But, package B hangs when I try to execute it. Even if I hit
the Cancel button on the dts status window it never cancels and I have

SqlPros,
When debugging a dts package I get thrown into Microsoft Visual
InterDev 6.0 as part of the Visual Studio 6.  It throws up a line
indicating where I'm screwing up.  However, when I close the debugger I

I need to develop a program to do large data ETL, however, the raw data,
which is in Access mdb file, need to be checked and modified against the
existed data in the database.
- Any better way than loading the raw data into SQL Server?

Using Dynamic Properties Task, how do I change db name at runtime using
global variable? My DTS pkg has two connections. All I am trying is to
change the db name at run time for a target connection. So, I set up a
global variable "gvDB" on "Catalog" (is this correct?) on the target

hi
i have a text file with firstrow
03 ex 12345678912345678912xxxxx9999988888
fifth  row

I have a requirement to select records from a sql table that has email
addreses in each record and send a formatted email to each person. There
needs to be a separate salutation in the body for each email person, so each
email body will be different for each person. Is there an ...

I'm working on converting some of my SQL 2000 DTS packages to SSIS packages.
I'm looking for some example packages to help me figure out some things.
Thanks,
 Scott<-

Somebody to executed two DTS in parallel?
If the answer is affirmative it can say to me like, plisssss?
Thanks.