April 5th, 2012 
I have used both the Teradata and Oracle connectors in the past. While there are some “gotcha’s” (for example you must have SQL Enterprise), overall they provide the fastest possible way to extract data from either of those two sources. v2.0 brings support for SQL 2012 and the latest releases of Teradata and Oracle, as [...]
Posts Tagged ‘SSIS’
Integration Services EzAPI Updated to Support SQL 2012
Just got word from Matt Masson on the SSIS development team that EzAPI has been updated to support SQL 2012. This is greate news! I have been using EzAPI for the last couple of months and I am very satisfied with it as an API for SSIS that allows me to focus on solving the [...]
Posted in Development, Integration Services, SQL Server 
Tags: Development, EzAPI, SQL Server, SSIS 
Comments OffEditing Existing SSIS Package via EzAPI or Standard SSIS API Doesn’t Update Layout in BIDS
As part of a project I am working on that requires me to programmatically alter existing packages, I ran into an annoyance (bug?) in SSIS that makes it hard to open packages after altering them. The Problem During an exchange on Codeplex forums with Matt Masson from the SSIS team, he summarized the workflow as [...]
Posted in Development, Integration Services, SQL Server Tags: .NET, BIDS, C#, EzAPI, SSIS Comments OffDeveloping Microsoft SSIS packages programmatically with EZAPI
I recently started working on a task that required me to dig into creating SQL Server Integration Services packages programmatically. There is not a lot of info out there on this, so thought it might be beneficial for me to blog a bit as I go in case other benefit from this. Relatively early on [...]
Posted in Development, Integration Services, SQL Server Tags: Development, EzAPI, SQL Server, SSIS Comments OffTable Size History
When maintaining a data warehouse, it is import understand the size and disk requirements of your tables over time. My current client has asked that I generate a report showing table disk usage over time, so that we can predict table growth. I was looking around and found the procedure sp_spaceused. This returns the row [...]
Posted in SQL Tags: Dimesion, Disk Usage, Fact, sp_spaceused, SQL, SQL 2008, SQLServer, SQLServerPedia Syndication, SSIS, SSRS, T-SQL, Table No Comments »Strange SSIS Error for Configurations on Configuration Table Data Type Change from NVARCHAR to VARCHAR
Recently I got a strange SSIS error. The error was for each of the package configurations I had in place that pulled their values from the SSIS Config table. The ones that used the .dtsConfig file or environment variables were not throwing errors. Here is the exact error: Warning: The package path referenced an object [...]
Presenting @ Atlanta Microsoft BI user group
I will be presenting at the next Atlanta Microsoft BI user group. Monday, July 25th, 2011. http://atlantabi.sqlpass.org/ Topic: SSIS Logging and Auditing Framework Level: Beginer / Intermediate Meeting Place Matrix Resources 115 Perimeter Center Place Suite 250 (South Terraces Building) Atlanta, GA 30346 Overview: Proper logging in your SSIS packages can help save hours in [...]
Avoiding dups when querying sysssislog
Last year I blogged about Avoiding dups in Parent Packages, when using custom logging. Todd McDermind has a good post on how to query the sysssislog table, if you are using the built in SQL SSIS logging. http://toddmcdermid.blogspot.com/2011/04/transforming-ssis-sysssislog-entries.html
Parse XML in SSIS
One of the built in data sources in in SSIS is an XML document. I started writing a package to pull data from XML stored in a SQL table. I noticed that there were several little gotchas that I had to work around to get the data the way I wanted. The XML file can [...]
Posted in SQLServerPedia Syndication, SSIS Tags: Microsoft, SQL, SQL 2008, SQLServerPedia Syndication, SSIS, XML, XML Source No Comments »Looping through files on an FTP server
I have always know that that SSIS has an FTP control Flow task, but I have never tried to use. Turn out that the task is fairly limited and can be a pain to work with. I am attempting to get a list of all files, in a folder, on an FTP server. The FTP [...]
Posted in SQLServerPedia Syndication, SSIS Tags: FTP, Microsoft, SQL, SQL 2008, SQLServerPedia Syndication, SSIS 1 Comment »