Execute Process Task

Use a return code.

Zero typically means 'no error' and non-zero typically means 'problem occurred'.

-- proc 1:

ALTER PROC [dbo].[nz_test1]

AS

BEGIN TRY

EXEC sp_configure

...

This is a validation message based on SSIS not knowing if the result of an Expression in your Package...

And are you seeing history now?

Rich James (8/24/2012)

---

OPC.Three..

The difference I see between your setup and mine from this is that I'm using a Domain account, rather than a local machine account.

Do you get the same...

Can you please check again. Yuor query is not checking for any of the MAX types. Try this one instead:

SELECT t.name AS ,

...

tonyclifton77 (8/24/2012)

---

I now understand why the error occurs. I don't have the for-each loop set up correctly to process multiple files at once. It won't move to the next file...

From Best Practice recommendations for SQL...

Excellent, you're welcome!

Which comment? I made many.

You could easily test it out using a test database and Profiler, but why risk it?

USE DatabaseName;

GO

EXEC sys.sp_rename

@objname = N'SchemaName.TableName.ExistingPrimaryKeyName',

@newname =...

The obligatory response: are you sure you want to shrink your data file? Stop Shrinking Your Database Files. Seriously. Now. by Brent Ozar[/url]

Now that we have that out of the...

It might be a UI or server bug.

What is the build # of the server?

SELECT SERVERPROPERTY('ProductVersion');

What is the build # of your copy of SSMS?

What does this...

I forgot most of my DTS skills but since you have not received any responses I'll make a general suggestion:

Instead of loading the data directly into your target table, load...

If the backup succeeds and is valid (i.e. can be successfully restored somewhere), then SQL Server later crashes then your backup will not be affected.

That said, it is a...