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 ««1234»»»

What is Biml? - Level 1 Expand / Collapse
Author
Message
Posted Wednesday, July 17, 2013 6:58 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Today @ 9:04 AM
Points: 3, Visits: 286
Please sign me up for the series. Cannot wait.
Post #1474580
Posted Wednesday, July 17, 2013 9:01 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 30, 2014 3:37 AM
Points: 112, Visits: 89
Andy Leonard (7/17/2013)
Koen: thanks for answering Vijay's question!

theboyholty (7/17/2013)
You mentioned an article in the Stairway Series called "Building an Incremental Load Package – Level 3" maybe I'm being thick but I couldn't find that article. There was one called "Adding Rows in Incremental Loads - Level 3" but that had no mention of BIML.

Could you provide the link to the article please?


Hi Theboyholty,

"Building an Incremental Load Package - Level 3" is the title of the third installment in this series - the Stairway to Biml. As I type, Level 2 of this series (entitled Biml Basics - Level 2) has been written, edited, and is being scheduled by our most capable SQLServerCentral editor-in-chief, Steve Jones. Level 3 (Building an Incremental Load Package - Level 3) and Level 4 (Using Biml as an SSIS Design Patterns Engine – Level 4) are being revised by the authors, Paul Waters and myself. We have the demo built for Level 5 through Level 8 or so, and we are outlining the articles.

I promise we will get the articles published as soon as we can. Biml is exciting new technology - game-changing technology, in my opinion.

Bruce and Roshan Joe, I believe Biml will deliver. I look forward to your feedback as the series progresses.

:{>


Thanks for the quick reply. I'm looking forward to seeing how Biml might be of use in the future.
Post #1474670
Posted Wednesday, July 17, 2013 9:31 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, June 13, 2014 7:19 AM
Points: 6, Visits: 27

Looking forward to learning BIML, thanks for the articles Andy
Post #1474688
Posted Wednesday, July 17, 2013 10:11 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Saturday, December 13, 2014 6:08 PM
Points: 248, Visits: 547
Hi,

Is there a way we can be notified if the next series article gets published (other than watching emails from SQL ServerCentral.com)?

Thanks!
Post #1474710
Posted Wednesday, July 17, 2013 11:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, January 27, 2014 11:51 AM
Points: 30, Visits: 61
Sounds very promising. Looking forward to reading the next level.
Post #1474746
Posted Wednesday, July 17, 2013 3:38 PM


Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 4:12 PM
Points: 758, Visits: 1,031
Some interesting additional reading here: http://bimlscript.com/
Post #1474823
Posted Thursday, July 18, 2013 3:52 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, November 18, 2014 5:51 AM
Points: 328, Visits: 2,001
I created something similar in .NET recently for SSIS 2008 as part of a Masters project. It basically encapsulated and simplified the access to the SSIS object model allowing packages to be quickly built in C# using simple declarations and methods.

Creating a For Each Loop container:

ForEachLoopContainer ForEachFile = new ForEachLoopContainer(SQ, 
"For Each File",
"C:\\Data",
"IncomingData.csv",
"FileName");

Inserting a SQL Task into the container:

SQLTask LogFile = new SQLTask(ForEachFile, 
"Log File",
OleDBConnectionString,
"insert into Filelog
(InputFileName, DateProcessed)
values(?, getdate())");

I thought that the advantage of this over the BIML model was that it meant developers already fluent in SSIS and C# didn't have to learn another language.
Post #1474955
Posted Thursday, July 18, 2013 4:19 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Friday, December 19, 2014 9:36 AM
Points: 711, Visits: 2,211
sql_er (7/17/2013)
Hi,

Is there a way we can be notified if the next series article gets published (other than watching emails from SQL ServerCentral.com)?

Thanks!


Follow Andy on Twitter, he tweets when new articles are addded.

Thanks,


Simon




MCSE: Data Platform
MCSE: Business Intelligence
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne
Post #1474959
Posted Thursday, July 18, 2013 10:18 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 10:00 AM
Points: 7, Visits: 265
Great article! Thanks Andy!
Post #1475131
Posted Thursday, July 18, 2013 1:47 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 12:27 AM
Points: 542, Visits: 805
I am surprised I've never heard about BIML previously. I wonder if a lot of folks out there use it or is this something new?


Post #1475202
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse