Try this

declare @startDate as datetime

Declare @enddate as datetime

declare @interval as int

declare @ACounterVariable as int

declare @calc as int

set @StartDate = Getdate() - 10

Set @enddate = getdate()

Set @ACounterVariable = 0

Select @interval =...

Check the connections within the dts package - a lot of times they are "hard coded" to a specific server. Also check the job step - /S "(local)" indicate the...

We do simlar processes - download an access db to our server using ftp and import the access db into SQL - without any problems. This could work for you,...

Use DBCC TRACEON (3226,-1) for global scope. I set it on my dev server and it's great! I'm planning on setting it in production next week:cool:

We setup a SQL Proxy Account to get this to work. try http://support.microsoft.com/kb/890775 or http://support.microsoft.com/kb/833559. hth

I use the following to run a weekly job on Monday from within a daily job. I only want the weekly job to run if the 1st step of the...

Oh well... Looks like the scoring key is wrong again. Glad they don't do exam testing:hehe:

Why not import the data to a staging table, then load what doesn't exist (no primary key violation). If there are duplicates, load those to a separate table, and finally...

Yes DTS can handle this and DTS will run in SQL 2005, although it would need to be converted to SSIS in order to be modified under 2005. Having said...

The correct answer is ROW_NUMBER but the explanation is RANK()? Methinks someone made a typo.

Try adding the users to the TargetServersRole role in the MSDB database.

Does the job use Excel? We've run into this problem - especially with Excel. The problem is caused by the job trying to run something (Excel, vb, etc...) without the...

We have several of these processes running, using dts packages. The first step is an execute sql task which uses xp_cmdshell to call a batch file which controls the...

Current Role: SQL Server DBA/Senior Systems Analyst/Developer (jack of all trades)

Time at current job: 20+ years

Aspirations: Telecommute from my villa in the Italians Alps that I purchase with my powerball...

I have a similar problem on occasion with rogue processes. However, once I kill them, the process shows Killed/Rollback in the status. There are times when I have to...