You are welcome.

CEWII

I just don't trust file dates.. Call me paraoid, I have gotten burned too many times..

CEWII

I think you need to go deep than looks..

Same worksheet names?

Same column formatting?

Are the files the same size..

CEWII

I would ask that you compare the excel files generated by each process. How are they different. Given the information you have provided this is about all I...

Have you considered setting max error count at some value other than one, perhaps add one per destination maybe.. Don't know if this will do what you are asking...

I'm not a big fan of either..

So I build scripts to do it for me..

I use a script similar to this:

deploy-ssis.cmd

@ECHO OFF

SET /P ServerName=What server without instance name:

SET /P...

That is typically how I set it up so that a dataflow is all good or nothing goes in..

CEWII

Sorry, that is usually the question.. I don't know of a way to do what you are asking.. Sounds great though.

CEWII

I would venture a guess that the source has it defined with a length of 255, you might right click on it and choose the Advanced Editor.. I think...

Using the MS delivered tools the mappings are determined at design time and are not modifiable at run time..

There is a tool by CozyRoc that might be able to do...

starterm (4/21/2010)

---

Thanks for the reply, can you please explain that polled process how to do for file watching . I should check the folder if there are any new files...

This is from BOL:

The SMTP connection manager supports only anonymous authentication and Windows authentication. It does not support basic authentication.

This means that that what you want to do cannot be...

I'm sure it is BUT you have to have a hotmail account yourself to be the FROM or at least to be able to authenticate with. The Send Mail...

bagofbirds-767347 (4/21/2010)

---

Lowell - that worked man. awesome!! Thanks so much!

The rest of you - to answer the main question: i do have a handfull of databases that are...

I have reviewed the posted link and don't think it is the same..

I think your local SMTP server requires authentication, which the Send Mail task can't give unless it is...