jetlounge

Browse by Tags

• FTP
• SQL Server
• SQL Server 2008
• Windows Server 2008

• FTP Task Blocked When Run in SQL Server Agent

  by David Leibowitz | September 24, 2009 | Comments: 95

  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 (on Windows Server 2008), follw instructions for... Read More... : SSIS, SQL Server 2008, Windows Server 2008, FTP

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

  by David Leibowitz | February 03, 2009 | Comments: 95

  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 180 characters in width) and parsing it to multiple... Read More... : SQL Server, SSIS

• SSIS Fails on SQL Server Destination Insert

  by David Leibowitz | May 08, 2008 | Comments: 95

  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 file mapping object 'Global\DTSQLIMPORT... Read More... : SSIS

• SSIS: Multiple Variable Error in Script Transformation Data Flow

  by David Leibowitz | March 27, 2008 | Comments: 95

  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 syntax for multiple variable listings in the Control... Read More... : SSIS

• Single Slash Not Allowed In SSIS Expressions

  by David Leibowitz | March 05, 2008 | Comments: 95

  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 + "\" + @User::FileName it just won't work. You'll... Read More... : SSIS

• Customizable SSIS Data Flow Transformations

  by David Leibowitz | December 17, 2007 | Comments: 95

  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 Split Derived Column The only other option is to... Read More... : SSIS