Most likely a permissions issue with the account used to start your SQL Agent service. When you write out your XLS files, are they dumped to the same directory?

It sounds like you have the rowcount configured properly. Are there any other transforms or tasks that interact with this variable? Perhaps it's being modified elsewhere?

Do you see...

What you'll need to do is to skip the conditional split altogether; you'll use the Script component to separate the record types.

First, create your Script Component as a "Source". ...

Krish,

I'm finishing up an article for publication on this site to demonstrate an easy way to handle this. I'll send you a preview copy later tonight or tomorrow which...

The conditional split alone won't get you there. The number and types of columns are different within the file.

If you've got a source file with dissimilar structure from one line of data to the next, you're most likely going to have to use a Script Component to address...

Amar,

First, you've got a lot of questions in a single post. For best results in the forums, you should try to separate your queries so that a single post...

Too early for midterms... must be an early semester quiz.

Dan, I didn't realize that case sensitivity only applies in full cache mode. That may be the source of the problem described by the OP.

Thanks for pointing out that...

Steve,

Part of the problem is that you have got your error precedence constraints set to Logical And, which means that both the data flow and the e-mail task must fail...

Janie,

You can add your users to the sysadmin role (or another role, if desired) in SQL Server security even if they do not have administrative rights on the machine. ...

Kurt,

Generally, the only way you would get different results in your lookups is due to changing data, either in the reference tables or in the data in the pipeline. ...

If you want to delete data from the table before loading it, you will have to do that explicitly with an Execute SQL task in the Control Flow of your...

Steve, can you give some more information about your package. How are you determining success or failure - are you checking a row count?

If I read your post correctly, you're entering SQL code directly into the Value definition of your variable, which you can't do in SSIS. You can, however, modify your...