You could keep a list of tables you want to import.

You query the metadata tables in Oracle (it should have INFORMATION_SCHEMA.COLUMNS et cetera) to find the table structures.

Create your destination...

Did you check the report logs?

Bruce Hendry (3/29/2013)

---

So in SSIS 2012 (VS2010 using SSDT) I am noticing an issue with metadata refresh that no longer responds to the tricks described in this post, and worse...

If you install SSIS on the same machine as the database engine where the MSDB database resides, you normally don't need to edit the configuration file.

WayneS (3/29/2013)

---

Koen Verbeeck (3/28/2013)

---

Totally unrelated - as usual in this topic - I got the MCSE Business Intelligence certificate today.

Because someone has to answer all those BI questions on this...

srilu_bannu (3/29/2013)

---

Koen, I have Database engine installed on default instance which is on nycab server.

Brandie, I couldn't import the package after i go to SSMS, choose SSIS service and under...

kapil_kk (3/29/2013)

---

But I am doing only insertion not updation...Will it be good to use it only...

Try using a MERGE statement instead.

Inserting, Updating, and Deleting Data by Using MERGE

If I'm not mistaken you want a row for every date/time combination and put the values in different columns?

This would be done with a PIVOT statement.

Using PIVOT and UNPIVOT

What are you exactly struggling with?

Whoops, Friday got me. Didn't put much thought in it and selected the wrong answer.

Thanks everyone for the congrats.

I am. The chocolate at least 🙂

Totally unrelated - as usual in this topic - I got the MCSE Business Intelligence certificate today.

Because someone has to answer all those BI questions on this forum 😉

Steve Jones - SSC Editor (3/28/2013)

---

Wife and son saw it last night. My wife doesn't usually love those kinds of movies, but she said it was enjoyable. Not much plot...

tmitchelar (3/28/2013)

---

Cindy Conway-312336 (3/28/2013)

---

A follow-up question ...

If VS is running as 32-bit, why do I need to set Run64BitRuntime to False? If I don't I get the following error:

The requested...