Thanks for showing how one could do this programatically.

An alternative approach that I find useful is here: http://www.sqldts.com/default.aspx?204

Cheers.

dj

DTS doesn't seem able to use parameters ('?') and SQL local variables in the same batch.  I tried something very much like your suggestion; when I tried using parameters to...

One would think that would work, wouldn't one?

Unfortunately, DTS doesn't see things that way.  I tried this:

INSERT INTO tblDataload_Price_Load_Log (Division_Code, Price_Level )

VALUES (?, ?)

SELECT (@@IDENTITY) As LoadID

I can see...

Training, yes.  Travel, no.

Sadly, travel (lodging, food, etc) can easily cost more than the actual training.

Bit of a conundrum. Got an answer?

Gila Monster:

I am in the same position (I even have both study guides too!) and I'm still trying to decide myself.

I have my MCSD (not .Net) as I started as a...

Thanks -

I thought of that, but this can only be applied to one table at a given time.

I may have to fall back to this approach, but I was...

Ok, I got it.

My connect string had the SQL Server name, but not the host server name. In my case they are the same (probably not a good idea)

so...

The Authentication was set to 'Windows only', the startup service account set to 'System account', which is how I installed SS2K (Developer Edition).

I tried changing the Authentication mode to SQL...

Thanks for responding -

I copied the connect string from another (working) DTS pkg on a different machine/network. Here's the connect string:

strConnect = "Provider=sqloledb;Data Source=myserver;Initial Catalog=mydatabase;User Id=sa;Password=;"

When...