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...

Here is another thread that discusses the topic with additional worthwhile responses to those already made on this thread:

Pros and Cons - Table with loads of uniqe columns VS Row...

Your comment about filtering using the security metadata available for the logged in user (e.g. by using ORIGINAL_LOGIN() or SUSER_SID()) is where I would go with it.

See the section...