One time my company got an virus for the email system, I did not know how it got it because we used Lotus notes as email, we had to shut...

Why don't you look it up on their web site? Again I think UK is the same as US, you need to find a company to sponsor you before...

If you want to work at US, you need to find a job first and the company agrees to sponsor you before you can apply for job permit. Actually...

Do you have any interview before? I am surprised that you put down your title as senior software engineer and it seems you never have any job interview experience.

Your boss will give information about the project usually including who is the user and the project requirement. I will not worry about it until I see the project...

When I design a data warehouse, what you explained we call it slowly change dimension.

When I create the table, there primary key is a surrogate key - usually identity field...

I live in Rochester, NY. I start looking for a job since August and I only had a couple interviews. There are a few contracting jobs. One...

Sorry I got the wrong web page. It was SQL Server 2005.

I think this web page will help you. One thing you need to define OUTPUT parameter...

The global variable is an input variable not output variable. When you call the DTS package, you put in the global variable as input.

In your case, you...

I read your question more carefully. If you want to get the result of stored procedure, you don't use global variable, you use output parameter of the execute SQL...

Sorry, it should be

EXEC master..xp_cmdshell 'DTSRun /S "ServerName" /E /N "PackageName" /W "0" '

I used window authentication in this.

EXEC master..xp_cmdshell 'DTSRun /S "ServerName" + /E /N "PackageName" /W "0" '

If you don't use window authentication, then you have to put in user...

Sorry I misunderstood your question the first time. After I saw your code, then I understood but I was confused with your code. Is the drive letter the...

How do you execute the DTS package from stored procedure? You need to pass the parameter using /A to update the DTS package global variable.

Do you have an example?