Also, make sure you have the right version of the Oracle client. 64 vs. 32bit makes a huge difference. You should also attempt to build some kind of...

Sorry, just got back. I didn't really read through your second post, but I think this is right/close/gives you an idea. Also, SQL 2008 R2 makes it easier.

DECLARE@timeend...

Start to finish, with stealing a line from Lynn.

DECLARE @startdate DATETIME

SET @startdate = '2012-05-14 12:07:00.000'

Declare @enddate DATETIME

SET @enddate= '2012-05-15 15:40:34.497'

DECLARE @elapsedtime INT

SET @elapsedtime = datediff(mi, @startdate, @enddate)

SELECT...

The above component is fast, but it does require significantly more memory to do it that way.

Yep, I got it wrong (technically right) because I was wrapped up in the declaration of variables.

Charles Kincaid (1/17/2012)

---

It's still good as a teaching exercise. In practice it might be better to have a scratch location for the master and then read the destinations from...

Fair enough. I feel the same way about Powershell.

I'm not a fan of this. Aside from it being a maintenance issue (editing the SSIS package every time a new folder is needed or removed), you could at...

Ah, thanks guys. It makes sense, just never occurred to me to write it that way.

Edit: Indeed, I did edit it. Meant to note it. My bad.

You're syntax is incorrect.

Try the following:

SELECT tim.Number, tim.DisplayName, tim.TkprStatus from LINKEDSERVERNAME.database.schema.table as tim

So this says

Note

Creating compressed backups is supported only in SQL Server 2008 Enterprise and later, but beginning in SQL Server 2008, every edition can restore a compressed backup.

Well played!

Slope (4/27/2011)

---

Of course, if you use a calendars table you never have to worry about having to code or validate any date calculations ever again. 😛 Sure makes...

How is this not better?

Select day(dateadd(mm,DateDiff(mm, -1, getdate()),0) -1)

It's all about how it's used and understood. For most of the failed ORM based projects I've seen, the idea is that you let the ORM write the SQL...

Why not just include all your SSIS packages in one project in BIDS, and deploy it using the Manifest?