THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » denali » SSIS   (RSS)
Showing page 2 of 2 (19 total posts)
  • SSIS Denali CTP1 Source Assistant

    I like the new Data Flow Source Assistant in SSIS Denali. The default view is shown above, with the ''Show installed only'' checkbox checked. When not checked, the list of Source types changes: In previous versions of SSIS, I rarely created connections in the Connection Managers pane - I usually hit a New button in either a Source or ...
    Posted to Andy Leonard (Weblog) by andyleonard on December 2, 2010
  • SQL Server v.Next (Denali) : Launch point for BI resources

    Microsoft's new data platform vision for BI is called BISM - Business Intelligence Semantic Model.  While I focus primarily on manageability, availability and database engine features, I'd like to keep tabs on who can help you out with their input on the other aspects I rarely touch - Analysis Services (SSAS), Integration Services (SSIS), and ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 30, 2010
  • Synchronous execution of SSIS packages using T-SQL : Denali

    This post relates to SQL Server code-named Denali which at the time of writing is a pre-release version of the next version of SQL Server. It is also known as SQL11 and is expected to be released sometime in 2011 or 2012. The name given to it on release is not yet known. Some of the information in this blog post may not be true upon ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 19, 2010
  • SSIS Server, Catalogs, Environments & Environment Variables in SSIS in Denali

    In the last few days I have written 3 blog posts covering some new features in SQL Server Integration Services (SSIS) in the next version of SQL Server, code-named Denali: Introduction to SSIS Project in Denali Parameters in SSIS in Denali The new Execute Package Task in Denali In this blog post I’m moving onto talking about the new ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 13, 2010
  • The new Execute Package Task in SSIS in Denali

    In my blog post of 10th November Introduction to SSIS projects in Denali I spoke of how, in Denali, SSIS packages can collectively be distributed as a single unit called a Project. I want to start digging into the advantages that Projects bring and the first such example is the new Execute Package Task. If we compare the old and new then the ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 12, 2010
  • Parameters in SSIS in Denali

    In my last blog post Introduction to SSIS Projects in Denali I talked about the new Project deployment model that is coming in the next version of SQL Server Integration Services (SSIS); working hand-in-hand with Projects is another new feature – Parameters. Parameters are similar to Variables in SSIS today that we all know and (ahem) love but ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 11, 2010
  • Introduction to SSIS Projects in Denali

    The next version of SQL Server has been unveiled and it has a codename of Denali (aka SQL11, not aka SQL2011). SQL Server Integration Services (SSIS) is receiving quite an overhaul in Denali and over the next few days I’m going to outline some of the changes. Today? Projects! In SSIS today (i.e. prior to Denali) we build these things called SSIS ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 10, 2010
  • What's new in SSIS in Denali?

    SQL Server codename Denali was presented to the world yesterday and with it a promise that there's a lot of goodness coming in the new version of SSIS. I've got a few half-written blog posts coming up on that but in the meantime you might want to dive into some new SSIS content that has been posted on the TechNet wiki. The SSIS documentation ...
    Posted to Jamie Thomson (Weblog) by jamiet on November 10, 2010
  • Newly closed Connect items auger well for SSIS in Denali

    Todd Mcdermid spoke recently on his blog post Integration Services vNext Coming Soon about how some recently closed Connect items had encouraged him as to the future of SSIS. Also, Matt Masson from the SSIS team has written a similarly encouraging blog post about some upcoming SSIS enhancements at Upcoming Product Changes. Now its my turn. Just ...
    Posted to Jamie Thomson (Weblog) by jamiet on September 10, 2010
Privacy Statement