This might help get you started:

http://thesqldev.wordpress.com/2013/03/23/iterate-over-databases-using-ssis-part-2/

Are you convinced you require a round trip to the database server at all?

If your example reflects the true need and the SSIS Package runs on the same machine as...

Rube

christopher_rogala (7/31/2013)

---

Let me start off by saying, I agree that temp tables are much more efficient that variable tables; and try to exclusively use temp tables. That said, you...

Verify network connectivity?

Is the dL4 server reachable from your SQL Server, networking-wise? If your design time server is not and you are using a Package Configuration make sure you have DelayValidation set...

It's also worth experimenting with the buffer size and rows settings of your Data Flow:

http://msdn.microsoft.com/en-us/library/ms141031(v=sql.105).aspx

Are the dL4 drivers installed on the server?

If yes, then is your server 64-bit? If so, are your dL4 drivers 32-bit or 64-bit drivers?

If 32-bit, make sure you're Agent job...

By the way, cd is not a different, older command than Set-Location, it's...

That's what I do too, and recommend on 2008 R2 but I was hopeful with the change in the approach to PowerShell steps introduced in 2012 that the user experience...

It must have had something to do with the switch in SQL Agent 2008 to 2012 from them dropping us into a mini-shell versus dropping us into a full blown...

SQLRNNR (7/26/2013)

---

bcsims 90437 (7/26/2013)

---

Daniel Bowlin (7/26/2013)

---

crookj (7/26/2013)

---

SQLRNNR (7/25/2013)

---

Don't ever cross them - you could be in a world...

This is more of an engineering problem related to Oracle, not SQL Server. Does Oracle have anything analogous to SQL Server Change Tracking or Change Data Capture?

You cannot send output to the Out-Host when using a PowerShell step type. Long story, but PowerShell steps in Agent 2008 are not full shell. In Agent 2012 the experience...

Download the backup solution from ola.hallengren.com and you can schedule a single call to his stored procedure to backup all databases sequentially in one job step.