in

jetlounge

the minty fresh blog that whitens your teeth!
All Tags » SSIS (RSS)

Browse by Tags

Sorry, but there are no more tags available to filter with.

    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...
Page 1 of 1 (4 items)


Powered by Community Server (Non-Commercial Edition), by Telligent Systems