Have you tried to execute that query from within SQL?

There is no need to loop thru anything. SQL Server is a "set based" dataase. It works on sets of data....

That is actually pretty simple. Think about storing People and numerous phone numbers for a single person. So that tells you that you will need at least three tables. The...

Have you verified that SSIS is installed and running on the box that you are attempting to copy the Package too?

Andrew SQLDBA

Mine are on different drives. I actually do not have a Drive C. Well I do, but it is only 7Mb. I had to have that for the System Drive...

Sure, you should never mix the OS and the database on the same spindle. And all databases should be on a separate spindle. If you are developing at home, then...

It is not magic, you must use some criteria in the WHERE clause.

Will your keyboard not type the word "WHERE", or what?

Andrew SQLDBA

Jason

Looks like your get what you pay for using Compuke Edition of SQL and SBS of Windows Server.

Andrew SQLDBA

What were the results on the Development boxes? Did this happen to them when you installed it there? It could be the product is out scanning everything, and that is...

oops

I forgot to include the code:

SELECT UPPER(LEFT(<ColumnName>, 1)) + LOWER(RIGHT(<ColumnName>,LEN(<ColumnName>)-1))

Andrew SQLDBA

How many rows in how many columns in how many tables are you talking about?

If only a few rows in a few columns, I would UPDATE everything to all lower...

There is no recipe step-by-step guide. You need to look at the business, and the business rules and apply those rules to the database design. Hire an excellent database architect...

Of course, proper database design will allow proper MDM, known as Normalization. Using constraints and the tools available in SQL Server to properly design the database. None of my transactional...

You should never run the Service as a human account, create a non-human account for all Service accounts.

Are you stating that you cannot log into SQL? Or that SQL is...

If you are not sure, always create a copy of the table or the object first. Always easier to rename that to recreate.

Andrew SQLDBA

Have you actually built the package? Did you move the package on to an Integration Server? If so, check that box and a directory for the same location. I bet...