Would We know how What is done?

I might be missing something, but what question are you asking specifically.

are you asking about locking?

What are you trying to do within your loop?

are you trying to update all the rows one at a time?

one specific row?

Please take your sample data and show us what...

I'd use identity column as G noted.

But you also must keep in mind that all triggers MUST be written to accept more than 1 row at a time.

Your trigger will...

sqldts80.hlp, That is sql2000 DTS.

Is there any way you can get the vb guys to save the VBS output file, instead of executing, then try to import to DTS and...

Try @Balance / 100.0000

The error is happening here

while (select count(field1) from test)

While requires Boolean expression

So is it

while (select count(field1) from test) > 0

Can you please explain your situation better.

what do you mean top 10? The first 10 records in the table,

The top 10 highest quantity? How do you define this?

Please post DDL...

It goes back to knowing your data types and how much space each "Column" takes.

Char(100) is 100 Bytes no matter how many characters you put in the field

But a varchar(1000)...

The problem you face is GIGO

Garbage In, Garbage Out.

Although not always under your control, the cleanliness of the data should be part of the front end.

You have to evaluate whether...

Sure its possible.

Nearly anything is possible.

But not as straightforward as a simple query.

What are you looking for.

If you are using a Foreach Loop Container then the package should not fail if there are no files.

I just tested it to be sure.

What Is the actual error you...

If it is just the t-sql saved in a file you can use BCP to run the contents of the file.

http://www.databasejournal.com/features/mssql/article.php/3391761/Utilize-BCP-with-SQL-Server-2000.htm

OR

you can Create a Sql Agent job, and for...

Without information on specific problems you are having here are a few links that may help.

http://www.sql-server-performance.com/articles/dba/package_configuration_2005_p1.aspx

http://vyaskn.tripod.com/sql_server_2005_making_ssis_packages_portable.htm

I'm pretty sure you only need 1 with statement.

Take out the others.

Take a gander at this link

http://www.ssistalk.com/2007/03/30/ssis-some-random-tidbits/

(DT_WSTR,4)YEAR(GETDATE())

RIGHT(”00? + (DT_WSTR,2)MONTH(getdate()),2)

RIGHT(”00? + (DT_WSTR,2)DAY(getdate()),2)