BI_NewBie (12/2/2014)

---

OK!!

Below is the way i am following :

1 Created three variable Query, Sdate, Edate

a. Query = SELECT * FROM Table where date<=...

select @variable

princessthedba (12/1/2014)

---

I mean this. Assume I have 2 backup dates for hostname "c" and 3 backup dates for hostname "d". And the table is like that:

hostname last_backup

c ...

uravindarreddy (12/1/2014)

---

Oh wow! Thats a nice use of Regular Expressions! Never tried before.

I am curious to know about how data is migrated?

The code can be changed but how the existing...

You are on the right track, it seems.

But you should note that the PK does not have to be clustered.

So you could easily convert your PK to nonclustered and introduce...

If so, you could use a FOR loop with an increment of 4 and use an expression to set your source SQL which references the loop variable in its WHERE...

Ah, so you want to do the load in 4-hour batches – in a loop?

Use a query as the source for your data (and not just a table).

select ...

from ...

where DateModified > dateadd(hour,-1,getdate())

Select DbName, LatestBackupDate = Max(BackupDate)

from table

group by DbName

We have...

You're not the first, and won't be the last, to get caught by this.

MS should make all declarations of Varchar without size a syntax error, in my opinion.

Because I believe the poster was asking whether...

Uwe Ricken (11/26/2014)

---

Hi Faraz,

you can use DBCC IND if you use SQL Server < 2012 or sys.dm_db_database_page_allocation for SQL Server >= 2012.

This will give you a list of allocated pages.

To...

It would be useful to know a bit more about the dbo.systemsequences table.

Does this hold 'next id for table x' values only, or is there more to it than that?...

Chris Harshman (11/25/2014)

---

in SSIS 2008 we use FMTONLY in the ADO.Net Source task's SQL command text:

SET FMTONLY OFF;

EXEC SomeProcedureNameHere;

does this method still work in SSIS 2012/2014? Microsoft says it...