Viewing 15 posts - 5,776 through 5,790 (of 11,678 total)
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...
March 30, 2013 at 2:32 pm
Bruce Hendry (3/29/2013)
March 30, 2013 at 1:45 pm
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.
March 30, 2013 at 1:41 pm
WayneS (3/29/2013)
Koen Verbeeck (3/28/2013)
Because someone has to answer all those BI questions on this...
March 29, 2013 at 1:34 pm
srilu_bannu (3/29/2013)
Brandie, I couldn't import the package after i go to SSMS, choose SSIS service and under...
March 29, 2013 at 1:31 pm
kapil_kk (3/29/2013)
Koen Verbeeck (3/29/2013)
Try using a MERGE statement instead.
But I am doing only insertion not updation...Will it be good to use it only...
March 29, 2013 at 5:28 am
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.
March 29, 2013 at 4:44 am
What are you exactly struggling with?
March 29, 2013 at 3:37 am
Thanks everyone for the congrats.
BTW, Happy Easter to whoever celebrates it.
I am. The chocolate at least 🙂
March 28, 2013 at 3:54 pm
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 😉
March 28, 2013 at 2:06 pm
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...
March 28, 2013 at 1:47 pm
tmitchelar (3/28/2013)
Cindy Conway-312336 (3/28/2013)
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...
March 28, 2013 at 1:38 pm
Viewing 15 posts - 5,776 through 5,790 (of 11,678 total)