SSIS Junkie : SQL Server Integration Services

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 Read More...

Posted 23 June 2009 23:16 by jamie.thomson | 2 Comments

Filed under: SQL Server Integration Services, SQL Server, SSIS, yahoo pipes, mashups, cloud computing, RESTful, data interoperability, gemini, data services, omniscope, qlikview

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 Read More...

Posted 29 May 2009 15:58 by jamie.thomson | 1 Comments

Filed under: SQL Server Integration Services, SSIS, Attunity

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 Read More...

Posted 27 May 2009 22:20 by jamie.thomson | 2 Comments

Filed under: SQL Server Integration Services, SQL Server, SSIS

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 Read More...

Posted 14 May 2009 13:39 by jamie.thomson | 1 Comments

Filed under: SQL Server Integration Services, SQL Server, SSIS, Azure Services Platform, windows azure, azure

SSIS Connect Digest 2009-05-10

I have noticed a few fellow SQL bloggers over on SQLBlog.com (most notably Aaron Bertrand ) have started to use their blog to draw attention to various submissions to Microsoft Connect that they believe to be worthy of attention. I think this a great Read More...

Posted 10 May 2009 20:54 by jamie.thomson | 3 Comments

Filed under: SQL Server Integration Services, SSIS, connect, feedback

SQLBits session feedback

I’ve just received my session feedback for my SSIS Nuggets Live session at SQLBits 4 which happened 7 days ago. I’m quite pleased with the marks I received but moreover I had some great written feedback as well, some of which I’ll take the opportunity Read More...

Posted 04 April 2009 17:06 by jamie.thomson | 1 Comments

Filed under: SQL Server Integration Services, SSIS, SQLBits, ssis nuggets live

SSIS Nuggets Live

I made my presenting debut yesterday at the SQL Bits 4 conference in Manchester (Europe’s largest ever SQL Server community event and its FREE) where I presented my "SSIS Nuggets Live” session. I had a few technical issues to begin with that meant Read More...

Posted 29 March 2009 16:18 by jamie.thomson | 2 Comments

Filed under: SQL Server Integration Services, SSIS, sql bits, ssis nuggets live

Attunity Oracle-CDC for SSIS

Attunity, the company that makes Microsoft’s SSIS connectors for Oracle and Teradata (read more about those at Connecting to Oracle just got a whole lot better ), have released (in beta) a new product called Attunity Oracle-CDC for SSIS . CDC stands for Read More...

Posted 12 February 2009 19:23 by jamie.thomson | 0 Comments

Filed under: SQL Server Integration Services, SSIS, Attunity

Generating XML Schema Documents using SSIS

Recently I was using Visual Studio 2005’s “Create Schema” feature to generate an XML Schema Document (XSD) from an XML file However I began to run into trouble with larger documents for which Visual Studio was throwing me back the following error: Read More...

Posted 15 December 2008 13:36 by jamie.thomson | 3 Comments

Filed under: SQL Server Integration Services, SSIS, pipeline, xml, xsd

Talking Pipelines : SSIS and Powershell

Of late I have been fiddling with Powershell quite a bit as I toil with SDS Shell . The simplicity with which one can build seemingly complex logic using Powershell really appeals to me and, inevitably, I have started to think about Powershell as a lightweight Read More...

Posted 09 December 2008 22:02 by jamie.thomson | 5 Comments

Filed under: SQL Server Integration Services, SSIS, powershell, pipeline

Making the case for expressions instead of parameterised SQL (and vice versa) : SSIS Nugget

[Although I colloquially refer to myself on this blog as “SSIS Junkie” it won’t have escaped the notice of regular readers that I haven’t been talking about SSIS much lately, in fact nothing of real substance in regard to SSIS has appeared here since Read More...

Posted 08 December 2008 13:35 by jamie.thomson | 1 Comments

Filed under: SQL Server Integration Services, SQL Server, SSIS, T-SQL, Expressions, Execute SQL Task, Nugget, sp_executesql

SSIS: What does the 1252 in (DT_STR, X, 1252) mean?

When casting to a non-unicode textual value (i.e. DT_STR) in SSIS you might often have seen something like the following: (DT_STR, 50, 1252) ( <expression> ) and wondered what on earth the 1252 was referring to. Well the SSIS documentation on MSDN Read More...

Posted 08 November 2008 10:10 by jamie.thomson | 3 Comments

Filed under: SQL Server Integration Services, SQL Server, SSIS, Expressions

SSIS Nugget: Nesting variables to calculate values

I was looking over a package today that a colleague had built and it contained the following code in a Script Task that was being used to return today’s day name: Public Sub Main() ' Dim sWeekday As String sWeekday = Now().DayOfWeek.ToString Dts.Variables( Read More...

Posted 24 October 2008 10:44 by jamie.thomson | 8 Comments

Filed under: SQL Server Integration Services, SQL Server, SSIS, Expressions, Variables, Nugget

SSIS: Consuming SOAP web services in SSIS2008 demo updated

Quick note. Today I updated the demo package that I built for my blog entry Consuming web services in SSIS 2008 , published in June 2007 (one of my busiest ever months ). The previous package was built on CTP3 of SSIS2008 and hence didn’t work on the Read More...

Posted 22 October 2008 20:02 by jamie.thomson | 0 Comments

Filed under: SQL Server Integration Services, SQL Server, SSIS, Web Services, sqL server 2008

SSIS and embedded SQL

I have been having an email back-and-forth with Jon Jaques which began with us discussing various limitations regarding BLOB support within the OLE DB Command and ended with Jon’s blog entry SSIS and the Perils of Embedded SQL where he discusses the drawbacks Read More...

Posted 17 October 2008 10:13 by jamie.thomson | 8 Comments

Filed under: SQL Server Integration Services, SQL Server, SSIS, Dataflow Task, Execute SQL Task

Welcome to blogs.conchango.com

SSIS Junkie

SQL Server Integration Services (RSS)