Frank,

Thanks for the input. I actually think I have it figured out. I am doing something similar to what you are suggesting. In my destination system I...

It does add some size...

Brandie,

I don't see a way to sort on a derived column as the derived column task does not allow you to set the IsSorted property or the Sort Keys. ...

Based on the reading I have done that seems like it would be correct. I wouldn't guarantee my accuracy though. Have you compared it to the results from...

It sounds like MS is showing the size of the non-leaf levels of the index which should be a relatively low number according to Kalen Delaney in Inside Sql Server...

I can almost guarantee the Delete without a where caluse will take a table lock. What is the business reason for the purging of the table? Are the...

If you change the error output to redirect row and place the attached script component in the path you can then output the error with the error description and the...

Not all countries have 10 character phone numbers. Some are more, some are less.

What is the error you are getting? It may have to do with naming convention. Using SQL "." notation versus IBM notation.

That error means that the DB2 timestamp column date is either before 1900/01/01 or after 2076/06/06. Are you running the linked server query against the same DB2 data? ...

Check out "EXECUTE AS" in Books on Line.

sys.databases and sys.sysdatabases are both views in SQL 2005. The base tables are hidden. Not sure what you need to do.

What is the length of the parameter in the stored procedure?

What kind of problems is the software experiencing? Having multiple updates taking place simultaneously should not cause any problems with the trigger as it should handle that. What...

Is there Trust setup between the domains? If so grant your SQL Server Agent account write rights on the share on the other server.

BTW-it is not a...