You can write your own script to delete files older than a certain age, or you can create a maintenance plan with a Maintenance Cleanup Task. I think I'd...

Is there anything in the errorlog at the same time as this error?

John

I think the MERGE statement may work for you here. Have you tried that?

John

That's how we do it....

CELKO (12/28/2012)

---

Here is atrick weith a calendar table.

CREATE TABLE Calendar

(cal_date DATE NOT NULL PRIMARY KEY,

julian_business_nbr INTEGER NOT NULL,

...);

INSERT INTO Calendar

VALUES ('2007-04-05', 42),

('2007-04-06',...

wannalearn (12/28/2012)

---

Thanks Satish! I am not sure if we can use SSIS package at this time. I am trying to understand the process in details . Will come back for...

Looks like the conversion error is aborting the batch before the error handling is reached. Have you tried TRY...CATCH instead?

John

What version of Visual Studio are you using, and what is the version of dtexec.exe?

John

Can you open the package in Visual Studio or in the Package Execution Utility?

John

MSDE is a SQL Server 2000 product, isn't it? Does it not come with the delete file xp? If not, you could write your own script in C#,...

Phil Parkin (12/21/2012)

---

Possibly not relevant here, but if the 'COLS' column is indexed, a better option would be

where cols like 'NA%'

As...

Yes, paste the code into notepad, edit it so that it's right for your environment, and save it as a .bat or .cmd file. Make sure the path to...

I would guess that you can't start a job remotely via a linked server. You could try using Powershell or SSIS instead. Or you could set up some...

Use a CASE expression in your SUM statement, something like this:

...

SUM(CASE WHEN Year = 2010 THEN Amount ELSE 0 END) AS Total2010,

SUM(CASE WHEN Year = 2011 THEN Amount ELSE 0...

In your attempt yesterday, you aliased your derived table with the name of table that already exists, which is confusing for me at least, if not for SQL Server. ...