Pam

This used to be done by global variables in 2000.  Now you have to use expressions in SQL 2005.  First you declare your user defined variables and then use the...

Salary range is 70K - 84K

Agree with Steven.  Use a static ADO connection and that will prevent someone from writing to your SQL database during that session.  You can further use the security in SQL...

I too had this problem but overcame it using the sequence container.  I transferred the master tables first and then the child tables.  However, I am not sure if the...

Let me know if you need any additional help as I have created many packages utilizing global variables.

M,

Store the values as either session variables in ASP or state variables in ASP.NET.  (I'm assuming you are using ASP).  Once the 5th page is submitted then update your tables...

Noel

I found sp_start_job, however, it didn't mention how to pass global variables into the procedure within the job.  Do you have any ideas on that?

Thanks

Marvin

Noel

Never heard of sp_start_job. But I will give that a try.  Thanks

Marvin

Hi.  I think the select into is the best option.  If the update fails I'd then truncate the original table and re-populate it with the data from the select into...

I was faced with this problem and solved it by using global variables in the DTS package and calling the package with a stored proc that passed those variables in...

Are the servers in the same domain?  It is a permission problem.  Make sure you have the port open between your website which is usually in the DMZ and your...

Is there an option to telecommute? 

We have developers do it as well.  However, I must emphasize that they should be taught how to do it well.  The sooner you get them up to speed the...

I have been doing it for the past two years using the method described by Phil.  It's fast and very effecient.  Just remember to either truncate the loader table first...

Keith

I'm a certified Oracle DBA as well, that has been working in SQL Server for the past three years.  It took a couple of months to get up to speed...