Login or Sign Up to become a member!
LessThanDot Sit Logo

LessThanDot

All Blogs

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot friendfeed Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Your profile

    Search

    XML Feeds

    Google Ads

    Tags: ssis

    comments

    Force installation of 64-bit ACE OLE DB provider

    by Koen Verbeeck on Apr 23, 2013 in categories Microsoft SQL Server, SSIS. Article views: 8998 views

    This blog post describes how you can install the 64-bit ACE OLE DB provider when you have 32-bit Office components installed.

    Read More...
    comments

    I was in New York City yesterday, hanging out with fellow MVP and blogger Ted Krueger in Union Square. I asked him if he uses the Data Profiling Task task a lot, he said not really. I don't use it a lot either but I decided to show you what you can do w…

    Read More...
    comments

    If you are into Business Intelligence, you are in luck, this week Microsoft has released a SQL Server 2012 Business Intelligence whitepaper as well as SQL Server Data Tools – Business Intelligence for Visual Studio 2012 (SSDT BI) templates. The white…

    Read More...
    comments

    And it is time again for another “stupid me”! For those unfamiliar with the concept: Every time I do something “stupid”, which happens from time to time, I’ll do a little blog post on what happened and how I solved it. The reason for this is twofold: I…

    Read More...
    comments

    When is DTEXEC installed?

    by Koen Verbeeck on Feb 12, 2013 in categories Microsoft SQL Server, SSIS, Business Intelligence. Article views: 1229 views

    Which minimal components do you need to install to run SSIS packages on a server? Let's find out!

    Read More...
    comments

    This blog post describes how making the data flow buffers smaller might give a performance boost in some scenarios.

    Read More...
    comments

    Recently I had some issues using ANSI date literals in an SSIS OLE DB source query to an Oracle database.

    Read More...
    comments

    This is my contribution to T-SQL Tuesday #38: Standing Firm. I describe how I resolved an SSIS package performance issue.

    Read More...
    comments

    My SQL Server Days slides and demos

    by Koen Verbeeck on Dec 03, 2012 in categories Microsoft SQL Server, SSIS, Business Intelligence. Article views: 1378 views

    Two weeks ago I had the pleasure of giving a session on the Belgian SQL Server Days. My session was about SSIS and the new features of Change Data Capture (CDC). With new features I mean the new SSIS 2012 components made by Attunity who simplify the man…

    Read More...
    comments

    What’s the deal with Excel & SSIS?

    by Koen Verbeeck on Nov 27, 2012 in categories Microsoft SQL Server, SSIS, Business Intelligence. Article views: 6245 views

    When it comes to importing data from an Excel sheet with SSIS, Excel has quite a reputation. And not a terribly good one. Well deserved, to be honest, because numerous issues can rise when dealing with this piece of software. This blog post will deal wi…

    Read More...

    :: Next >>