Looks like it's to do with the way the command string is being built. Perphaps you could put a line in your code to print the command string before...

Phil Parkin (1/3/2013)

---

Integration Services does not sound like the right tool for the job - it's not an always-on, data-drip-feed type solution. Have you considered CDC or replication instead?

Rather than...

Ram

Use the Import/Export wizard. You have the option to run it immediately or save it as an SSIS package.

John

I think you had it right in your previous post. But make sure you test it before it goes anywhere near live.

John

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...