Viewing 15 posts - 1 through 15 (of 767 total)
Is this option possible only if the source is a data file? can the source be oracle instead of a data file?
Fast Load Options
If the OLE DB destination uses a...
March 30, 2019 at 7:41 pm
DEar Frederico,
Please see my replies below:
you got SQL Enterprise or other?
Not sure.
Is this incremental or full load? if incremental how do you deternime inserts/update/deletes?
It's full load. We truncate the...
March 30, 2019 at 7:28 pm
Sorry this last answer I did not understood.
I got this reply in my company:
"On a object you can setup...
July 9, 2018 at 2:09 pm
I don't expet to havemuch more data. but more data will needed.
Solution is composed by:
1 staging area , one data mart one tabular cube.
We...
July 7, 2018 at 10:03 am
sorry. Let me had more verbose to it.
This is a MSBI reporting tool.
We consume infromation from an oracle DB into our staging area using SSIS. Then...
July 7, 2018 at 9:57 am
Thank you very much. Let me just add another point. We are using tabular model and we expect to have millions and millions of rows on the facts. I don't...
July 4, 2018 at 3:21 pm
Thank you for your reply. We have a bi application that takes information from views that that exist in an oracle db. We get this information into our side into...
July 4, 2018 at 12:42 pm
Because we have several things in our backlog that are very important also. So, if upgrading to 2017 is not important from a powerbi perspective then we can consider the...
May 6, 2018 at 12:41 pm
April 17, 2018 at 6:41 am
April 17, 2018 at 4:49 am
I decided to move with a different approach:
I have an SSIS package with two different connections and two different file flat file sources inside the same data flow.
April 17, 2018 at 4:26 am
Now my problem is. I would not like that if Dataflow 1 fails that the package fails. Instead I would like to wait for the result of data flow 2...
April 16, 2018 at 9:15 am
Thank you very much.
I guess I found a cool solution that I would like to post here.
I have created two connections, one called "ResColumn" and Other "WithoutResColumn"
April 16, 2018 at 9:09 am
Viewing 15 posts - 1 through 15 (of 767 total)