Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SSIS   (RSS)
Sunday, October 19, 2008 12:33 AM

Does buffer.NextRow() skips the first row in a buffer?

I got a follow up question to my old post regarding enumerating rows in SSIS buffer , that suggested using following code to process rows in custom SSIS transform: while (buffer.NextRow()) {   // do something with the row } Here is the question:
Posted by michen | 1 Comments
Filed under: ,
Saturday, June 07, 2008 1:37 AM

Lookup multiple rows?

Can SSIS Lookup do what this user wants it to do? I have a problem with a lookup output, I get this warning: The Lookup transformation encountered duplicate reference key values when caching reference data. I know what it is, but I don't like to avoid
Posted by michen | 3 Comments
Filed under: ,
Friday, March 14, 2008 3:45 PM

Configuring .NET for running SSIS packages from custom applications

If you execute SSIS packages from custom applications, you own the application and thus you are responsible for configuring .NET runtime properly to get the maximum performance. .NET configuration is usually performed using .exe.config files, so it is a just matter of providing good config file. How do you know what is good? The simplest way is to look at the config file that SSIS provides, and copy the appropriate settings. Now let's take a look at DTExec.exe.config provided with SQL Server 2008 and discuss the choices made by SSIS team. ...
Posted by michen | 1 Comments
Filed under: ,
Friday, February 01, 2008 12:25 PM

SSIS event handler threading

If the package has an event handler that can handle multiple events, and these events fire at about the same time. What happens?
Posted by michen | 0 Comments
Filed under:
Tuesday, December 04, 2007 10:42 PM

SQL 2008 & VS 2008

Currently SQL Business Intelligence Development Studio (BIDS) and all the project types (AS, IS and RS) live in Visual Studio 2005. So don't try to open a solution that contains IS project in VS 2008 yet. What about final SQL 2008 - now that Visual Studio 2008 is released - what are the plans for BIDS and support of BI projects VS 2008?
Posted by michen | 5 Comments
Filed under: ,
Wednesday, November 07, 2007 1:48 AM

Deploying packages

How can one deploy packages programmatically? Here is the original question - Is it possible to deploy a package programmatically? We have an application which has a work flow for approval of object. If the object (ssis package) is approved by the concerned
Posted by michen | 0 Comments
Filed under:
Friday, August 24, 2007 5:57 PM

Don't run SSIS package using SQL/CLR

A recent commenter suggested running SSIS using SQL/CLR: Just an idea on how to do this that may be a bit easier than any of the methods covered. IF you were to write a CLR procedure which accepts a string as its parameter. The string passed in would
Posted by michen | 0 Comments
Filed under: , ,
Monday, June 25, 2007 9:28 PM

Do I have to be admin?

Often, I see people reporting "zzz fails if I'm not admin". Do I have to be machine admin to use SSIS? Well, absolutely no. Most SSIS tasks can be performed without being admin at all. Actually, I develop on Vista machine and I very rarely need to elevate
Posted by michen | 1 Comments
Filed under: ,
Tuesday, June 12, 2007 7:28 PM

SSIS Backpressure Mechanism

One of the mechanisms that SSIS data flow engine utilizes to achieve high performance is “back pressure”. Let’s consider a simple package with a source and destination. What happens if the source is fast and destination is slow? Say source is huge local
Posted by michen | 0 Comments
Filed under: , ,
Monday, June 11, 2007 12:00 AM

Katmai SSIS data flow task improvements

With first Katmai (SQL Server 2008) CTP out, I think it is time to blog about some performance and scalability improvements in this release...
Posted by michen | 4 Comments
Filed under: , ,
Tuesday, April 24, 2007 11:40 AM

SqlPerf blog on SSIS performance

Runying Mao and Len Wyatt did a great study of SSIS performance, and posted some results: Getting Optimal Performance with Integration Services Lookups http://blogs.msdn.com/sqlperf/archive/2007/04/24/getting-optimal-performance-with-integration-services-lookups.aspx
Posted by michen | 0 Comments
Filed under: , ,
Sunday, April 22, 2007 2:06 AM

COM references within an SSIS Script Component

The SSIS Script Task and Script Component editors don't provide functionality (available in full VS) to add a reference to unmanaged COM components. Can this be done at all? Well, yes, although lack of GUI option in VSA (which SSIS uses for editing and
Posted by michen | 2 Comments
Filed under: ,
Thursday, April 19, 2007 3:33 PM

64-bit references within an SSIS Script Component

I was forwarded a question about SSIS Script Component on 64-bit, I think the answer may benefit others as well: Currently we are referencing a 32-bit third party component in a script component and running the SSIS package in 32 bit mode on a X64 bit
Posted by michen | 1 Comments
Filed under: , ,
Thursday, March 29, 2007 5:18 PM

Using SSIS object model from C++

All the samples in MSDN show how use SSIS API from C# or VB.NET code. Is it possible to do this from C++ code? The answer is yes, if you know COM it should be quite easy for you, and the COM API is very close to .NET API (I think .NET API is nicer due
Posted by michen | 1 Comments
Filed under: ,
Thursday, March 22, 2007 3:27 PM

Running SSIS package programmatically

I got several questions asking what is the best way to run SSIS packages programmatically. One question is about running SSIS from a .NET 1.1 application (SSIS uses .NET 2.0). Another about running package remotely "Do I really have to write an ASP.net
Posted by michen | 22 Comments
Filed under: ,
More Posts Next page »
 
Page view tracker