Browse by Tags

How to downgrade Integration Services 2008 packages to 2005

Courtesy of an unnamed source we have an app to downgrade a SSIS package from the 2008 version to 2005. Whilst it works with the common components any new components aren’t supported with the exception of the Lookup. 3rd party components are also not supported. It was gone through very limited testing...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Oct 21 2010
SSIS - XML Source Script

The XML Source in SSIS is great if you have a 1 to 1 mapping between entity and table. You can do more complex mapping but it becomes very messy and won't perform. What other options do you have? The challenge with XML processing is to not need a huge amount of memory. I remember using the early...

Posted to Simons SQL Blog (Weblog) by simonsabin on Thu, Mar 11 2010
XML Validation in SQL Server Intergration Services

I've been workig with XML in SQL Server Integration services this week and to say the XML task in SQL Server Integration services sucks is an understatement. Its buggy, the documentation is woefully inadequate in some cases wrong. I believe this was one of the first components written back for SQL...

Posted to Simons SQL Blog (Weblog) by simonsabin on Wed, Jan 20 2010
SQL Server 2008 - Killer features - MERGE and Table Valued Parameters

Table valued parameters along with MERGE are in my view the two killer features and the two that I believe will get most uptake when people start to use SQL 2008. Table valued parameters enable you to send a set of data as a single parameter to your code whether it be adhoc SQL, a stored procedure or...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Jun 17 2008
Installing Visual Studio 2008 and SQL Server 2005

If you are upgrading to Visual Studio 2008 then be careful with SQL Server. You may or may not know that the Business Intelligence Development Studio (BIDS) is a visual studio shell. If you don't have Visual Studio installed when you install SQL Server then it installs a version of Visual Studio...

Posted to Simons SQL Blog (Weblog) by simonsabin on Tue, Dec 4 2007
SSIS Pipeline - Katmai changes - Reusing data

Katmai increases the concurrency of SSIS packages by a change to the pipeline. In SQL 2005 a dataflow is split into sections, This is called the execution tree. Each section has the same buffer strucuture and the buffers are passed to each component in the section of the pipeline. A new secton starts...

Posted to Simons SQL Blog (Weblog) by simonsabin on Fri, Nov 16 2007
SSIS - 64 Bit woes

I am starting to regret installing 64 bit vista on my laptop, my woes are continuing as I found out today I can't debug script tasks. I do hope this is fixed in Katmai :) The full limitations, and there are a few, can be found here http://msdn2.microsoft.com/en-us/library/ms141766.aspx - var height...

Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Jul 23 2007
SSIS : Web Service task doesn't cut it but who cares

18 months ago I was trying to use the SSIS web service task for a number of purposes. The first was to integrate with SalesForce, the second was to manage reporting services. Unfortunately the Integration Services (SSIS) web service task doesn't work for these web services. On further investigation...

Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Jul 2 2007
SSIS - Sweet sight - Visual Studio 2005 Tools For Applications

I've metioned it before but the proof is in the pudding. On doing an install of Sql Server 2008 (Katmai) I was very pleased to see a step installing Visual Studio 2005 Tools for Applications Microsoft Visual Studio 2008 So why am I so excited, because it allows you to write in C# and also the IDE...

Posted to Simons SQL Blog (Weblog) by simonsabin on Mon, Jun 4 2007

Page 1 of 1 (9 items)