I agree that keeping a record of the files that you've processed is best way to accommodate your requirements, but it doesn't have to as complex as the previous suggestion....

annam.dba (7/9/2014)

---

Hi Lempster,

Rowcount transformations i can used between source and destination. where can i mention user-defined variables and where can i refer those variables in Send Mail task. Please let...

You'll need to use Rowcount transformations in each dataflow to store the count of extracted/inserted rows in a number of user-defined variables. You can then reference those variables in your...

SQLRNNR (7/3/2014)

---

A lot of the point to relaying a story where a problem occurred and you fixed it is to see a) how you fixed it, b) your attitude (are...

Where do you get these nuggets of information from Gail? 🙂

The msdb.dbo.sysmaintplan_logdetail table is the one you want to look at then.

Regards

Lempster

Phil Parkin (7/3/2014)

---

I was thinking that this would be the process:

1) User uploads Excel file

2) Format of Excel file is validated

a) If fail, error feedback to user and return to...

True, but recommended best practice is to...

That's a funny story, but just to point out, the term is 'pidgin' English, not 'pigeon'!

Regards

Lempster

Although there are a number of tables in msdb relating to Maintenance Plans, the Maintenance Plans themselves are actually SSIS packages so if you need to change something such as...

If the users can upload any Excel file then I don't see how you can have a static Excel Source.

It is possible to create a dynamic Excel destination through...

Sean Lange (7/2/2014)

---

And unless this is a distributed system I just don't care for guids. They are exceptionally wide and a complete pita to work with. Debugging and such is...

Failover Replication?

Do you...

I expect someone like Perry Whittle will answer this in more detail, but when Server-1 goes down, your Subscriber databases(s) on Server-3 will no longer receive transactions (or snapshots -...

I agree with that! Everything else (trying to promote your standards over others) just opens up a can of worms and...