Maybe you can get the developers to do the following:

1. Create the table in EM.

2. Create a script of the table (right click on table, all tasks, generate sql script.

3....

Thanks! That worked!

Not quite what I had in mind. I meant that a third dataset should do calculations. Maybe your third dataset is based on a UNION query or a...

I think you should create a third dataset that does the calculations for you in the query.  Base the third matrix on that dataset.

Kathi

Are you asking how to get the passwords back?  If moving to another server, it is probably different anyway.

My rule #2 is don't use sa.  I usually use Windows authentication...

It backs up all 4, one at a time, then deletes files.  If you are short on space, you can create a separate maintenance plan for each database or look into...

You can also use LIKE:

Select * from myTable where myTextField like "*red*"

Or in SQL Server

Select * from myTable where

myTextField like '%red%'

You'll have to write some code.  Create a button on the form and change the lable to "Refresh".  Add code to the click event

The code (not debugged) looks like this:

Dim ID...

Thanks!  That was what I needed to know.  The totals and subtotals were always picking up the formatting of the data cell -- that is what I meant by "the...

If you mean to hide/display data, you do that by changing the Visibility properties of the row or textbox.  For instance, you may want to hide the report details and...

I found the solution -- maybe it will help someone else.

Even though I new better, I must have tried to install the service pack via Terminal Services. I have...

Thanks for your replies. I actually found a logic error in the package that was causing my problem.

Getting rid of the "go" and adding the "exec" worked.

Thanks for your help!

Kathi

I finally found a logic error with the package. What is odd is that it actually ran correctly when run manually.

There are 4 independent multi-step processes running....

You will see this behavior if you use the wizard to import data (All Tasks->Import Data).

Use DTS Designer by going to DTS Services -> New Package. ...