Stairway to Biml Level 5 - Biml Language Elements

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

  • 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.

  • 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

  • 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

  • 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

  • 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

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

  • 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

  • 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?

  • 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?

  • 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.
    See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.

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

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