So you have two SSIS packages. One does little more than write the filename with path into a table and the other does the real work.

Might I ask a...

It may well be a F-E-L but that is ok, it just seems that it is more complex than need be..

CEWII

Agreed. But I will say that the Database mail task in SSIS is EASY to use and requires basically no knowledge other than the SMTP server address..

CEWII

This seems a little convoluted to me.. Based on what you showed you seem to be calling the SSIS package once for each XLS file. Is that right?

If...

Why don't you go over the whole process, like what to you do with that resultset, give us some detail at a higher level and not just the immediate problem....

You may be able to do it in one..

Why don't you lay out the process with some detail and we can see.

CEWII

Welsh Corgi (2/17/2010)

---

I'm not a fan of SQL Mail either and I never worked anywhere where we were allowed to use it.

SMTP was the standard and I...

I'm sorry, but that isn't enough information.

What was the step detail from the step that failed. What you have provided is the job detail.

If you can provide the step...

If you call xp_cmdshell like

DECLARE @retval int

DECLARE @cmd varchar(8000)

SET @cmd = 'SET' -- Good command

EXEC @retval = master.dbo.xp_cmdshell @cmd

SELECT @retval

Should return 0

DECLARE @retval int

DECLARE @cmd varchar(8000)

...

In a CMD file I often use %1 to handle that.. Let me show you:

ExecDT.cmd contents:

dtexec /SQL "\LoadIt_Package" /SERVER MyTestServer /MAXCONCURRENT " -1 " /SET \Package.Variables[VarFileName].Value;"%1" /CHECKPOINTING OFF /REPORTING...

It shouldn't hold on those pages. I am not a storage guru, but my experience shows this to be true.

This is something you could actually test fairly easily.

CEWII

You could look at:

SQL Server 2008 Compliance Guide

http://www.microsoft.com/downloads/details.aspx?FamilyId=6E1021DD-65B9-41C2-8385-438028F5ACC2

CEWII

While you can use SQL Mail in SQL 2005 and 2008 I REALLY must advise against it. The major issues with SQL Mail is the requirement for it to...

It was not obvious the first few times I worked with it, but in retrospect if I had been looking, it would have made complete sense.. Glad things worked...

GSquared (2/17/2010)

---

Ideally, you should have something that...