Agreed, For SQL Server a general rule that I use anything less than 10 characters should be char. Of course it always "Depends"

when calculating size of a row.

Maximum...

Yeah, its all about the way the dts package binds the steps to the object, its kind of a pain.

Perhaps the data in the new database does not "Join" properly. The id's can be different between databases.

When all else fails Cheat.

Create a dts package manually that does what you want.

Then do a package --> SaveAs --> Visual Basic File.

Open that file in visual studio, and it...

It is better 2 have 2 different procs/methods 1 for insert 1 for delete. This makes your code more reusable, It will allow you to insert or update in other...

From what I have seen Timeout is a connection setting.

You have to set the connection string in the application to have a longer timeout.

The reality of it is the sql...

Well, if you did not sucessfully detach the database, prior to copy/moving /attaching to a different server youre gonna have some issues.

Basically the database was not Properly detached.

Search google I...

I have not forgotten What the R in RDBMS means,

Sometimes its hard to see the forest cuz of all these damn trees.

I have never seen this, it does not appear to be a sql or connection error. Possibly an application error.

What app are you using?

I do not believe that sql records this information as a default.

You can set up a profiler trace, and log results to a file/Table.

There are know issues w/ this, and...

In reality its a boleean

so bit is fine just have to decide

0 = Male, 1 = Female

or 1 = Male, 0 = Female

How bout

Char(1)

M (Male)

F (Female)

U (Unknown)

B (Both)

This example basically displays your problem Using AdventureWorks2000

Boils down to your going to have to eliminate the repeating amounts in your dataset.

If you run the following query in QA

select...

You can either create a backup file for the vendor to restore, or you can detach the database, make a copy of the .mdf, and reattach the original database. Of...

as remi is stating, when your regionid string looks like this

'''627CCF61-56D4-47D8-9E7C-03019E3E4DE1'',''9F2F3693-4CCA-416A-9E39-034EDB66822C'',''4A6BD792-7472-4AC8-B373-29B29AED1BEE'',''191AC990-7668-481D-A34F-4298CC954738'',''A11CFDBA-A28B-4D88-9816-88FEA32631D5'',''699F669D-7F77-4421-ADFE-AE163F025B35'',''5B7D51D8-BAC8-4287-806F-B3F689C9AFDF'',''C02F04B6-0DE8-4E2C-90D8-C10919F75463'',''F6C0F46A-3785-4BB1-8960-D0AABF119785'',''3F78395C-8229-4B2B-88A5-D6B91F7B890F'',''004EC00F-D666-451E-AE53-E612B1926B33'',''843D1B88-4755-40BE-99B5-FAD28C4E7C85'',''02083E9E-08E9-4133-9111-FE7424016A2B'''

it works okay.

these are all apostrophe's (') not Quotes(").

You should write an expression using an inline IF

But I don't understand what you mean by where part_No.Value is Distinct.

Not sure exactly what you need to do, but I have...