Browse by Tags

FTP Task Blocked When Run in SQL Server Agent

September 24, 2009

Got the connectionstring and credentials down pat, and no error message when executing a SQL Server Agent Job that included an FTP task. It just sat there, and sat there. Looked and smelled like a firewall issue. And it was. Didn't occur in Visual Studio, just when running in automated mode. To fix...

FIX: SSIS Script Component Error "The value is too large to fit in the column data area of the buffer"

February 03, 2009

Received an error in an SSIS Package with a Script Transformation. The error was "The value is too large to fit in the column data area of the buffer." and Microsoft.SqlServer.Dts.Pipeline.DoesNotFitBufferException. The Script Component in the Data Flow was taking a large column of data (about...

SSIS Fails on SQL Server Destination Insert

May 08, 2008

Receiving the following error in SQL Server Integration Services? Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: " Could not bulk load because...

SSIS: Multiple Variable Error in Script Transformation Data Flow

March 27, 2008

When using the Script Transformation Editor in SQL Integration Services, you might want to pass in more than 1 variable to your script. Properties exist for ReadOnlyVariables and ReadWriteVariables, much like the Script Task Control Flow component. But there is one BIG difference. You may be used to...

Single Slash Not Allowed In SSIS Expressions

March 05, 2008

Expressions in SQL Server Integrations Services 2005 are extremely powerful. You might use them to dynamically concantenate strings, for example, when you want to write, import or export to various files at run time. But try as you might to use an algorithm like: @User::FolderPath + "\" + ...

Customizable SSIS Data Flow Transformations

December 17, 2007

Expression properties can be used to provide a great deal of flexibility in runtime changes to SQL Server Integration Services pacakges. Unfortunately, their usage in Data Flow Transformations is limited. The only Data Flow tasks in SSIS that can be modified using expression properties are: Conditional...