Welcome to EMC Consulting Blogs Sign in | Join | Help

Browse by Tags

All Tags » SSIS
Showing page 1 of 39 (386 total posts)
  • Integrating a rules engine with integration services

    Introduction As I have mentioned in several previous posts, I have been working on a data warehouse project. One of my main roles within this project was to work with our clients JRules / Java consultants to help integrate IBM JRules, a rules engine, with Microsoft SQL Server 2008 R2: Integration Services (SSIS). The goal of the integration ...
    Posted to Steve Wright's Blog (2005 - 2012) (Weblog) by steve.wright on October 17, 2011
  • Denali : Using EXECUTE WITH RESULT SETS (example using SSIS Source Adaptors)

    One of my pet peeves about stored procedures is the lack of clarity they provide a user on the data types of returned columns.  This is especially applicable when the column returned has been calculated. Consider a statement such as this SELECT 10.0/5. It’s not obvious what that data type is. Now consider the fact that as the SQL developer I ...
  • MCTS for SQL Server 2008 - Business Intelligence Development and Maintenance Part II

    Well here we are, I promised in my last post that I would let you know how my studying was going on and also share with everyone anything I find of interest in the course of my studies. I have now done the first 4 chapters of the book which are all focused on SSIS before moving onto both the areas of SSAS and SSRS required by the syllabus.  ...
    Posted to Guy Sturgess' Blog (Weblog) by guy.sturgess on March 30, 2010
  • Editing Configuration files : SSIS Nugget

    Its been a long-g-g-g-g time since I did a SSIS-related post so here’s a little ditty that I picked up while reviewing some internal stuff today. Editing SSIS configuration (i.e. .dtsConfig) files isn’t particularly easy. Most people I see who try to do this use a traditional text editor like Notepad but that isn’t a great experience because the ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on August 4, 2009
  • SSIS Connect digest 2009-07-05

    Here is the latest collection of submissions to http://connect.microsoft.com/sqlserver/feedback that pertain to SQL Server Integration Services (SSIS) and which I think are worthy of your attention. Take a read of the items below and if you agree with the aim of the submission, please click through and vote for it – it only takes a few seconds. ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on July 5, 2009
  • Enterprise Mashups

    Of late one may have noticed that I have become very interested in high-brow, generally vaporous, disciplines such as RESTful data services, data interoperability and cloud computing whilst coincident with that has been the inexorable rise of the term “mashup” in the information technology lexicon. “Mashup” means different things to different ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on June 23, 2009
  • Attunity Webinar : Learn about Oracle Change Data Capture (CDC) for SSIS

    This is a Public Service Announcement.  Attunity makers of all things connect-y for SSIS are putting on a webinar for their latest product Oracle CDC for SSIS. It’s an enabling solution that accelerates the development of real time data integration with Oracle systems. The event is to be held online on Monday, June 22, 2009 10:00 AM - ...
  • Attunity release Oracle-CDC for SSIS

    [If you’re using SSIS to pull data out of Oracle then this may be of interest to you.] In SQL Server 2008 Microsoft introduced a feature called Change Data Capture (CDC) which basically enables you to query a SQL Server table from within SSIS and ask for all rows that have been created or changed since a given point-in-time. Attunity have now ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on May 29, 2009
  • 4000 character limit in SSIS

    I’ve noticed some confusion in the community over the mythical “4000 character limit” in SQL Server Integration Services (SSIS) and thought it may be worth clarifying the situation. The most common misconception I hear is “A SSIS string variable has a maximum length of 4000 characters”. This isn’t true and its easy to prove; simply create a ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on May 27, 2009
  • Viewing Windows Azure log files using SSIS

    Applications hosted on Windows Azure will create log files and given that we don’t have access to the running app instances the log files are the only means available to us for debugging and problem resolution so they’re a very important part of the whole service. Recently I wanted to take a look at the log files for my Tweetpoll Azure application ...
    Posted to SSIS Junkie (Weblog) by jamie.thomson on May 14, 2009
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Personal Edition), by Telligent Systems