jetlounge

Browse by Tags

• SSIS Fails on SQL Server Destination Insert

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

  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: 42

  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: 42

  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: 42

  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