I would do this in two steps:

1. Run an Execute SQL Task to retrieve the max ID from the destination table and store the result in a variable.

2. Run a...

You can select values from your table into a Variable of Type Object using an Execute SQL Task. Then you can iterate over that Variable using the ForEach Loop Container...

DB_Newbie2007 (2/11/2013)

---

Sorry for any confusion... I believe there are a few levels of "ownership" (http://www.sqlservercentral.com/articles/SQL+Jobs/68764/) per my understanding?

1) The account that is configured to run SQL Server Agent service....

DB_Newbie2007 (2/11/2013)

---

Nope. No proxies.

The job is actually run with a custom higher level account with full permissions in every database. Yes, it has full SA permissions... again, please no...

You will need 30 different Source and Destination combinations in your SSIS Package. Given how Excel work and the fact that concurrent access is not a good idea I would...

Any proxies in play?

nedneu (2/10/2013)

---

Hi Guys,

my project started 2 months ago, and alalready'i'mransferring over 100 tables on each process i run to the DWH.

i'll probably reach 200-300 tables pretty soon (a...

A SQL Agent Alert that leverages WMI could run a Job for you. Lookup SQL Agent Alerts and the WMI Event Class __InstanceCreationEvent.

You could also do this a few different...

I am not sure how you could alert based on one specific query causing 80% CPU use because SQL Server abstracts a lot of that but you could get a...

Rob Schripsema (2/5/2013)

---

Great question, Tom

I almost wish you had thrown in an option of '2012-04-01 10:00:00.000' to spice up the thinking a bit more. Of course, then I probably would...

Nice question.

When you say "crashed" what do you mean? Is the tran log backup file corrupt and unable to be restored? Where are you trying to restore this backup?

Are you...

Some DDL yes, but nothing by default for DML. You would have had to have a Trace running to capture the DML activity.

Nice. I figured there was something else up your sleeve otherwise you would not have said anything. That could be handy for some as it relates to their ability to...

I could be wrong because I do not do much of this type of programming but I think xp_dirtree will only get you the list of directories however not the...