You can do metadata transformations from Excel to MS-SQL, but it requires the building the Package the MS Visual Studio BIDS environment.

Personally I would not recommend doing it this way,...

I don't think you can change the ODBC setting to read only. It is what it is, just a connection into the database.

You should add the users to a...

This has got to be a permissions issue. Add a step to the code to pump out an email reporting the logged in user. (or write it to a table,...

That's it.

The SNAPSHOT isolation is new and I have not personally used it yet. A better solution may be to set the SELECT statement to a 'READ UNCOMMITED' isolation...

Have you changed the isolation level?

If you have SNAPSHOT isolation enabled, maybe set the UPDATE transaction to SNAPSHOT isolation?

I'm assuming that both transactions work when they are run...

Have you looked at Computed Columns (Persisted and probably Deterministic)?

I would advise a couple of things.

1. Keep looking; the job hunt for a good position can take months or even years. Keep up the hope, if your landing...

Double check the Operators E-mail name; it has to be a fully qualified email address, ie: jdoe@somecompany.com.

Expand - SQL Server Agent - Operators - on the General tab...

So what happens to the target Time field in the SQL database after the Bulk Copy?

DECLARE @varTime AS Time(0)

Also, it shouldn't matter, but why not pull directy...

Gila -

Thanks for helping me clear this up, and I apologize for the ranting. I'm going to install C# Express and see where that gets me.

I installed SQL Server 2008 and BIDS.

When I select New – Project I am presented with a New Project Box. On the left of the box is Project Types...

I think it's mandatory to invest in your career. As a consultant I don't have the privilege of paid classes.

The old school way was to purchase a 50$ 650...

Agreed,

I have never been able to keep up with Microsoft; usually a better idea to leapfrog product releases. SQL 2008 should be your SP3.

thx,

This should keep the DTS running on success.

Main = DTSStepScriptResult_ExecuteTask

As for keeping the DTS running on failure, this I have not been able to accomplish. It just stops dead generating...

I agree that the new SSIS is lacking a good documentation tool. I can always tell what a package is doing; but I can't always tell why. Nor can I...