Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS - MDS Expand / Collapse
Author
Message
Posted Friday, September 6, 2013 12:06 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 3:46 AM
Points: 608, Visits: 1,056
Comments posted to this topic are about the item SSIS - MDS

Pramod
SQL Server DBA | MCSA SQL Server 2012

in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
Post #1492045
Posted Friday, September 6, 2013 12:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:28 AM
Points: 13,641, Visits: 11,517
Interesting question. I haven't used MDS yet, so definately learned something.
Curious why SSIS is in the title though. At first sight it doesn't have to do anything with the MDS deployment.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1492052
Posted Friday, September 6, 2013 1:58 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, December 11, 2014 11:05 PM
Points: 880, Visits: 336
Easy one. Thanks
Post #1492075
Posted Friday, September 6, 2013 3:25 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 1:08 AM
Points: 4,160, Visits: 5,557
Interesting question.
definitely learned something new today.


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1492108
Posted Friday, September 6, 2013 6:50 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 4:21 PM
Points: 7,928, Visits: 9,653
Interesting question.

I haven't used this stuff, so my answer was based on very limited knowledge and was wrong. I'm a bit confused about this stuff. The page referenced in the explanation looks on the surface as if it clears things up, but leaves something of a problem; a better explanation could maybe clear this up (BOL doesn't, as far as I can tell). I suspect the answer to todays QOTD is right although the page it references doesn't actually support it (it doesn't distinguish between metadata and other things the package contains, while the schema for a package makes that a very clear distinction) because I am inclined to regard the BOL documentation in this area as self-contradictory so I am probably better off believing the answer than questioning it.

But I'm still confused, and some clarification would be useful. The problem is that the information available on various BOL pages appears to contain contradictions. The Model Deployment Package XML Schema (Master Data Services) page states that the package is an XML file with a particular schema, and defines that schema: the schema appears to have no place for subscription views; but the BOL page referenced in the explanation says the package does contain subscription views; the schema puts business rules outside of the metadata element, as something separate, which contradicts the answer (but not the page it references: that page says the package contains business rules, it doesn't say they are part of the metadata - and that would make me suspect the answer today was wrong, if I could trust BOL); another BOL page (can't remember which) says that all user metadata is contained in subscription views - which seems to suggest that if user-defined metadata is not allowed in the package it can't contain subscription views, another apparent contradiction in BOL; collections are not mentioned anywhere in the schema, but the answer and the page it references says they are in the package, another contradiction.

I guess people can see why I'm confused; maybe someone can tell me which bits of BOL I should believe on this topic?


Tom
Post #1492201
Posted Friday, September 6, 2013 6:54 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, December 11, 2014 11:05 PM
Points: 880, Visits: 336
http://technet.microsoft.com/en-us/library/ff486956.aspx

I believe the question was picked directly from here.
Post #1492205
Posted Friday, September 6, 2013 7:14 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 4:21 PM
Points: 7,928, Visits: 9,653
ksatpute123 (9/6/2013)
http://technet.microsoft.com/en-us/library/ff486956.aspx

I believe the question was picked directly from here.

I hope not. If it was, whoever did the question totally misunderstood the page; the question is about metadata; the only thing the page says about metadata is that there is no user-defined metadata in the package as deployed.


Tom
Post #1492214
Posted Friday, September 6, 2013 12:22 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 1:21 PM
Points: 812, Visits: 787
Not sure if this helps. But I looked at

http://technet.microsoft.com/en-us/library/ff486971.aspx

and found under Next Steps


User-defined metadata, file attributes, and user and group permissions are not included in model deployment packages. After you deploy a model, you must update these manually.
Post #1492361
Posted Friday, September 6, 2013 1:29 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Friday, December 19, 2014 9:43 AM
Points: 1,925, Visits: 2,205
jan.dewettinck (9/6/2013)
Not sure if this helps. But I looked at

http://technet.microsoft.com/en-us/library/ff486971.aspx

and found under Next Steps


User-defined metadata, file attributes, and user and group permissions are not included in model deployment packages. After you deploy a model, you must update these manually.


Same information is given in

http://technet.microsoft.com/en-us/library/hh479646.aspx

which does not involve the use of the wizard.


Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1492394
Posted Thursday, October 3, 2013 5:46 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 3:24 AM
Points: 1,144, Visits: 299
cnerver used it! did someone do ? only 733 answer tit his question people seemed not very concerned
Post #1501132
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse