If you read the second book I listed, it talks about 20 different roles, which to my mind is overkill...

I assume that you are using a For Each Loop container; what have you got set in your Enumerator Configuration, i.e. are you looking for particular files names and extensions?

Regards

Lempster

I recommend getting hold of a couple of books: Star Schema The Complete Reference by Christopher Adamson and The Microsoft Data Warehouse Toolkit by Joy Munday and Warren Thornthwaite.

Before you...

I don't believe so. There are custom components for SSIS that can connect to a Netezza database and using that you could populate a SQL Server database and build some...

A fascinating discussion, but the most important question is surely... what is a where clause cafeteria?!

I...

Have a look at the links I've provided. They both come to roughly the same conclusion which is that BizTalk is useful for complex workflows involving small amounts of data...

If you are considering using CDC or Transactional Replication then you are not really getting away from Incremental Loading are you?

Do you effectively want to completely re-populate your ODS or...

I don't know anything about Odata, but are you trying to run the SQL Agent job on the same box as you successfully ran the package within SSDT? If not,...

pinkuraj.l (3/11/2015)

---

1.Which edition do you have of SQL Server?

2.Regarding the XML files: how complex are they? What kind of processing do you do?

Answer of your Question:

1.We are using SQL Server...

You could try using the undocumented fn_dblog. The article referenced by this link http://www.sqlskills.com/blogs/paul/finding-out-who-dropped-a-table-using-the-transaction-log/ concerns finding out who dropped a table, but you could adapt to look for ALTER statements.

I...

m_swetz (3/10/2015)

---

There is a stored procedure that merges the ship, order, and load tables that does computations and concatenations of fields. This procedure also attempts to retain the identity...

TomThomson (3/8/2015)

---

I'll...

Were you able to take your backup and if so, is it possible that there is now insufficient space on the drive for SQL Server to even start?

Regards

Lempster

Have you got any DELETES within your process or is it possible that an INSERT failed? In both cases you would see a jump in your IDENTITY values.

Regards

Lempster

I'm not an expert on this by any means, but IIRC, you have to create an identical table minus the columnstore index and use partition switching to 'switch in' the...