Got a Paypal account? 😛

mazzz (10/26/2010)

---

Alvin Ramard (10/26/2010)

I can't confirm, but I believe you're correct.

Another option is to recreate the DSNs on your computer. That means you have to install those drivers used...

Looks like you'll have to use a data flow for each tables. ...

In the control flow, there's a task for copying database objects. That might be a better option for you.

mazzz (10/26/2010)

---

I have a server with lots of ODBC system DSNs set up which connect to an Oracle database (this is part of a 3rd party application)

What I need to...

Do you have Integration Services running on your computer? You need it to run SSIS packages on your computer.

Also, try running DTExecUI. You can use it to build...

bruce.b.allen (10/26/2010)

---

Alvin Ramard (10/25/2010)

---

I agree with Derrick that flat files would be much easier.

If you have to use Excel, and you have a row number for every row...

Phil Parkin (10/26/2010)

---

It's because they don't know how to use Access and Notepad is ungainly to use - understandable, I think. But we as IT people are in a position...

I think you should start by reading this book:

The Data Warehouse Lifecycle Toolkit

http://www.wiley.com/WileyCDA/WileyTitle/productCd-0470149779.html

If you inject a row number into you data flow, then by using the condition split transform you can control which rows go to your destination and which don't.

I often use On Error Event Handlers to append error messages to my own user defined ErrorMessages variable. At the end of the execution, if the length of that...

pete_bristol (10/25/2010)

---

GSquared

Thank you for your prompt reply.

I am familiar with the "ON" clause but cant see how it relates to three tables

i.e. Using my example

select * from tableA

left outer join...

The more ETL work I do, the more I hate Excel.

Excel is a great product. Just keep it away from ETL.

I agree with Derrick that flat files would be much easier.

If you have to use Excel, and you have a row number for every row of data going...

If the stored procedure does not connect to another server then it's very unlikely network problems would affect the performance.

Assume the stored procedure only accesses databases on this server, what...