Stairway to Biml Level 5 - Biml Language Elements

Question

Stairway to Biml Level 5 - Biml Language Elements

Reeves Smith

Mr or Mrs. 500

Points: 582
More actions
July 1, 2014 at 9:23 pm

#309617

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

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

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

Jeff.Mlakar SSC Enthusiast Points: 106 More actions · Answer 1

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 Mr or Mrs. 500 Points: 582 More actions · Answer 2

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 More actions · Answer 3

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 Mr or Mrs. 500 Points: 582 More actions · Answer 4

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 Mr or Mrs. 500 Points: 582 More actions · Answer 5

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: 192 More actions · Answer 6

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

Reeves Smith Mr or Mrs. 500 Points: 582 More actions · Answer 7

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: 192 More actions · Answer 8

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: 5407 More actions · Answer 9

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: 246985 More actions · Answer 10

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.

The absence of evidence is not evidence of absence.
Martin Rees

You can lead a horse to water, but a pencil must be lead.
Stan Laurel