I think I understand what you are looking for..

Right before you are ready to write to the database use a lookup transform in the dataflow, use it to look up...

I can't answer all of them but:

Can anyone tell me the when following availability solutions were introduced in sql server?

1. Clustering

- I never saw it in 6.0 and actually did...

Try/catch could worl, but a lot depends on the type of failure, there are types that even a try/catch can't capture because they kill the connection.

CEWII

I think Microsoft offers an Authentication application block that I would look at..

CEWII

The other thing that comes to mind is that there is a certain inbuilt bias in technical interviews. I could answer a question technically right, but if it doesn't...

If you are starting fresh, you could just copy the package and rename it and then take out anything you don't need..

CEWII

You might be able to do a RUN AS when you start SSMS and start it as that user, but you can't fool the tools into believing you are that...

My first thought is you have something blocking this process, while this is being held up check to see if there are any proocesses being blocked or blocking this. ...

You are welcome, this is called a SET based operation, you performed the operatio on a whole set instead RBAR (Row-by-agonizing-row)..

CEWII

I'm actually kind of appalled by the inability to answer these questions of basic developers. I'm especially surprised by the index type question, which by your context is clustered...

In 2005 64-bit.. Only if the directory that it is in is in the path.. I didn't think it did that..

CEWII

After you do the reindexes.

It say do a

DBCC SHRINKDATABASE

and if that didn't clean up the log file enough I'd do a

DBCC SHRINKFILE

CEWII

I kind of like the webservice idea with a sproc behind it.. It takes delivery out of your hands and makes it their responsibility to come get it..

CEWII

have two seperate issues here.

1. All domain users have access to the tables.. How? What role do they have? Are they all administrators? Has the everyone group...

UPDATE dbo.tablea SET Year = CONVERT( int, Year ) + 1

I am counting on a number of facts here, I converted it to an integer, it will convert it back...