Just back to my room after a long day at the PASS pre-conference. The pre-conference seminar I attended covered many of the new features of SQL 2005. It was presented...

I had to refresh the page to see the story or Steve fixed the problem.

No problem. You might try to post in the data warehousing/DTS forum.

This is an SSIS thing. I kind of assumed that you were working in SSIS since this particular forum is for SQL 2005.

There is a setting called ForceExecutionResult that you can set so that the task always completes successfully.

Try this:

delete M

from Milestones M

where not exists (select *

                  from GeneralInfo join Imports

                  on GeneralInfo.XNumber = Imports.XNumber

                  where GeneralInfo.YNumber = M.YNumber)

Thanks for the information.

I talked with a developer at MS about this. He said that the parameters for each provider is different and right now, there is no source listing the differences. There...

When you run the DTS package, it runs with your account, rights and drive mappings. When it runs a job it runs as whatever account is used to start up SQL...

You'll have to restore the db somewhere else and DTS the table.

Better to avoid dynamic SQL if possible!

What technology is used for the report?  If it is a custom built report, part of your web application, just change the connection string each time the report runs. 

Try 127.0.0.1 or try "(local)" instead of the IP.

Try something like this:

dim thisDate

thisDate = now()

dim formattedDate

formattedDate = datePart("d",ThisDate) & "/" & datePart("m",ThisDate)

formattedDate = formattedDate & "/" & datePart("yyyy",ThisDate)

Have you worked with any technology to do this in school? If so, maybe the best way is the way that you know. Otherwise, ASP.NET using either C# or VB.NET...