Stairway to Biml Level 5 - Biml Language Elements

  • Reeves Smith

    SSC-Addicted

    Points: 436

    Comments posted to this topic are about the item Stairway to Biml Level 5 - Biml Language Elements

  • Jeff.Mlakar

    SSC Enthusiast

    Points: 106

    This was an excellent walkthrough. But I have a question: If you have a Biml file with BimlScript in it, is there any way to see the Biml generated by the BimlScript before it is compiled into an SSIS package?

    Thank you.

  • Reeves Smith

    SSC-Addicted

    Points: 436

    Jeff,

    Yes there is.

    Marco Schreuder @ in2bi wrote a great post on just that subject.

    [/url]

    Hope this helps and thanks for checking out the article.

    Biml rocks...

    Reeves

  • Jeff.Mlakar

    SSC Enthusiast

    Points: 106

    Thanks for the quick reply, Reeves! This is great!

    I have a few other small Biml questions, if you don’t mind:

    1. Can you use Biml to create SSRS reports?

    2. What version of .NET is BimlScript using?

    3. Can you kick off package generation from Biml through PowerShell?

    4. Can you convert an existing SSIS package into Biml? (or do I need Mist to be able to do that?)

    5. What are the capabilities of Mist over just using SSDT?

    Thank you so much!

    Jeff

  • Reeves Smith

    SSC-Addicted

    Points: 436

    Jeff,

    Sorry for the delay.

    1. Can you use Biml to create SSRS reports?

    Not at present and I understand it is not currently on the roadmap

    2. What version of .NET is BimlScript using?

    3.5

    3. Can you kick off package generation from Biml through PowerShell?

    Yes and this is a Mist only feature.

    4. Can you convert an existing SSIS package into Biml? (or do I need Mist to be able to do that?)

    Yes and again this is a Mist only feature.

    5. What are the capabilities of Mist over just using SSDT?

    Here are a couple items: Analysis Services support (Mist 4.0 will now support Tabular), Transformers, Build Automation, SSIS Package Import, Full IntelliSense.

    Hope this helps.

    Reeves

  • Reeves Smith

    SSC-Addicted

    Points: 436

    Jeff,

    Forgot to mention that if you are interested in Automating Builds with Mist, Scott Currie (Mr. Biml) just put out an article on BimlScript.com.

    http://www.bimlscript.com/Walkthrough/Details/3080

    Reeves

  • smarinova

    SSC Enthusiast

    Points: 182

    Is there a way to add Annotation to the package? Like when you right click and select "Add Annotation" ?

  • Reeves Smith

    SSC-Addicted

    Points: 436

    smarinova,

    A Biml annotation is not the same as a SSIS annotation and there is not a way to add SSIS annotations from Biml.

    Biml annotations are for tagging items within Biml.

    Hope this helps.

    Reeves

  • smarinova

    SSC Enthusiast

    Points: 182

    thank you very much!

    It does not help though. I need to have a SSIS annotation. How can I use BIML to generate packages when I cannot add a simple annotation that explains what the package does?

  • Misha_SQL

    SSCertifiable

    Points: 5267

    Thank you for the series! I just checked on Amazon and there is no book about BIML yet. I hope somebody is working on one :-).

    Quick question related to the "Root" node discussion. The article shows that we can refer to the "Source" connection by using: RootNode.OleDbConnections["Source"]. How come we don't have to reference the "Connections" node? I would expect to see something like this: RootNode.Connections.OleDbConnections["Source"]

    Am I confusing the BIML structure with the BIML object model?

  • Phil Parkin

    SSC Guru

    Points: 243277

    Misha_SQL (11/17/2014)


    Thank you for the series! I just checked on Amazon and there is no book about BIML yet. I hope somebody is working on one :-).

    Quick question related to the "Root" node discussion. The article shows that we can refer to the "Source" connection by using: RootNode.OleDbConnections["Source"]. How come we don't have to reference the "Connections" node? I would expect to see something like this: RootNode.Connections.OleDbConnections["Source"]

    Am I confusing the BIML structure with the BIML object model?

    This was puzzling me too. I would have expected:

    RootNode.Connections["Source"]

    as I do not see an OleDbConnections collection.

    If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.

Viewing 11 posts - 1 through 11 (of 11 total)

You must be logged in to reply to this topic. Login to reply