jghoshal - that option is available in 2000 but was not available in 7.0

To use it in 2000 you must be inside a package (design package option) and open the...

We had the same problem but we needed to know what statements in the sql tasks themselves were long running. We ended up creating a table to hold all...

It sounds like you would be wanting an identity column. (sample table below)

create table tbl_a (

gen_id int IDENTITY (1, 1) NOT NULL ,

field_x char (4) not...

We recently had a simular problem at my place of work. We loaded the 7.0 client onto our new XP boxes and discovered issues with running packages via the...

If you have a smallish number of rows (in total) in the table then just select distinct all columns into a new table, truncate the old table and then insert...