Task Factory Release Notes

Download: For more information about Task Factory pricing or downloading a trial, see the Task Factory product page.

v2018

Version 2018.3.3 [August 9, 2018]

New Features:

  • New 1232: Task Factory now supports installing on Server Core installations
  • New 1394: Oracle Upsert Destination includes the ability to define temp tables
  • New 4030: REST Source connection manager now includes support for Survey Monkey configuration files
  • New 8242: Amazon S3 Task
    • Manage your S3 environment using the S3 Task
  • New 11962: Unpack Data Transform now supports XML unpacking without needing a root xpath query
  • New 11992: Rest Source now supports OAuth2 certificate authentication
  • New 13928: Rest Task
    • Pull results from an endpoint and store it within a variable for pre-processing data
  • New 15200: Rest Source and Unpack Data Transform now allows empty strings to be used within JSON token paths
  • New 15652: REST connection manager now allows specifying the security protocol
  • New 16131: ADF Licensing for TF
  • New 16289: REST Source and Destination can now return header values within the Data Flow
  • New 16300: Rest Source can now ignore certification validation errors during authentication
  • New 17204: Allow REST JSON parser to ignore formatting on strings that contain dates
  • New 17238: Azure Storage Source
    • Supports Blob, Table and File modes for Azure Storage
  • New 17239: Azure Storage Destination
    • Supports Blob, Table and File modes for Azure Storage
  • New 17585: Address Verification improvements
    • Improved encryption security
    • Change the name of the "Invalid Address Output" to "Unverified Output" to limit confusion
    • Update the Response Status table to include missing response codes
  • New 18136: Amazon S3 Source
    • Extract data from S3 using the Task Factory Amazon S3 Source component
  • New 18137: Amazon S3 Destination
    • Load data to S3 using the Task Factory Amazon S3 Destination component

Updated Features:

  • Update 16287: Improved documentation within Compression task to include descriptions of which usage types are allowed for each mode
  • Update 17020: Improved documentation for the Advanced Execute Package task
  • Update 17076: Advanced Email and SMS provider list
  • Update 17408: Secure FTP's 'Stop package on failure?' property is now set to 'True' by default
  • Update 17439: Columns added to Rest Source's output should include incremental numbers to avoid same-name columns
  • Update 17607: Update to Task Factory's Software Requirements
  • Update 17729: Improved documentation for licensing requirements on clustered servers

Fixes:

  • Fix 1186: Advanced Aggregate Transform is not passing Sort properties through
  • Fix 4003: Advanced Aggregator Transform ignores the group by command in provided package
  • Fix 16044: Salesforce Source returns NULL values when subquery is used to define a column in SOQL query
  • Fix 16063: Replace Unwanted Character Transform not escaping hyphens correctly
  • Fix 16320: Marketo Source concatenates the access_token in the URL
  • Fix 16322: SalesForce Source incorrectly previews data within a dot notation query
  • Fix 16341: Oracle Upsert cannot create temp destination tables when using row flag compare
  • Fix 17018: Excel Source throws an "Index was outside the bounds of the array" error for a cell that contains 0.0%
  • Fix 17023: Email Source returns NULL values from Exchange Mail server
  • Fix 17069: When executing a Task Factory package from a LegiTest Group on a machine without a Task Factory license, the package throws a "Task Factory is not regiserted on this machine" error
  • Fix 17241: When the Data Cleansing Transform input's NULL values into a Date column, the NULL value is unable to be input into the SQL Table
  • Fix 17243: Dimension Merge's output column selection isn't displaying any of the columns
  • Fix 17475: Advanced Lookup throws "System.FormatException: Input string was not in a correct format"
  • Fix 17481: Dimension Merge transform that uses a composite key with bit values throws "Duplicate Business Key in Source_System: NullKeyStruct" error
  • Fix 17482: The Output Column CarrierRouteRateSortIndicator from the Address Verification Transform outputs data that differs from the documentation
  • Fix 17491: Filter Rows transform's expression causes data corruption within Excel Destination
  • Fix 17610: Dynamics CRM Source creates endless loop if the batch size is smaller than the row count received
  • Fix 17615: Upsert Destination freezes when handling the properties for tables containing large amounts of columns
  • Fix 17647: When decompressing a GZip file to a folder destination, the Compression task throws "Could not decompress" error
  • Fix 17731: Excel Source not reading certain formats
  • Fix 17871: When attempting to view the metadata for the LoginHistory object, Salesforce Source throws an "Object Reference" error

Version 2018.2.3 [April 27, 2018]

Important:  The 2018.2.3 release for Task Factory will be the last supported release for SQL Server 2008 and 2008 R2.

New Features:

  • New 16092: Improved the Unpacked Transform's ability to handle errors when NULL or empty data is passed into it
  • New 16265: Added a select all columns option to the Error Output Description.

Updated Features:

  • Update 16064: SFTP Task has been updated to the latest version of ChilKat

Fixes:

  • Fix 15093: LinkedIn Social OAuth Connection Manager is out of date
  • Fix 15696: Advanced Conditional Split Transform does not save column description
  • Fix 15705: Advanced Email and SMS task is truncating emails with top-level domains longer than 4 characters
  • Fix 15718: Fact Table Destination fails when mapping multiple destination columns to single lookup
  • Fix 15765: Salesforce Destination throws "component has detected potential metadata corruption" when upgrading from BIDS 2008 to SSDT 2017
  • Fix 16007: Task Factory does not install within the correct directories for Visual Studio / SSDT 2017
  • Fix 16010: Unpack Data Transform throws HRESULT: 0xC00470B2 error when selected a column containing packed data
  • Fix 16038: Unpacker converts values to Date format before setting to a string data type
  • Fix 16046: Password fields in legacy Task Factory connection managers cause Visual Studio to freeze before resolving cursor in password field
  • Fix 16050: Advanced Email and SMS task doesn't save the connection manager information when renamed
  • Fix 16078: LinkedIn / REST OAuth 2.0 connection manager proxy information is not copied to the Get Token form
  • Fix 16080: NULL Handler Transform does not allow XML as a replacement value
  • Fix 16238: Dynamics Destination does not display an error when there are no column mappings
  • Fix 16271: SharePoint Source and Destination throws Object Reference Error when selecting a list before a connection manager
  • Fix 16272: Fact Destination closes when clicking the destination column mappings before a connection manager
  • Fix 16274: Marketo Destination throws "Object Reference Error" when selecting a destination object before a connection manager
  • Fix 16286: Pagination Settings continue to make calls to endpoint when Last Page Detection is set to 'End when result set contains zero rows' and no rows are returned to REST Source
  • Fix 16292: LinkedIn Source's "View Api Document" link no longer directs users to an invalid webpage.
  • Fix 16308: Fact Table Destination throws an ArgumentException error when using a variable to do a lookup more than once
  • Fix 16417: Packdata Transform inconsistent output between DT_TEXT and DT_NTEXT
  • Fix 16972: SharePoint Source throws an "Unable to cast object" error when more than one filter is applied
  • Fix 16988: Data Validation Transform throws Object Reference Error when opening the component
  • Fix 17067: Hash Transform does not keep the algorithm when adding a new Output Column or clicking OK

Version 2018.1.4 [February 8, 2018]

New Features:

  • New 11892: SharePoint Destination now auto maps columns
  • New 13965: REST Destination can now send a file as part of the POST Body

Updated Features:

  • Update 13975: Help documentation now includes detailed list of Task Factory related help videos

Fixes:

  • Fix 12504: Sharepoint Source Returning NULL for Column
  • Fix 12517: SharePoint Source doesn't update column Description metadata when connection manager is updated
  • Fix 12569: Replace Unwanted Characters 'Remove unprintable characters' Action strips valid characters from text
  • Fix 13956: TF Advanced Lookup Transform will not accept a Boolean Data Type
  • Fix 13971: Advance Cleansing Task Transforming Names Incorrectly
  • Fix 13980: File Gateway Source - not reporting end of rowset
  • Fix 13984: XML Output Destination creates empty elements
  • Fix 13985: Upsert Destination cannot compare timestamps without updating destination column
  • Fix 14003: Excel Source Serialization Error when Sheet Name is not found
  • Fix 14022: Excel Source Component - Does not allow you to return one row.
  • Fix 14030: Sharepoint Source pulling wrong column name resulting in NULL values
  • Fix 14455: Add reserved-word Date header to rest connections
  • Fix 14573: PGP Task displays password in plain text within the properties window
  • Fix 14574: Fact Table Destination outputs NULL values when join conditions use Date data types
  • Fix 14581: REST Oauth tokens can expire during long running operations
  • Fix 14586: Upsert Task errors when attempting to update / insert to a table set to T-SQL Always Encrypted
  • Fix 14592: Excel Destination may corrupt the file when writing to pre-existing documents
  • Fix 14593: Pack Data Transform does not remove mapping lines within UI when using 'Remove Mapping' option
  • Fix 14597: Pack Data 'Generate Template' does not properly generate Parent to child relationships in .Liquid For Loop
  • Fix 14609: Pack Data Transform passes NULL values when packing sub-level inputs
  • Fix 14646: SFTP Task fails when running two SFTP tasks in parallel, and "Reuse Connection" is enabled within the connection manager
  • Fix 14649: When special characters (#00,<) are included, a SharePoint Source throws "an error occurred while attempting to parse"
  • Fix 14653: CRM Destination throws Object Reference error when writing to entity referenced upstream in data flow
  • Fix 14656: Excel Source defaults back to original Column Names after every change within the component
  • Fix 15126: Excel Source automatically converts date time columns set to 24 hour format to 12 hour format
  • Fix 15127: Move or Delete Email will not fail when targeting a non-existent folder
  • Fix 15128: Fact Table Destination throws error when using a Case Sensitive server and a Case Sensitive database
  • Fix 15164: XML Output Destination does not always include specific attributes in the XML output
  • Fix 15608: Newer TF components do not display the version number in the title bar
  • Fix 15630: REST Source uses TLS 1.2 to "Preview Data" but uses TLS 1.0 when executing the package.
  • Fix 15632: Address Verification Transform throws Exception from HRESULT: 0xC0010009 error when attempting to replace a column
  • Fix 15676: Dimension Merge SCD crashes Visual Studio when current row value is blank on the SCD2 Date Handling page
v2017

Version 2017.4.5 [November 6, 2017]

New Features:

  • New 7365: REST Source can handle paging between web calls when page number and total pages are passed in
  • New 10270: Oracle Upsert Destination now includes Refresh Metadata button
  • New 10377: Pack Data transform now warns user when a column exists within the template that does not exist in the input
  • New 11953: Salesforce Connection Manager now includes option to attempt retries on failures to connect or execute
  • New 12006: Upsert Destination's error output now provides higher level of detail
  • New 13042: Salesforce Destination now includes ability to set Batch or Bulk Size
  • New 13044: XML Destination now includes option to not write an empty documentation when no rows are provided
  • New 13059: XML Generator transform now includes UTF- NO BOM Encoding option
  • New 13536: Task Factory is now compatible with SSDT for Visual Studio 2017

Updated Features:

  • Update 9143: Dimension Merge Slowly Changing Dimension transform now includes option to ignore changes to SCD0 columns
  • Update 13519: REST Source Header now supports the same variable syntax as other fields in REST Source
    • The REST Source Header section now accepts Namespace::VariableName as the syntax for replacement
  • Update 11979: Online help documentation now includes a rolling list of release notes that include all product release notes within a single file

Fixes:

  • Fix 9814: Column names insert at end of expression when adding from main page of Advanced Derived Column
  • Fix 11024: Data Cleansing transform throws "Datatype mismatch between [Date] and output date format parameter [MMddyyyy]" error when converting from DT_DBTIMESTAMP to MMddyyyy
  • Fix 12018: Expression engine does not correctly format the Day_Of_Week, GetDiskFreeSpace, GetDiskSize, Log10, SetDatePart and Sleep functions
  • Fix 12039: The Test Expression button is disabled when using Expression task
  • Fix 12477: Packages containing Advanced Lookup Cache connection managers fail to deploy to the SSIS Catalog
  • Fix 12481: Social Media connection manager fails to connect to Facebook with "Could not find access_token" error
  • Fix 12512: Replace Unwanted Characters is not using Unicode values correctly
  • Fix 12530: REST Source hides any errors that are thrown if no error output is attached
  • Fix 12570: File Gateway Source causes devenv.exe to hang and build memory pressure when selecting attached file
  • Fix 12571: File Gateway Source does not reinitialize metadata properly when changing files
  • Fix 12573: Dynamic CRM Destination can throw "The request channel timed out while waiting for a reply" when executing
  • Fix 13058: XML Generator Transform drops lowest level of elements when closed and re-opened multiple times
  • Fix 13097: SalesForce Destination does not use proxy settings during post execute phase
  • Fix 13434: DT_DBTIMESTAMP2 variables not included as options for Auditing Values
  • Fix 13488: Pack Data Transform does not retrieve existing values correctly and replaces them with NULL values
  • Fix 13489: During execution, File Gateway source throws "File Validation Failed When Checking File Properties" error when validating a file with size between 1 and 1023 bytes
  • Fix 13506: REST Destination not associating lineage ID's correctly when square brackets are present in POST Body
  • Fix 13507: Upsert Destination's Refresh Metadata button does not work when on the update method tab
  • Fix 13509: REST Source OAuth Connection Manager fails to authenticate if no token is specified
  • Fix 13512: XML Output Destination's metadata does not re-initializing after columns are removed
  • Fix 13524: Oracle Upsert doesn't find unique indexes
  • Fix 13535: Excel Source throws "IsolatedStorageException" error when executed from a SQL Server Agent Job
  • Fix 13929: Parameters defined within a REST OAuth2 configuration file are not replacing all fields within the REST OAuth2 connection manager
  • Fix 13951: Expressions Editor is not accessible from within the SFTP task
  • Fix 13991: Advanced Aggregate transform populates valid data with NULLs

Version 2017.3.3 [August 7, 2017]

New Features:

  • New 8765: Move the preview for dynamics source to a pop up
  • New 10293: Rest Source and Destination can now pass cookies during authentication
  • New 10342: Dimension Merge SCD now includes sorting choices for GUIDs
  • New 10390: Included the ability to preview Owner object columns in Salesforce Source UI
  • New 10914: Advanced Execute Package task can now use project level parameters when in Project Deployment Model
  • New 11025: Dynamics CRM Source can now extract the data from a view on an entity
  • New 11039: Rest Source and Destination now support OAUth1 and Basic rest connections
  • New 11098: XML Generation Transform can now automap columns
  • New 11157: Within SFTP task, changing 'Stop package on failure?' now sets the 'FailPackageOnFailure' property to the same value
  • New 11184: Added USPS Address Verification Component
  • New 11643: Allow accessing Memory Optimized tables in Upsert
  • New 11644: Check against zombie transactions
  • New 11650: Rest Source Component Headers Variable/Parameter Syntax
  • New 11974: REST Connection now allows selecting of REST config file
  • New 11975: REST Config files now include header section
  • New 11987: SMTP Connection Manager can now reuse same connection across the SSIS package execution
  • New 12004: Marketo Destination now includes the ability to add custom parameters
  • New 12401: Task Factory SSIS 2017 support
  • New 2846: Licensing now works within environments that use FIPS compliant algorithms for encryption

Updated Features:

  • Update 11964: Pack - Unpack Columns transform now supports removing byte order marks in xml unpack
  • Update 11976: REST Destination "Test API" button now includes warning when clicked
    • Including a warning helps prevent unintentional REST calls

Fixes:

  • Fix 1605: BI xPress Auditing Framework within Workbench throws "System.Exception" errors when being applied to packages containing Task Factory Components
  • Fix 4407: Dimension Merge SCD transform throws "Array dimensions exceeded supported range error" when initial load of 200+ million rows
  • Fix 10278: Dimension Merge SCD Incorrectly Sending Data Down New Path When SCD2 date is invalid
  • Fix 10812: When in Project Deployment mode, child packages executed by the Advanced Execute Package Task do not use any of their referenced project parameters during execution
  • Fix 11033: XML Generator throws an "item with same key" error when inside a for-each loop
  • Fix 11657: Fact Table Destination Lookups are re-written when opened in 2017.1 versions
  • Fix 11659: Email Source FilterDelimiter property does not work
  • Fix 11664: Upsert Destination throwing Object Reference Error for SQL_Variant data type
  • Fix 11667: Excel Source sometimes throws "Object Reference" error when executing
  • Fix 11672: Advanced Derived Column shows invalid expressions as valid
  • Fix 11890: Excel Source is not able to read formatted rows with a common formatid
  • Fix 11891: Fact Table Destination fails to loads when objects are missing
  • Fix 11960: Pack - Unpack Columns transform throws 'Column must have a code page greater than zero' error when new columns are added
  • Fix 11961: Dynamics CRM Source takes a long time to respond when connecting to objects with high number of activity parties
  • Fix 12014: Excel Source does not parse worksheet properly where row indexes are skipped
  • Fix 12036: Salesforce Source incorrectly maps columns in Error Output after truncation occurs
  • Fix 12476: Unpack Columns transform does not parse columns with DT_NTEXT or DT_TEXT data types
  • Fix 12403: Denied Access to registry key "HKEY_CURRENT_USER"

Version 2017.2.3 [May 1, 2017]

New Features:

  • New 1898: Rest Destination
  • Rest Destination can be used to send data to a Rest API and read the responses back into an output.
  • New 10245: Task Factory UI's compatible with custom scaling in Windows Display Settings
    • Create ability for all Task Factory task/component UI's to work with scaling options in Windows 10 other than 100%. When set to 125% or higher, UI do not adjust, and configurations can not be seen in certain screens. Image of Expression Editor attached to display this behavior. Issue is also known to affect the column mappings tab in the Dim Merge SCD component as well.
  • New 10288: Allow renaming of files in Remote Directory path when uploading to SFTP
  • New 10389: Added compatibility for string response based on RegEx to REST Source
    • Add functionality for Rest Source to handle alternate response from REST APIs, such as string
  • New 10790: E-mail connection manager now minimizes the number of concurrent connections needed during execution

Updated Features:

  • Update 8692: REST Source & Destination now includes an auto retry connection functionality
  • Update 9168: Rest Source now includes an error response handler
  • Update 9175: SalesForce Destination now includes ability to deselect an Assignment Rule
  • Update 9812: Help documentation for Advance Execute Process now better explains the difference between "In Process" and "Out of Process"
  • Update 9825: Rest Connections now uses .NET WebRequest if .NET 4.5 is installed on the machine
  • Update 9829: SalesForce Source now allows the user to refresh metadata when a subquery is present within a where statement
  • Update 9831: Hash Transform now defaults to '|' as the column separator
  • Update 9837: OAuth2 Rest Connection now defaults to Post
  • Update 9853: Help documentation for SalesForce Destination now better describes its Bulk processing option
  • Update 10359: Azure ML Batch Task help page to reflect the necessary inclusion of /jobs appended at the end of the post request
  • Update 10364: Help documentation for SharePoint Destination now includes details on Download Attachments
  • Update 10365: Help documentation for SalesForce Source no includes information on variable usage
  • Update 10958: SharePoint Destination now includes additional date data type compatibility
    • DT_DBDATE
    • DT_DATE
    • DT_DBTIMESTAMP2

Fixes:

  • Fix 4074: "Replace Null Text Values" option is re-selected when address parse is closed
  • Fix 7874: Fixed SFTP connection where TLS 1.2 is not enabled on SSH servers
  • Fix 9140: In Upsert mode, SalesForce Destination loses External ID column when refreshing columns
  • Fix 9141: UPSERT with AZURE orphans temp tables after execution completes
  • Fix 9152: Adding auditing framework removes the mappings from the XML Output Destination
  • Fix 9158: Salesforce Destination does not update values in SF Object when passing an empty string
  • Fix 9198: Add option for bankers rounding within the expression engine
  • Fix 9204: Pack Data Transform does not recognize NULL values for IF statements in Liquid
  • Fix 9214: XML Output Destination fails to show validation errors when opening invalid XSD
  • Fix 9215: Excel files throw corrupted data error when Excel Destination creates new worksheet
  • Fix 9216: Rest Source throws 'Failed to verify exchange signature' error
  • Fix 9250: Excel Source does not capture data from Named Ranges not beginning on Row 1 of worksheet
  • Fix 9687: The data type of output columns on the TF Dynamics CRM Destination cannot be changed, except for DT_WSTR and DT_NTEXT columns.
  • Fix 9764: Salesforce Connection Manager does not allow for dynamic variable usage
  • Fix 9810: Unpack Data Transform throws a "could not cast object type 'System.Xml.Linq.XElement' to type 'System.XML.Linq.XAttribute'" error when using attribute based queries
  • Fix 9816: Marketo Destination throws an "Object Reference" error when attempting to access the destination object
  • Fix 9823: Null Handler Transform populates the column list when setting "NULL or Blank Values" to a user defined value with column parameter
  • Fix 9834: TF Upsert Destination Does Not Fail On Table Constraint Violation
  • Fix 9836: Excel Source throw an "Object Reference" error and inserts an empty string when the native query returns 'null'
  • Fix 9840: Added option for Guid sorting to fix XML Output Destination skipping elements in multiple entity datasets when guids are used for keys
  • Fix 9844: XML Output Destination does not follow XSD and write empty elements when there is an empty string or null value in the data set
  • Fix 9855: Excel Source does not refresh meta when switching from Raw to Formatted output
  • Fix 9862: Secure FTP now disables Local File and Directory Settings when using the 'Check if file exists on server' option
  • Fix 10202: Fix reinitialize metadata for pack data transform
  • Fix 10283: Making column changes in the File Format tab refreshes the columns in the column tab
  • Fix 10284: TF Basic Rest Connection does not use Headers with "Test Connection" on Endpoint tab
  • Fix 10287: Dimension Merge Slowly Changing Dimension experiences performance degradation
  • Fix 10310: Salesforce Destination does not carry Assignment Rules when applied in Bulk / Bulk Zip modes
  • Fix 10320: Excel Destination Object disconnect or does not exist
  • Fix 10321: Marketo Destination - Object Reference when populating Destination Object list when proxy is enabled but not connected
  • Fix 10323: Marketo Destination - filterType not specified Error when selecting custom Marketo objects
  • Fix 10324: TaskFactory FileCombinePath expression returns <NULL>
  • Fix 10344: Excel Source throws Unable to determine the identity of domain
  • Fix 10354: Large record sets cause memory pressure
  • Fix 10357: TF SharePoint Source throws System.ArgumentException: Item has already been added. Key in dictionary error
  • Fix 10915: Data Validation Expression Tester Does Not Leverage Transform Options
  • Fix 10920: AesEncrypt expression throws Unable to cast object of type 'System.Byte[]' to type 'System.IConvertible' with provided package
  • Fix 10951: Cannot open TF upsert UI
  • Fix 10959: Creating a new column in TF Advanced Derived Column throws Exception from HRESULT: 0xC0204019
  • Fix 11159: EndsWith Operator in the Advanced Lookup Cache Transform does not work properly
  • Fix 11160: Filter Operators for Advanced Lookup Transform are not functioning properly
  • Fix 11161: Using IsContainedIn filter in Advanced Cache Lookup Connection Manager breaks the component

Version 2017.1.3 [February 2, 2017]

New Features:

  • New 4702: sFTP Task can now remotely rename a file
  • New 7797: Excel Power Refresh now includes an execution timeout option
    • Note:  this will not stop an execution when a Connection Login dialog is prompted by Excel.
  • New 7799: REST Source now supports including the HTTP status information as an output
    • REST Source now includes a new output that will be filled with a single row when anything other than a status of 200 is returned from the rest server
    • This output contains the status code (200, 400, 404, 500, etc), the status description and any data returned from the server
  • New 7826: Added support for wildcards (*) in JSON queries
  • New 7930: Task Factory help documentation now includes sample Rest Source configurations files for TFS / VSTS
  • New 7960: REST Connection and Source now supports the use of configuration files
  • New 8308: SharePoint Source now allows the use of custom Caml & Query options
  • New 8614: OAuth2 token getter now includes proxy and headers

Updated Features:

  • Update 4691: Dynamics CRM Source now includes change data capture (Get Changes) functionality
    • Added an option to the Dynamics CRM Source that allows the use of the Get Changes functionality added in the 2015 Update 1 release of Dynamics CRM.
  • Update 8739: Improved product version logging at start up

Fixes:

  • Fix 4727: Advanced Derived Column is unable to convert string values to GUIDs
  • Fix 4728: Salesforce Source consumes more memory than previous versions on execution
  • Fix 7865: Help links within some Task Factory components point to incorrect locations
  • Fix 7880: XML Output Destination is not mapping unbounded recurring elements correctly
  • Fix 7923: SharePoint Documents unable to upload files over 25 MB
  • Fix 7926: Unpack Data is dropping Data Flow expressions after transform has been edited
  • Fix 7928: In Visual Studio 2015, Expression Engine throws an object reference error when target SQL Server Version 2014 or below
  • Fix 7931: Dimension Merge SCD is dropping records when memory optimized mode is enabled
  • Fix 8243: 'Content not allowed in prolog' error thrown upon SalesForce Source execution
  • Fix 8322: 'Create new table' option not available when using a database with no tables in Upsert Destination
  • Fix 8332: Parsing error thrown with dt_dbtime and dt_dbtime2 datatypes in SSIS 2008
  • Fix 8689: SalesForce Destination now uses proxy settings when using bulk process mode
  • Fix 8695: Unpack and Rest Source does not return child elements for an XML based column
  • Fix 8709: XML Destination writes elements out of order when writing a full element before a grouping occurs
  • Fix 8763: Upsert Destination does not fail when a DB constraint is violated and fail component option is set
  • Fix 8772: Email Source does not filter correctly when a filter is placed on the 'MessageID'
  • Fix 8777: Auditing columns within the Dimension Merge do not allow string variables or string values to be written
  • Fix 8778: SalesForce Destination does not send errors down Error Output when in Bulk or BulkZip Mode
  • Fix 9146: Unpack Data Transform throws Object Reference when editing File Format properties
  • Fix 9147: Unpack Data Transform throws Object Reference when JSON Properties tab is not configured
  • Fix 9142: The license expiration date does not appear in the License Manager
v2016

Version 2016.4.5 [October 25, 2016]

New Features:

  • New 4012: File Properties Task compressed UI description should indicate NTFS compression
    • Updated the File Properties Task description for compressed files to clarify the use of NTFS compression.
  • New 6627: Added before and after scripts to Fact Destination, Upsert Destination and Oracle Destination
    • Added Before and After Scripts to Upsert Destination. Oracle Upsert Destination and Fact Table Destination. The before script is used to execute a sql statement before each buffer is processed. The after script is used to execute a sql statement after each buffer has been sent to the destination.
  • New 6654: Created FileGateway Source
    • Create a filegateway source based on the filegateway task that will separate the valid and invalid rows into success and error output
  • New 6685: Excel Source
    • Excel Source uses openxml to read an excel worksheet, sending the rows into a data flow
  • New 6688: Excel Connection Manager
  • New excel connection manager for use with the Task Factory Excel Source and Destination
  • New 6691: Excel Destination
    • Excel Destination supports writing data flows into excel files using the openxml format
  • New 6693: Refactor Task Factory help doc control flow items
    • Refactor the Task Factory help documentation control flow items to ensure they are up to date and easier readability.
  • New 6759: Added Support for TLS 1.1 and 1.2 To Rest Connections
    • HI Team, Per request we are adding this as a backlog item for consideration. Currently the Rest Source does not use the TLS 1.2 protocol that is required by the recent Salesforce changes. Our client Tristan Lewis of Collaborative Consulting is accessing a custom SalesForce instance within SalesForce. This access requires the use of the Rest Source and not the typical Salesforce Source provided.
  • New 6794: Task Factory - Rest Source - Addition of Namspacing
    • Added the ability to define namespaces for xml queries in both the unpack data transform and the rest source
  • New 7344: OAuth 1 Connection Manager to REST Source
    • This can be used to connect to endpoints where OAUTH1 is needed to make rest calls.
  • New 7381: Added "Pause Between Round Trips" option to Rest Source, Marketo Source and Marketo Destination
    • A client is experiencing the following issue. After discussing the inquiry, development requested a PBI for the inquiry below: • The Marketo API limits 100 calls in 20 seconds. Each call can return 300 records at a time. • We have around 92000 records to be extracted however the process fails after 30000 records. Is there a way to limit the number of records being read by TF Marketo source? It can help us overcome this problem.
    • Find out if configurable on Marketo
  • New 7382: Include 'Rebuild temp table indexes' option in Oracle Upsert Destination
    • This new option gives the ability to rebuild the temp table index after each buffer.
    • This resolves an issue where some Oracle environments may return an 'ORA-26026' error when using the Oracle Upsert Destination.
  • New 7388: Added Style / Formatting To Excel Destination Columns
    • Added support for adding style to columns. The styling is based on microsoft excel formatting and all formatting can be customized based on Excel formats.

Updated Features:

  • Update 7341: Error Output Description now uses properties and inputs

Fixes: 

  • Fix 4988: Uninstalling Task Factory with Workbench installed removes Workbench dependencies from the GAC
  • Fix 5501: Int64 Variable Values not available for auditing in the SCD Transform
  • Fix 5520: Advanced Derived Column throws "Illegal Characters in Path" error when using the FIleWriteAllByte function
  • Fix 6063: SalesForce connection manager throws "Proxy 407 Authentication Error" when using a proxy that doesn't use basic authentication
  • Fix 6064: Hash transform updates order when selecting and removing input column(s)
  • Fix 6184: TF Sharepoint Destination Column Mismatch between versions.
  • Fix 6202: TF Upsert Destination - Unable to contain spaces in table name
  • Fix 6203: TF Fact Table Destination unable to use table with Spacing in the table name
  • Fix 6216: Using "Deploy Package" option in 2015 data tools throws VS_IsCorrupt error with Advanced Aggregator
  • Fix 6220: Excel Refresh Task - task completes successfully even if the data connections are not refreshed successfully.
  • Fix 6255: TF SalesForce Source cannot run in Parallel
  • Fix 6785: SalesForce Source throws "XML Document Error" for Contact and Account objects
  • Fix 6830: Fact Table Destination fails to create temporary table when the same column exists in the source, lookup and destination table
  • Fix 6831: Fixed Error in XML Transform Where Child Elements Weren't Being Written When Mapped
  • Fix 7342: The Rest Source OAuth 2 Token Getter throws 'Browser No Longer Supported' when getting tokens
  • Fix 7355: MS SQL 2016 CU1 update throws error "Could not load file or assembly 'PragmaticWorks.Common&'
  • Fix 7356: Within Fact Table Destination, multiple equality lookups on a dimension table changes to the same source column
  • Fix 7362: Fixed Issue Where Salesforce Destination passes name of Lookup column twice when used as External ID
  • Fix 7374: Email Source doesn't save variable selection when removing selected variable
  • Fix 7375: Dimension Merge SCD does not open in VS 2008 when using TF Version 2016.3.7
  • Fix 7380: Salesforce Source fails to return data when multiple objects are referenced
  • Fix 7395: Pack Data Transform hangs when no rows are passed to the component
  • Fix 7406: Upsert Destination throws error when creating temporary tables based on table names which include blank spaces
  • Fix 7806: SalesForce Destination throws "Unable to cast object of type 'System.Int64' to type 'System.Byte[]'.". error when using bulk mode
  • Fix 7836: SalesForce Destination throws 'Object not set to an instance of an object' error when using Bulk or Bulk Zip mode in combination with the 'Wait for Bulk Results' option
  • Fix 6666: Licensing is now more robust and should not issue an error during installation.
  • Fix 8689: SalesForce Destination fails when using a proxy in Bulk or BulkZip mode.

Version 2016.3.7 [August 1, 2016]

New Features:

  • New 4492: Add support for three part names in upsert / fact table
    • Support for three part names (server).(db).(tablename) in upsert and fact table has been added.
  • New 4692: Sharepoint document task now allows check out and check in of a file
    • The SharePoint task now supports the ability to check a file out prior to updating it, and check it in when the update is finished.
  • New 4693: Created File Gateway Task
    • The File Gateway task supports validating text files against a set of rules. This enables users to confirm that a file is valid for processing prior to attempting to load it. If the file passes all rules, then the task will succeed, otherwise it fails.
    • Supported rules include:
      • Number of rows
      • File size
      • Number of columns
      • Rows contain the specified number of columns
  • New 4705: Upsert Destination now supports Error Row Redirection
    • The Upsert Destination now supports error row redirection. As a buffer of records comes into the component, it is sent as a batch to the database. Any database failure will roll back the batch, and the buffer will be retried a single row at a time. Any individual row failure will be redirected to the error output. Subsequent buffers will be processed as batches, unless there is a failure.
    • This behavior can be enabled using the "How to handle errors" property. Setting it to redirect errors enables the new behavior.
  • New 5480: Added Execution Timeout to Rest Source
    • Added Execution Timeout to the rest source to allow the end user to provide a longer running execution time.
  • New 5491: Sync 2016 Extensions and Mappings in TF Build
    • The mappings files have been updated to reflect the latest versions and compatibility.
  • New 6065: Task Factory Advanced Execute Package Task - Outside Project execution
    • Updated the advanced execute to allow the selection of any environment from the catalog projects.

Fixes:

  • Fix 1324: Allow Oracle Upsert to gracefully handle changes in table/views
  • Fix 1364: Salesforce Destination outputs incorrect object SalesforceId when bulk processing mode is selected
  • Fix 1373: Salesforce Destination fails entire batch when Quote object references other objects with a deleted or non-existent object ID
  • Fix 1564: Terminator dest does not retain column selection for output
  • Fix 1694: "System.AccessViolationException" Error when loading all TF Connection Managers in 64 bit
  • Fix 1944: SF Source queries that returns no rows throws error when closing the component
  • Fix 4463: Salesforce proxy reverts to using non-proxy connection if proxy host and credentials are incorrect
  • Fix 4482: TypeHandlerFactory fails to load if Microsoft.SqlServer.Types 10.0.0.0 isn't present on the system
  • Fix 4667: Adv email and SMS task is unable to use 'user friendly' names appended to email addresses
  • Fix 4719: Changing the upstream source component name causes fact table lookups to become invalid
  • Fix 4843: Cannot change action in previously configured Sharepoint Source
  • Fix 4887: TF Upsert Destination - Cannot upgrade to newest release when upgrading from 2.3.0
  • Fix 5450: TF Advanced Derived Column Transform - FileWriteAllBytes
  • Fix 5457: Pack Transform displays an error when Generate Template is clicked
  • Fix 5499: Sorted GUID business keys throws "Items must be added to the queue in sorted, ascending order" error in memory opt mode
  • Fix 5517: Upsert Row By Row doesn't fail a second row in insert only mode
  • Fix 6045: Fixed TF SalesForce Source SOQL Relational Query Issue Where Columns Named 'Type' Returned The Wrong Data
  • Fix 6263: Lastest TF build is missing assembly Microsoft.SqlServer.DtsMsg for 2014

Version 2016.2.4 [May 4, 2016]

Important:  Per Salesforce's help documentation, "Starting in June 2016, Salesforce will begin disabling the TLS 1.0 encryption protocol using a phased approach."Customers should note that when this change goes into effect, all versions of Task Factory prior to version 2016.1.7.210 will no longer be able to connect to Salesforce.

New Features:

  • New SQL Server 2016
    • Task Factory compatibility with SQL Server 2016. (Currently, Release Candidate 3.)
  • New Dynamics Source & Destination
    • (TF-TFS-4292):Dynamics Source and Destination components can now connect to Dynamics CRM 2016 premise and online servers.

Updated Features:

  • Update All Components
    • (TF-TFS-4433): All components that use column selection now support select all/ select none toggle.
    • (TF-TFS-4089): Updated components that threw error when CodeSlice was installed with Task Factory.
    • (TF-TFS-4406): Updated installer to uninstall all third party assemblies.
  • Update REST Source
    • (TF-TFS-3334): Improvements to component including: removed password requirement from rest connection, add URL Based paging, allow a choice of POST or GET actions, update code for handling tokens, and created the token getter as a standalone app.
  • Update Facebook Source
    • (TF-TFS-4117): Connection manager now allows users to set permissions.

Fixes:

  • Fix Address Parse Transform
    • (TF-TFS-4076): Fixed error where AddressLine2 Nulls caused component to fail with object reference error.
  • Fix Advanced Lookup Transform
    • (TF-TFS-4296): Fixed issue where input parameters that contain null throws 'Input string was not in a correct format' error.
  • Fix Email Source
    • (TF-TFS-3074): Fixed issue where connection credentials set dynamically in a for each loop reused the initial variable values.
  • Fix Facebook Source
    • (TF-TFS-4117): Fixed issue where the connection manager couldn't set permissions.
  • Fix PGP Encryption Task
    • (TF-TFS-4135): Fixed issue where component did not embed the name of the file in the metadata.
  • Fix Secure FTP Task
    • (TF-TFS-4405): Fixed issue where using ftp connection type throws object reference error.
    • (TF-TFS-4175): Fixed issue where SFTP fails to connect and throws 'Setting up fallback kbi prompt based on supplied password' using edtFtpNetPro.
    • (TF-TFS-4176): Fixed issue where certain key files failed authentication even when able to connect using filezilla .
  • Fix Salesforce Source
    • (TF-TFS-4133): Fixed issue where relational columns created in altered soql query produced NULL in the output.
  • Fix Sharepoint Source
    • (TF-TFS-3847): Fixed issue where calculated columns in Sharepoint still displayed ID's with column name even if remove option is selected
  • Fix Upsert Destination
    • (TF-TFS-3876): Fixed issue where using column compare method updated columns with '0' values to null

Version 2016.1.7.210 [February 10, 2016]

New Features:

  • New Azure ML Storage Destination
    • A new data flow component used to send data to an azure blob storage file that will be consumed by an Azure ML Scoring / Predication Web Service.
  • New Azure ML Storage Source
    • A new data flow component used to retrieve the results of a scoring / prediction Azure ML Web Service execution.
  • New Azure ML Batch Execution Task
    • A new control flow component that control the batch execution of an Azure ML Web Service. Can be used with the Azure ML Storage Destination and Azure ML Storage Source to insert data before a batch execution and then retrieve the results of a batch execution.

Updated Features:

  • Update Dimension Merge
    • (TF-TFS-1206): Updated Dimension Merge SCD's auditing to default to an integer and filter variables by datatypes.
    • (TF-TFS-2416): Updated Dimension Merge SCD to allow users the ability to select compound surrogate keys.
  • Update Salesforce Connection Manager
    • (TF-TFS-3510): Connection managers are now updated to use TLS 1.2. *Important note: Per Salesforce's help documentation, "Starting in June 2016, Salesforce will begin disabling the TLS 1.0 encryption protocol using a phased approach."
  • Update Rest Source Connection Manager
    • (TF-TFS-3334): Rest Source's standard connection manager now allows users to connect using base64 encryption headers.
    • (TF-TFS-3337): Rest Source's connection manager now allows users to add headers to authentication requests.
  • Update SFTP Task
    • (TF-TFS-4002): Reintroduced edtFtpNetPro into the connection manager. This can be seen by choosing the SFTP-SSH FTP Legacy connection type.
  • Update Unpack Data Transform
    • (TF-TFS-2898): Added the option to select / unselect all columns to be included in the Unpacked output

Fixes:

  • Fix Advanced Aggregator
    • (TF-TFS-4134): Fixed error where component produced incorrect results when using MIN and MAX with text values.
  • Fix Advanced Execute Task
    • (TF-TFS-3650): Fixed error when executing child packages using Excel source and x86 Microsoft Access Database Engine 2010 Redistributable.
  • Fix Advanced Cache Transform
    • (TF-TFS-4050): Fixed error where the component throws "item with same key" error when it was used in for each loop.
  • Fix Email Source
    • (TF-TFS-4033): Fixed issue where clicking the test connection button for IMAP closed and crashed the connection manager when port and folder aren't selected
  • Fix Excel Power Refresh
    • (TF-TFS-4136): Fixed issue where refresh throws error when Excel used an SSAS cube connection.
  • Fix Expression Based Components
    • (TF-TFS-3359): Fixed issue where ExecuteSql method caused 'ExecuteQueryWithParamsDB' is not a member of 'PW.TaskFactory.SharedMethods' error.
    • (TF-TFS-3765): Fixed issue where expression task fails to convert to type double when using an INSERT INTO expression.
  • Fix Facebook Source
    • (TF-TFS-4117): Fixed issue where the connection manager couldn't set permissions.
  • Fix Dimension Merge SCD
    • (TF-TFS-3432): Fixed bug in Dimension Merge SCD where new row variable counts produced in auditing did not properly set in the post execute event when using memory optimized mode.
    • (TF-TFS-3669): Fixed bug when using compound business keys with dt_timestamp threw an error in 2012 & 14, but executed in 2008.
    • (TF-TFS-3763): Fixed issue where using GUID as business keys sent rows down the invalid input.
    • (TF-TFS-3816): Fixed issue where adding new columns to SCD caused outputs configured to be excluded to become included.
  • Fix Secure FTP Task
    • (TF-TFS-3077): Fixed issue where renaming the connection manager caused the component to lose the connection manager selected.
    • (TF-TFS-4121): Fixed issue where package did not fail when trying to download an invalid directory from server using chilkat setting.
    • (TF-TFS-4153): Fixed issue where reusing the connection appended the remote file path.
    • (TF-TFS-4211): Fixed issue in legacy setting where host addresses that ended with "/" threw a "no such host is known" error on connection test.
  • Fix Salesforce Source
    • (TF-TFS-2828): Fixed issue where some users were experiencing slower performance with large datasets when compared to pre 4.0 versions.
    • (TF-TFS-2831): Fixed issue where relational columns that contained nulls caused the column to be removed from the metadata.
    • (TF-TFS-3817): Fixed issue where custom SOQL queries using < and a trailing > eliminates the < and > in the previewed query statement.
    • (TF-TFS-4247): Fixed issue where 3 sources in a single data flow that returned more than 1000 rows threw an error.
  • Fix Sharepoint Source
    • (TF-TFS-1339): Fixed custom columns set to not be displayed in custom views are being displayed in Sharepoint Source external metadata column
    • (TF-TFS-3476): Fixed issue when adding and removing columns from the Sharepoint source caused "key in dictionary" error.
    • (TF-TFS-3764): Fixed issue where component did not display previews of custom columns that used (Sharepoint) single line of text datatype.
  • Fix Unpack Data Transform
    • (TF-TFS-3093): Fixed issue with unpack data tranform in Xml mode where null values were returned with a root query defined.
    • (TF-TFS-3103): Fixed issue with Unpack Data Transform where DT_NTEXT columns were not being included in the unpacked output.
  • Fix Upsert Destination
    • (TF-TFS-4019): Fixed issue with the "Rebuild Definition From Mappings" hovered over entire user interface when adjusting window size.
  • Fix XML Output Destination
    • (TF-TFS-3075): Fixed issue where user interface didn't display certain elements referenced in a child xsd.
    • (TF-TFS-4004): Fixed the output to include xml declaration when using xsd's that provide the declaration.
v2015

Version 2015.3.7.1105 [November 5, 2015]

New Features:

  • New Marketo Source
    • A new data flow component used to connect to and retrieve objects such as leads and opportunities for users that employ the Marketo automated marketing software.
  • New Marketo Destination
    • A new data flow component that connects to the Marketo automated marketing software and allows users to insert, upsert, update, delete, and duplicate data such as Leads and Opportunities.

Updated Features:

  • Update Data Validation Transform
    • (TF-TFS-2415): Custom regular expressions can now be viewed in the user interface when package is viewed by a different user.
  • Update Rest Source Connection Manager
    • (TF-TFS-2424): The OAuth2 connection manager is now more configurable to accommodate connections to various OAuth uses. Users can select preconfigured templates including (but not limited to) Google, Paypal, and GoToMeeting.
    • (TF-TFS-2424): The standard connection manager options were expanded to include an (optional) Authentication Endpoints tab.
  • Update Salesforce Destination
    • (TF-TFS-1701): Users can now select between Parallel and Serial Concurrency when performing an action.
  • Update Update Batch & Delete Batch Transform
    • (TF-TFS-2004): Update and Delete Batch transform user interfaces now match Upsert Destination General tab (column mappings) and includes a Refresh Metadata button.
  • Update XML Output Destination
    • (TF-TFS-1778): Component now has the option to create and edit namespaces for elements.

Fixes:

  • Fix Advanced Derived Column
    • (TF-TFS-1372): Fixed ToDate function that would error when format option was included in the expression.
    • (TF-TFS-1378): Fixed Millisecond function text formatting within the expression editor.
  • Fix Advanced Lookup
    • (TF-TFS-2580): Fixed issue with Norway (Bokmål) region setting sending matched output to the non-matched output.
  • Fix Dimension Merge SCD
    • (TF-TFS-1716): Fixed execution ‘unable to cast object’ error when processing columns with DT_IMAGE (blobcolumn) datatypes.
  • Fix Dynamics CRM Source
    • (TF-TFS-1544): Fixed the Account entity that incorrectly displayed and returned the OwnerIdType column as a name rather than a numeric value.
  • Fix Dynamics CRM Destination
    • (TF-TFS-2438): Fixed issue with inconsistent results being sent when both success and error outputs were used.
  • Fix Email Source
    • (TF-TFS-2079): Corrected user interface filters where the OK and Cancel buttons were reversed.
  • Fix Fact Destination
    • (TF-TFS-1583): Fixed error encountered when a lookup used 2 conditions that pointed to the same source column.
  • Fix Rest Connection Manager
    • Fixed an issue with the Basic Authentication where the Network Credentials were not being set correctly.
  • Fix SFTP Task
    • (TF-TFS-2231): Fixed issue where component throws Chilkat error when using variables for path and filename to download a file.
    • (TF-TFS-2888): Fixed issue where using the download directory action did not download subdirectory files when the option was selected.
  • Fix Salesforce Destination
    • (TF-TFS-1371): Fixed issue where the assignment rules drop-down was disabled for Accounts object even when rules referenced an account.
  • Fix Salesforce Source
    • (TF-TFS-1566): Fixed issue where the component did not output different parent/child objects created in a custom query.
  • Fix Upsert Destination
    • (TF-TFS-2567): Fixed issue with component not updating from pre-3.0 versions.
  • Fix XML Output Destination
    • (TF-TFS-2232): Fixed issue with integer variables mapped to an attribute caused the component to discard the xsd and its mappings, leaving only the attribute using the variable.
    • (TF-TFS-2445): Fixed issue where multiple inputs caused the package to fail after being executed multiple times.
v4

Version 4.3.0.709 [September 3, 2015]

Important:  *As of the 4.3.0.709 release of Task Factory, the Integration Services 2005 binaries are no longer included within the installer. If you are running SSIS 2005, please use a build prior to 4.3.0.709 to install the 2005 components.

New Features:

  • New Rest Source
    • This new component allows users to connect to a web service that utilizes a REST API and extract data in XML or Json format.

Updated Features:

  • Update Advanced Cache Lookup Connection Manager
    • (TF-TFS-10951): Updated the user interface for 2012 and 2014 versions and its configurable filter.
  • Update Connection Managers
    • (TF-TFS-10531): This update addresses a Microsoft fix where converting third-party connection managers (ie Dynamics, Hadoop, Salesforce, and Sharepoint) to project deployment while using EncryptSensitiveWithPassword encryption threw the following error: “'Salt' attribute for password is missing in the project manifest - SSIS SMO Connection Manager.”
  • Update Upsert Destination
    • (TF-TFS-11274): Component now includes a Refresh Metadata button and no longer displays error when a column is added or deleted. This allows the package to execute even if upstream metadata adds or deletes a column before reaching the Upsert Destination. (Previous behavior – the package would fail execution.)
  • Update Sharepoint Source
    • (TF-TFS-10537): Lists with attachments now have ability download the attachment

Fixes: 

  • Fix Advanced Conditional Split
    • (TF-TFS-11182): Fixed issue where the default output name didn’t save after closing the component.
  • Fix Advanced Derived Column
    • (TF-TFS-10897): Corrected issue where user interface didn’t display the functions list correctly.
  • Fix Advanced Execute Package
    • (TF-TFS-11337): Fixed issue where upgrades that skipped over multiple versions changed the MappingDirection within the package XML code.
  • Fix Advanced Lookup Cache Connection Manager
    • (TF-TFS-8324): Fixed issue where input parameters did not retain multiple conditions.
  • Fix Data Flow Nugget
    • (TF-TFS-9927): Fixed issue where execution package threw “input lineage ID not found” error when triggering a nugget package that used the native Sort component.
  • Fix Dimension Merge SCD
    • (TF-TFS-2197): Fixed issue where component threw error when using multiple sorted business keys in memory optimized mode.
  • Fix Fact Destination
    • (TF-TFS-11183): Fixed issue with conditions using hard coded integer values appended the letter "b" to the end.
  • Fix Oracle Upsert Destination
    • (TF-TFS-11149): Fixed issue where the component could not create temp tables when accessing a table created by a different user.
  • Fix Salesforce Source
    • (TF-TFS-11150): Fixed issue where setting the batch size in normal mode only inserted that number of rows.
    • (TF-TFS-10871): Fixed issue with proxies used in the connection manager throwing an "unable to connect to remote server" error.
  • Fix Salesforce Destination
    • (TF-TFS-10822): Fixed issue where certain credentials were throwing a "Given key not present in the dictionary" error when using the Leads object.
  • Fix Timezone Conversion
    • (TF-TFS-10877): Fixed issue where setting the batch size in normal mode only inserted that number of rows.

Version 4.2.0.604 [June 4, 2015]

Patch:

  • Patch Advanced Lookup Cache
    • (TF-TFS-11045):This patch fixes an issue where the advanced lookup cache manager failed to create indexes thus causing performance degradation.

Version 4.2.0.511 [May 11, 2015]

New Features: 

  • New Excel Power Refresh Task
    • A control flow component that can be used to refresh Excel Power Query and Power Pivot tables
  • New Pack Data Transform
    • The counterpart to the Unpack Data Transform, developers can use a single input or multiple relational inputs to store multiple column and row values within a single destination column. Users can choose to store this data as either XML, JSON, or delimited format.
  • New Facebook Source
    • Developers can use SSIS to connect to a Facebook account and extract information such as status updates, friends, comments, and inbox messages.
  • New LinkedIn Source
    • This new component gives developers the ability to connect to a LinkedIn account and extract items such as a user's name, updates, connections, and headlines.
  • New Twitter Source
    • Developers can use SSIS to connect to a twitter account and extract information such as status updates (known as 'Tweets',) followers, hashtags, retweeted, and 'favorited' messages.

Updated Features:

  • Update Dimension Merge Slowly Changing Dimension
    • Memory Optimized Property: This new property was added to help relieve the memory pressure on packages that used extremely large datasets. It is highly recommend that users read the help documentation before incorporating it within packages. (This option is only available to users with SQL 2012 and higher.)
  • Update Dynamics CRM Source and Destination
    • Components are now compatible with Dynamics CRM 2015 premise and online.
    • (TF-TFS-10411) Users can now select N:N custom entities
  • Update Fact Table Destination
    • (TF-TFS-9427): Component can perform lookups on views.
  • Update SFTP Task
    • (TF-TFS-10322) Component now includes 'Get List of Files with Metadata' option.
  • Update Sharepoint Source
    • (TF-TFS-10536) Lists with attachments now displays the attachment rather than a Boolean value.
  • Update Unpack Data Transform
    • Added a Test Unpack Columns tab that allows users to test their configuration with real data
    • Component can now unpack columns with JSON data

Features:

  • Fix All Components
    • (TF-TFS-7632): All help buttons now open the correct and current online help document.
    • (TF-TFS-9651): All video buttons have been removed from component footers. Videos can now be accessed by clicking the Help button.
  • Fix Advanced Derived Column
    • (TF-TFS-2913): Setting a decimal scale to 0 no longer throws an object reference error.
    • (TF-TFS-3469): Syntax Window that displayed multiple parameters now adjusts properly.
    • (TF-TFS-10140): Corrected issue where DateDiff expression’s StartDate and EndDate input values being reversed.
    • (TF-TFS-10366): Fixed issue with GetDatePart function formatted to return 2 digit year (“YY”) returned 4 instead.
  • Fix Advanced Execute Package
    • (TF-TFS-1747): Assignment Direction and Child Package Variable are no longer enabled until a user selects a package.
    • (TF-TFS-2129) The Advanced Execute Package Transform can now replace a second nugget found within the first Nugget.
    • (TF-TFS-3851) Proper error message is now displayed when attempting to connect to an SSIS Catalog but no SSISDB is present.
    • (TF-TFS-4001) Component now throws a more graceful error message when attempting to execute a non-existent package thought to be located on the SSIS Catalog.
    • (TF-TFS-7144) Expression button is no longer fixed in place when resizing the user interface.
  • Fix Data Flow Nugget
    • (TF-TFS-4721): Password property no longer displays actual password but instead replaces characters with asterisks
    • (TF-TFS-9100): Component now includes validation to ensure the nugget data flow does not contain another nugget
  • Fix Dimension Merge SCD
    • (TF-TFS-9437): Component no longer throws an error when processing DT_DBTIME2 as SCD1 or SCD2 type changes.
  • Fix Dynamics CRM
    • (TF-TFS-10420): Fixed issue with Dynamics CRM connection manager did not retain proxy configurations.
  • Fix Error Output Destination
    • (TF-TFS-4610): Fixed issue where upstream columns that were deleted after the EOD component was configured remained.
    • (TF-TFS-4612): Component no longer duplicates columns when constraint is removed and reapplied.
  • Fix Fact Table Destination
    • (TF-TFS-8833): Source tables that use non-alphanumeric characters no longer throws an error.
    • (TF-TFS-10399): Deleting a lookup and closing the component no longer throws an object reference error.
  • Fix Oracle Upsert
    • (TF-TFS-9528): Users can now insert only without needing a primary key.
    • (TF-TFS-9534): Corrected issue where temp tables remained on the Oracle server when execution failed.
  • Fix Salesforce Source
    • (TF-TFS-9298): Component no longer throws an XML error when sandbox accounts use the version 30.0 API
    • (TF-TFS-10012): Fixed “escape” issue where '&' displayed as 'amp&'
    • (TF-TFS-10690): Corrected issue with Salesforce source UI not displaying edit query and variable parameter window for environments using 125% or higher display values.
    • (TF-TFS-10692): Fixed previews that contained custom fields, NULL, & actual values throwing a "Given key not present in dictionary" error.
  • Fix Secure FTP
    • (TF-TFS-4083): Users no longer have to select “Upload directory from server” to enable the “Include Subdirectories” checkbox.
    • (TF-TFS-9939): Corrected an issue where component would display the error message “Handle not found” when uploading to root directories for some sites.
    • (TF-TFS-9943): Corrected an issue where component would not delete a file for certain ftp types.
    • (TF-TFS-10389): Fixed issue with component’s inability to delete directory files/delete files on certain SFTP sites.
  • Fix SharePoint Source
    • (TF-TFS-9717): Hard coding a name filter no longer throws a “one or more fields are not installed properly” error.
    • (TF-TFS-10011): Fixed issue with preview throwing an error due to trying to return 2 “Modified By” columns in a shared documents list.
  • Fix Timer Task
    • (TF-TFS-1393): The user interface text doesn’t overlap when Windows Performance Options Visual Effects are set to "Adjust for best appearance"
  • Fix XML Output Destination
    • (TF-TFS-9309): Corrected issue where 3-deep nested child attributes were not being included within the output.
    • (TF-TFS-10010): Fixed issue with component completing execution successfully, but displaying a “Could not remove table” error when execution completed.

Version 4.1.0.115 [January 15, 2015]

New Features:

  • New Hadoop WebHDFS Source
    • This new component can be used to stream large files stored in the HDFS of a Hadoop server which can be converted into rows of data within SSIS.
  • New Unpack Column Transform
    • The Unpack Column Transform can be used to extract XML or delimited data contained in a single column and “unpacked” or separated into user-defined column(s) to be loaded or merged downstream.

Updated Features:

  • Update Advanced Execute Package
    • Update Execution Methods:
      • File System - Executes a child package by loading the package from the file system and executing it in the process of the parent package
      • SQL Server (MSDB, File System) - Executes a child package by copying the package from SQL Server into the parent package and executing it in the process of the parent package.
      • Local Catalog Execution - Will execute a package by creating a project (ispac) in process of the parent package and assigning the child package, project level parameters and project level connection managers to the in-memory project.
      • Server Catalog Execution - Will execute a package via server catalog execution (out of process) and wait on the package to finish execution on the server.

Fixes:

  • Fix Advanced Derived Column
    • (TF-TFS-9022): "Too large for current buffer size" error is no longer produced when changing Test Input value to ntext.
    • (TF-TFS-9023): NTEXT columns that use the ToChar function no longer outputs the value twice.
  • Fix Advanced Execute Package
    • (TF-TFS-8694): Parent package now properly recognizes environment variables.
  • Fix Advanced Lookup Cache
    • (TF-TFS-9100): Advanced Lookup Cache can now process tables that use spaces in their column names.
    • (TF-TFS-9138): Dates in added conditions are now wrapped with ticks instead of pound signs.
    • (TF-TFS-9154): Advanced Lookup Cache no longer ignores "Use first value" when using key and date conditions.
  • Fix Compression Task
    • (TF-TFS-8813): Compression task now properly releases connection when the task completes.
  • Fix Data Validation
    • (TF-TFS-8827): An error is no longer thrown for MMDDYYYY unless it fails proper validation.
    • (TF-TFS-9078): Data validation now properly refreshes metadata.
  • Fix Delete Batch
    • (TF-TFS-9079): Component now properly refreshes and can still be opened even though the configured connection manager is deleted.
  • Fix Dynamics CRM Destination
    • (TF-TFS-7846): The Dynamics Destination actions are now consistent in how to handle output.
  • Fix Dynamics CRM Source
    • (TF-TFS-4527): Columns now properly return the same output data if using the same source.
    • (TF-TFS-8665): The filter for "Does not equal" now properly filters, and no longer produces the same result as the "Equals" filter.
    • (TF-TFS-9060): Product numbers with hyphens are no longer erroneously processed as dates.
  • Fix Error Output Destination
    • (TF-TFS-8853): The correct value for DT_DBDATE columns are now output rather than NULL.
  • Fix Fact Table Destination
    • (TF-TFS-8818): Fact Table Destination now properly refreshes lookups and column mappings when a new fact table or connection manager is selected.
    • (TF-TFS-8831): Fact Table Destination now executes as expected when selecting keys that use expressions.
    • (TF-TFS-8952): Adding a new lookup (without configuring it) and returning to the previous lookup no longer prevents you from selecting a new dimension table.
    • (TF-TFS-8987): Adding an exclamation point in the source name no longer produces an error.
    • (TF-TFS-8992): External metadata is refreshed within the UI when component is opened.
    • (TF-TFS-9040): Column names can now properly use spaces.
  • Fix Oracle Upsert
    • (TF-TFS-8800): Oracle Upsert no longer throws an error when using an index that uses a tablespace.
  • Fix Replace Unwanted Characters
    • (TF-TFS-9032): Replace unwanted characters now replaces rather than append the value when selecting replace column data option.
  • Fix SalesForce
    • (TF-TFS-8816): Fixed an issue where when using two different connections in SalesForce, an error messages that were associated with the first connection would persist to the second connection.
    • (TF-TFS-8817): Edit query no longer needs to be checked and re-checked to enable editing when selecting a new connection manager. If checked, you will be able to edit across connection managers.
    • (TF-TFS-8830): Connection managers no longer produce "Unable to find token" error when correct credentials are supplied.
    • (TF-TFS-9025): Destination no longer throws the "Sequence contains no matching element" error.
  • Fix Secure FTP
    • (TF-TFS-8832): Folders are no longer included when getting a list of files using SSH connections.
    • (TF-TFS-8834): "Check if File Exists" no longer returns false when the file exists.
    • (TF-TFS-9008): File filters using SSH connections within the SFTP component are now respected and only return the files designated in its configuration.
  • Fix SharePoint
    • (TF-TFS-5912): SharePoint Connection Manager no longer throws an "Unspecified Error" when using a User Name and Password.
    • (TF-TFS-8830): Sharepoint Source and Destination connection manager throws “unable to find token” error when Sharepoint Documents with same connection could connect.
    • (TF-TFS-8838): SharePoint Source and Destination now properly refresh when changing connections.
  • Fix Upsert Destination
    • (TF-TFS-9096): Upsert Destination now respects different connections set dynamically in a for-each loop.
  • Fix XML Output Destination
    • (TF-TFS-9259): XML Output Destination no longer throws an "item with same key" error when used inside a for-each loop.

Version 4.0.0.930 [September 30, 2014]

New Features:

  • New Fact Table Destination
    • Developers can perform multiple lookups and insert/update data into a Fact table within a single component. 
    • Additional functionality includes: choosing between insert and update actions, configuring table join conditions to dimension tables from their source data, creating column aliases for multiple lookups on the same Dimension, and the ability to define a default value that prevents NULLS from being added.
  • New Hash Transform
    • Users can choose from a selection of algorithms to create hash values from input columns. Other features include: customizing the order of input, the option to enable padding, adding null replacement character(s), and defining separator character(s).

Updated Features:

  • Update Address Parse Transform
    • (TF-TFS-8381): Users can select columns to not be included in the output.
    • (TF-TFS-8575): Component now recognizes the following address suffixes: CI = Circle, PY = Parkway, RW = Row, and HY = Highway.
  • Update Advanced Execute Package Task
    • (TF-TFS-8351): Details of a package being executed by the component can be seen in the execution results / progress.
  • Update Compression Task
    • (TF-TFS-8391): Component now supports Deflate64 compression / decompression.
  • Update Secure FTP Task
    • (TF-TFS-7426): Improved performance when using SSH connections.
    • (TF-TFS-7739): Component now performs a check to "Reuse Connections" when that option is selected and a connection is made during execution.
  • Update Salesforce Destination
    • (TF-TFS-7582): The component now outputs a column that identifies each row as being inserted, updated, or deleted.
  • Update Task Factory Registration
    • (TF-TFS-7697): Registration application now displays the version installed regardless of product being registered.
  • Update XML Output Destination
    • (TF-TFS-7746): Component now supports mapping root level elements / attributes

Fixes:

  • Fix General Usability
    • (TF-TFS-3827): Components no longer attempt to validate metadata when SSIS is being used in Offline Mode.
  • Fix Advanced Derived Column (Expression Engine)
    • (TF-TFS-7752): ToMoney function incorrectly rounded DT_CY (currency) columns.
    • (TF-TFS-7844): Resolved issue where expression engine incorrectly lowered numeric columns by .01.
    • (TF-TFS-7859): Corrected the ToChar function to not display milliseconds when omitting it in the datetime format configuration.
    • (TF-TFS-8435): Resolved issue with various functions missing their example expressions.
    • (TF-TFS-8451): Corrected SysTimeStamp function returning an incorrect date when formatting the year.
    • (TF-TFS-8464): Hex expression incorrectly returned original value rather than Hex value.
    • (TF-TFS-8631): Resolved issue with GetDatePart function throwing an 'Expression not declared' error.
    • (TF-TFS-8712): Resolved issue with expression editor misplacing functions when drag and dropped from the functions list.
  • Fix Case Transform
    • (TF-TFS-7698): Resolved issue with Irish surnames (such as O'Connor) not being capitalized properly.
  • Fix Data Flow Nugget Transform
    • (TF-TFS-7253): Resolved issue with certain packages throwing a 'key not present in dictionary' error on execution.
  • Fix Dimension Merge Slowly Changing Dimension Transform
    • (TF-TFS-8759): Resolved issue where NULL expiry dates were being sent to the Invalid Input although the component is configured to use NULL as its last input expiry date.
  • Fix Dynamics CRM Source
    • (TF-TFS-8759): Component now produces a clear and graceful error message when the component's filter is missing a configuration value.
  • Fix Email Source
    • (TF-TFS-7584): When configuring the "From" filter, users can choose to use display names or email addresses.
  • Fix Error Output Description
    • (TF-TFS-8510): In 2005, connecting the component to a source's error output no longer causes the component to "hang" on execution.
  • Fix Oracle Upsert Destination
    • (TF-TFS-7605): Component now outputs binary data from DT_NTEXT input columns instead of "microsoft.sqlserver.dts.pipeline.blobcolumn."
  • Fix PGP Task
    • (TF-TFS-7806): Resolved execution issue for using keys created outside of Task Factory.
  • Fix Salesforce Source
    • (TF-TFS-8359): Component now refreshes the SOQL query when selecting a new connection manager.
  • Fix Sharepoint Source
    • (TF-TFS-6544): Resolved issue with users having to restart BIDS / SSDT for the Remove ID's selection to persist.
    • (TF-TFS-7544): Execution Results / Progress incorrectly displayed error column's description name rather than the actual column name.
    • (TF-TFS-8468): When clicking the Preview Data button, all output columns are displayed.
  • Fix Timezone Conversion Transform
    • (TF-TFS-8323): Component made incorrect conversion when using Europe/Istanbul.
  • Fix Upsert Destination
    • (TF-TFS-8677): Output columns with DT_CY (currency) datatypes now match native ADO.NET destination precision and scale.
    • (TF-TFS-8796): Resolved issue with component throwing an error when using tables that included spaces within their name.
  • Fix XML Generator Transform
    • (TF-TFS-7142): Users receive an error message when closing the component without mapped columns.
v3

Version 3.7.0.702 [July 1, 2014]

New Features:

  • New SQL 2014 Support
    • (TFS-5925): Task Factory now supports SQL Server 2014.
  • New Dynamics 2013 Support
    • (TFS-5925): Task Factory Dynamics CRM Source and Destination now supports 2013.
  • New Error Output Description
    • (TFS-6832): Error output description now captures all primary keys from multiple sources.
  • New XML Generator
    • (TFS-7121): XML Generator columns and temp file path can now be configured using variables.
      New SalesForce Destination
    • (TFS-6962 & 7565): SalesForce Destination now includes BulkZip mode processing. This enables NTEXT and binary data to be sent to SalesForce.com in bulk copy mode as well as the ability to attach files to records.
  • New SharePoint Connection Managers
    • (TFS-5339): SharePoint connection managers now support Claims Based Authentication.
  • New XML Output Destination
    • (TFS-7120): Created the new XML Output Destination component (contains similar functionality to XML Generator Transform with a few added features).
  • New XML Generator
    • (TFS-7123): XML Generator now includes an option for "pretty" output formatting.

Updated Features:

  • Update (TFS-6914): Task Factory now includes support for SharePoint 2013.
  • Update (TFS-7122): XML Generator Transform / XML Output Destination no longer outputs optional attributes when those values are NULL or empty.
  • Update (TFS-7124): XML Generator Transform / XML Output Destination no longer outputs XML prolog and Document Type Declaration.

Fixes:

  • Fix (TFS-3840): Metadata information is now included for Error OUtput Description within help documentation.
  • Fix (TFS-4068): Secure FTP Task no longer fails to download files located in subfolders using SFTP-SSH connection option.
  • Fix (TFS-6908): Delete and Move Emails Task no longer generates an "Unable to cast object" error when package is deployed to the SSIS Catalog.
  • Fix (TFS-7024): Advanced Derived Column no longer generates the error "LineageID not found upstream" even when all upstream components are refreshed and saved.
  • Fix (TFS-7044): SharePoint Destination no longer throws an "Object reference" error when selecting an action before selecting a list.
  • Fix (TFS-7119): Corrected an issue where Null Handler Transform did not convert all nulls to user defined values.
  • Fix (TFS-7121): Users can now configure XML Generator Transform's temp file location with a variable or project parameter.
  • Fix (TFS-7235): Fixed and issue where XML Generator Transform did not allow mapping elements for certain XSD files.
  • Fix (TFS-7272): Dynamics CRM Destination batch textbox no longer stays fixed in place when the UI is resized.
  • Fix (TFS-7273): Dynamics CRM Destination no longer outputs "same key already added"
  • Fix (TFS-7278): XML Generator Transform no longer incorrectly outputs Nvarchar(max) datatypes as "Microsoft.SqlServer.Dts.Pipeline.BlobColumn" instead of the actual value.
  • Fix (TFS-7315): Fixed an issued where Dimension Merge SCD incorrectly processed null values even when column was not selected as "Nullable" in the Row Change Detection tab.
  • Fix (TFS-7338): Advanced Lookup Cache Transform no longer throws "Object Reference" error when using fixed input parameters in a ranged lookup.
  • Fix (TFS-7393): Updated Dimensions Merge SCD help documents to improve component descriptions.
  • Fix (TFS-7431): Upsert Destination no longer throws an error when reserved keywords are used in a table name within the Merge Statement.
  • Fix (TFS-7434): IfNull and IfNullorEmpty functions now include configuration information and examples within the expression engine UI.
  • Fix (TFS-7605): Fixed an issue where Oracle Upsert incorrectly output "microsoft.sqlserver.dts.pipeline.blobcolumn" instead of an actual value when using NTEXT input.

Version 3.6.0.328 [April 2, 2014]

Updated Features:

  • Update (TFS-none): XML Generator now includes an option to configure a temp file which significantly improves the component's performance when producing large XML files.
  • Update (TFS-6723): Advanced Email and SMS Task now includes the ability to create an error log that is configurable in the component's properties.
  • Update (TFS-6836): Dynamics CRM Source now includes ActivityParty as a selectable entity.

Fixes:

  • Fix (TFS-6236): Timezone Conversion Transform incorrectly converted the 2014 DST dates for Santiago (listed as America/Santiago in the UI).
  • Fix (TFS-6289): SharePoint Source and Destination UI incorrectly displayed the encoded custom destination columns.
  • Fix (TFS-6315): SalesForce Source and Destination produced an XML error when using the Geolocation custom fields (these custom fields were recently introduced by SalesForce).
  • Fix (TFS-6448): SalesForce Destination failed to insert/upsert/update data when Opportunity object and bulk process mode were used together.
  • Fix (TFS-6546): Expression engine's "RegMatch" function incorrectly produced the error "specified argument was out of the range of valid values" when ignore case parameter was set to True.
  • Fix (TFS-6566): Expression engine's "RegExtract" and "RegReplace" functions contained an error in UI's example expression.
  • Fix (TFS-6591): Case Transform/Data Cleansing Transform improperly failed to capitalize addresses with "NE" directional suffix.
  • Fix (TFS-6602): Expression engine's "FileWriteAllBytes" function improperly displayed "conversion from 'String' to '1-dimensional array of Byte'" error on execution.
  • Fix (TFS-6630): File Properties Task incorrectly produced an "Illegal characters in path" error when using a valid Excel connection manager.
  • Fix (TFS-6634): SharePoint Destination incorrectly produced an "invalid value for column being updated" error when a custom column was included in the update/create
  • Fix (TFS-6640): Dynamics Destination improperly retained a batch size of 500 on execution even when changed in the UI.
  • Fix (TFS-6649): Expression engine's "IsNullOrEmpty" function does not appear in the expression editor's UI.
  • Fix (TFS-6652): Upsert Destination improperly displayed "Different datatype" warning even though the datatypes were the same.
  • Fix (TFS-6653): Upsert Destination advanced editor would crash the UI when selecting "Component Properties" tab followed by "Column Mappings" tab.
  • Fix (TFS-6677): SCD Dimension Merge did not support datetimeoffset datatypes for SCD1 and SCD2 changes *(datetimeoffset is NOTsupported as effective and expiry dates within the component).
  • Fix (TFS-6716): SalesForce connection manager failed to display the user credentials when it was closed and re-opened.
  • Fix (TFS-6717): Expression engine's "GetConnectionProp" function contained an error in the function's example.
  • Fix (TFS-6724): Expression engine's "Least" function incorrectly observed first value as an input rather than the case flag value.
  • Fix (TFS-6732): Expression engine's "Pv" (present value) function was missing the configuration details, description, and example in the UI.
  • Fix (TFS-6738): Oracle Upsert incorrectly produced an "ORA-00600: internal" error when processing various number of rows.
  • Fix (TFS-6758): Dynamics Source incorrectly produced an error when configuring a filter that returned no rows.
  • Fix (TFS-6790): Timezone conversion improperly converted all millisecond values to .000 when output column datatype was set to DT DBTIMESTAMP or DT DATE.
  • Fix (TFS-6793): Download File Task incorrectly produced "OK - No Content" error when the web service returned a 204 message thus causing the task to fail.
  • Fix (TFS-6837): Expression engine's "Fv" (future value) function example was missing from the UI.
  • Fix (TFS-6854): SalesForce Source was unable to connect to a remote server when the sandbox web service URL contained more than 1 separator "." that preceded "salesforce.com".
  • Fix (TFS-6890): Upsert Destination component failed to upgrade when BIxPress Auditing Framework was applied to packages.

Version 3.6.0.1018 [October 18, 2013]

Important:  If you are using any instances of Dimension Merge that use a Millisecond granularity and are using the SQL DateTime Max as the "last record's expiry date", this build could potentially cause issues with your data.

We have updated SQL DateTime Max to the correct value of 12/31/9999 23:59:59.997 from the incorrect value 12/31/23:59:59.999. This will cause your Dimension Merge to create new rows of data. 

New Features:

  • New Timezone Conversion Transform Allows SSIS developers to convert a date from one Timezone to another using the TZ Database for the IANA (see more).
  • New Oracle Upsert Destination An almost exact duplicate of our very popular Upsert Destination which allows SSIS developers to upsert data into an Oracle table (see more).
  • New SharePoint Documents Tasks Allows SSIS developers to upload and download documents from a SharePoint documents list (see more).

Updated Features:

  • Update Dimension Merge now has support for Type 0 Dimensions. It also now supports millisecond precision levels.

Version 3.5.0.329 [April 2, 2013]

New Features:

  • New Dynamics CRM Source Allows SSIS developers to retrieve data from Dynamics CRM Servers (see more).
  • New Dynamics CRM Destination Allows SSIS developers to send data to Dynamics CRM Servers (see more).

Updated Features:

  • Update SharePoint Connection Manager can now connect to online SharePoint servers (Live, Office 365).
  • Update SalesForce Destination now contains the ability to set column level external id's for referenced objects.

Version 3.2.0.0 [January 23, 2013]

Important:  Please read about our licensing changes here.

New Features:

  • New XML Generator Transform Allows SSIS developers to create XML documents based on XML's Schema (see more).

Fixes: 

  • Fix Fixed a Data Flow Nugger Transform issue where variables from the selected data flow task were not showing up on the "Map Variables" step.
  • Fix Fixed an Upsert Destination issue where opening the UI in disconnected mode caused an error (0x80131904) to be thrown.
  • Fix Fixed an Upsert Destination issue where Upsert was not properly updating data where the destination column was a date column, the destination was null and the incoming date was 1-1-1900.
  • Fix Fixed a SalesForce Source issue where the "Include Deleted / Archived Records" flag was being ignored when reinitializing metadata.

Version 3.1.0.0 [November 26, 2012]

New Features:

  • New Data Flow Nugget
    • Brings reusable packages to SSIS (see more).

Updated Features:

  • Update In Email Source, the BodyText property was changed to DT_NTEXT.
  • Update Added support for Bulk Inserts, Updates and Upserts in SalesForce Destination.
  • Update In Terminator Destination, a UI was added to allow users to choose included columns.
  • Update Added the ability to choose the SSL type in connection manager for SFTP Task.

Fixes:

  • Fix Fixed an Error Output Description issue with running it in SQL 2012.
  • Fix Fixed an Expression Based Tasks issue with DR_Decimal columns scale resetting to zero.
  • Fix Fixed To_Date function in Expressions Based Tasks.
  • Fix Fixed an issue with deleting connection managers in packages that have Expression Based Tasks contained in them.
  • Fix Fixed the Abort function in Expression Based Tasks.
  • Fix Fixed the SETVARIABLE function in Expression Based Tasks.
  • Fix Fixed the IIF statement in Expression Based Tasks.
  • Fix Fixed an Expression Based Tasks issue where the datatype does not show up in the UI.
  • Fix Fixed a Data Validation Task with "Value does not fall within the expected range".
  • Fix Fixed an SFTP Task issue with incorrectly calculating time-outs.
  • Fix Fixed the error "Value was either too large or too small for an unsigned byte"e; in Dimension Merge SCD.
  • Fix Fixed a SalesForce Source UI issue where SQL statement was enabled by default causing metadata issues.
v2

Version 2.3.0.0 [May 14, 2012]

Updated Features:

  • Update All Tasks are now supported in SQL 2012.

Fixes:

  • Fix Fixed an Address Parse issue where duplicate fields were created when the alias of the output column was changed.
  • Fix Fixed a SalesForce Source issue with parsing sub-queries.

Version 2.2.0.0 [March 5, 2012]

New Features:

  • New HTTP Download Task Download files from the internet without FTP over HTTP.
  • New Advanced Execute Process Task Execute processes as if you were using the command line SSIS. Allows for variable replacement in the commands. Allows multiple steps per instance of the task.
  • New Advanced Execute Package Task Execute child packages from within SSIS. Allows for the mapping of variables between the two packages.

Updated Features:

  • Update The Surrogate Key Transform has been updated to allow the user to save the sequence value to a database as well as reset sequence values and the recycling of sequence values.
  • Update The notification pane for Dimension Merge SCD was updated for easier viewing.
  • Update Added more granular address data including Street Number, Street Name, Street PreDirection, Street Post Direction, Suite Type, Suite Number, Box Type, Box Type Number, Box, Box Number in the Address Parse Transform.
  • Update Added Error Handling Output choice to the Address Parse Transform UI.
  • Update Added support in Advanced Email and SMS for variable replacement place holders in the subject.
  • Update Added Support in Advanced Email and SMS for the SMTP connection to not have a user name or password supplied.
  • Update Added the ability in SalesForce Destination to refresh the columns from the SalesForce object without having to drop and recreate the destination.
  • Update Added the ability in SalesForce Destination to grab the SalesForce ID of newly inserted rows.
  • Update SalesForce Source UI improved to make it easier to use.
  • Update Added error output to SalesForce Source.
  • Update Added an option in SalesForce Source to use only the object name rather than forcing the use of a query.
  • Update Added the ability to copy any action to all columns in Null Handler Transform, Case Transform, RegEx Replace Transform, Replace Unwanted Characters Transform, and Trim Plus Transform.
  • Update Updated Upsert Destination to handle null GUIDs values.
  • Update Updated Upsert Destination to handle null values in Column Compare mode.
  • Update Updated PGP Task to handle more encryption types.

Fixes:

  • Fix Fixed a Dimension Merge SCD issue where changing the SCD column type caused the window to refresh and lose it's place.
  • Fix Fixed Dimension Merge SCD to allow December 31, 1999 as a valid expiry date.
  • Fix Fixed an Email Source error where not selecting the connection manager caused the UI to fail.
  • Fix Prevented SMTP connection managers from being selected in the Email Source UI, this would cause the source to fail.
  • Fix Fixed a Data Validation Task issue where opening the task caused a "string was not recognized" error.
  • Fix Fixed a Data Validation Task issue where opening the task caused a "object not set to a reference" error.
  • Fix Fixed a SalesForce Destination error that was throwing the message ""'' is not valid for the type xsd:double".   "'' is not a valid value for the type xsd:date".
  • Fix Fixed a SalesForce Destination issue that caused the message "EXCEEDED_IT_LIMIT: record limit reached" error.
  • Fix Fixed a SalesForce Destination error that caused the message "Dictionary cannot be null. Parameter name: d".
  • Fix Fixed a SalesForce Destination issue where the External ID was not saving correctly.
  • Fix Fixed the SalesForce Destination error output to work correctly.
  • Fix Fixed an XML Destination issue where clicking the "Move row up" button caused an "object not set to a reference error".
  • Fix Fixed an issue that did not allow he user to select a variable as a replacement value in Null Handler Transform, Case Transform, RegEx Replace Transform, Replace Unwanted Characters Transform, and Trim Plus Transform.
  • Fix Fixed an SFTP issue where downloading text files in ASCII was not adding in the newline characters.
  • Fix Fixed an Error Output Description error that was causing "An entry with the same key already exists".

Version 2.0.1.0 [May 17, 2011]

Fixes:

  • Fix Fixed a SalesForce.com Connection Manager/Source/Destination issue where running the connection manager again the sandbox server where the source and destination could not retrieve objects from the server.

Version 2.0.0.0 [April 19, 2011]

New Features:

  • New Dimension Merge SCD Transform A "Kimball Method" component that is superior to the native Slowly Changing Dimension Transform.
  • New XML DestinationAllows the user to export XML within SSIS from source data.
  • New Replace Unwanted Characters Transform Allows the user to replace unwanted / invalid characters in a data source.
  • New NULL Handler Transform Allows the user to replace NULL or blank data from source data.
  • New RegEx Replace Transform Allows the user to replace data from source data with a regular expression
  • New TrimPlus Transform Allows the user to trim characters from the beginning and end of source data.
  • New Case Transform Allows the user to properly case source data using predefined algorithms.

Updated Features:

  • Update Added the option of using variables as part of the SOQL query in SalesForce.com Source.

Fixes:

  • Fix Fixed a SalesForce.com Source issue with not retrieving all the SalesForce columns.
v1

Version 1.5.8.0 [February 1, 2011]

Fixes:

  • Fix Fixed an Upsert Destination issue where upgrading from version 1.4 to 1.5 caused the task to not open correctly.
  • Fix Fixed a SalesForce.com Destination issue where invalid characters were apart of the XML document being sent to SalesForce.

Version 1.5.7.0 [January 7, 2011]

Updated Features:

  • Update Added support for use of the DTC for Upsert Destination, Update Batch, and Delete Batch.
  • Update Added new feature to Email Source to allow variables to be used in filters.

Fixes:

  • Fix Fixed an issue with Upsert Destination, Update Batch, and Delete Batch where changing the name of a connection manager caused the task to reset.
  • Fix Fixed a Compression Task issue with compression using BZ2: "[Execute] Error: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.".
  • Fix Fixed a SharePoint Connection Manager issue with not being able to use SharePoint Source or Destination with windows authentication.

Version 1.5.2.0 [December 6, 2010]

New Features:

  • New SharePoint Source SharePoint Source is used to retrieve data from a SharePoint server.
  • New SharePoint Destination SharePoint Destination is used to send data to a SharePoint server.

Updated Features:

  • Update Added support for Updates, Deletes, and Upserts in SalesForce.com Destination.
  • Update Added support for pulling embedded images out of emails in Email Source.
  • Update Added the ability to replace NULL text values from sources with empty strings in Address Parse. This fixes an issue where passing the string "NULL" into an address cause the address not to be parsed correctly

Version 1.4.10.0 [October 15, 2010]

Updated Features: 

  • Update Added support for sandbox URLs in SalesForce.com Connection Manager.

Version 1.4.9.0 [September 21, 2010]

Updated Features:

  • Update Added support for proxies with SalesForce.com Connection Manager.
  • Update Added Email Source support for deleting messages off the server (IMAP ONLY).

Fixes:

  • Fix Fixed an Email Source issue where an error would occur during processing which caused an EndOfRowSet error but did not display the true error.

Version 1.4.4.0 [September 10, 2010]

Updated Features:

  • Update Added a new SFTP Task action "Check if file exists on server" which allows the user to verify a file exists on a server.
  • Update Added a File Filter to the "Download directory from server" which allows the user to define a filter on the SFTP task to only download files that match a

Fixes:

  • Fix Fixed an SFTP Task error where downloading the directory from the server was not working for SSH.
  • Fix Fixed an issue where the new installation package was not properly installing the Task Factory files on some Windows 2003 machines.

Version 1.4.0.1 [August 9, 2010]

New Features:

  • New PGP Task With the use of Open PGP Technology, the PGP Task can be used to encrypt and decrypt files as well as creature and verify signature files using PGP.

Updated Features:

  • Update The new updates to Upsert Destination allow the user to choose their update model. This will allow the user greater control of how updates occur in the destination table and see the number of rows updated.
  • Update Provided a way in Upsert Destination to update the "Last Update" column in the destination table.
    Update Upsert Destination can now compare the data in selected columns to only perform an update if this columns do not match. This allows the user to also get an accurate count on how many rows were updated.
  • Update Upsert Destination can no perform updates by comparing a "last updated" column.

Fixes:

  • Fix Fixed an Upsert Destination "null data" issue when the identity column key data is null.
  • Fix Fixed an issue in Cleansing Transform where the OK and Cancel button's slide would not float when re-sizing the window.
  • Fix Fixed an Upsert Destination issue that did not allow mapping to read only columns.

Version 1.3.4.0 [June 30, 2010]

New Features:

  • New Address Parse Transform Used to parse unformatted address data into USPS standardized address data.
  • New Data Cleansing Transform Used to cleanse data from a source by applying up to 16 different data cleansing algorithms to the data.
  • New SalesForce.com Source Used to retrieve data from SalesForce.com objects.
  • New SalesForce.com Destination Used to send data to SalesForce.com object destination.

Updated Features:

  • Fix Fixed an issue where Delete Batch Transform allowed a negative time-out.
  • Fix Fixed an issue where Surrogate Key allowed a zero increment.
  • Fix Fixed an issue where Upsert Destination did not turn red when an error occurred.
  • Fix Fixed an Issue where Delete Batch Transform failed in the middle of a transform yet the package finished running instead of stopping.
  • Fix Fixed an issue where changing the connection manager in Upsert, Update Batch, and Delete Batch did not change the tables available in the task to reflect the new connection manager.
  • Fix Fixed an issue where LastWriteTimeUtc did not function correctly in File Properties Task.

Version 1.1.4.0 [November 10, 2009]

New Features:

  • New Surrogate Key Transform Used to add a unique identifier to a data flow. Allows the use of a variable to determine seed and increment.
  • New Email Source Used alongside an IMAP / POP3 connection to read e-mails from a mailbox. Supports most e-mail providers, including Gmail.
  • New Delete Batch Transform Will delete a batch of rows in a table based on the source and selected keys.
  • New Update Batch Transform Will update a batch of rows in a table based on the source and selected keys.
  • New Advanced Email and SMS Used to send HTML e-mails and/or SMS messages from within an SSIS Package.
    • Allows for the use of package and system level variables to be used within the messages.
  • New Terminator Destination Stops the flow of a data flow task without any configuration.

Version 1.0.3.0 [September 29, 2009]

Fixes:

  • Fix Fixed an issue where the installer did not copy files when the client tools for 2005 are installed by themselves.
  • Fix Fixed an issue where the help for Data Validation Form was unreadable.
  • Fix Moved the Task Action for the Compression Task to the general tab.
  • Fix Fixed an issue for Upsert Destination where text columns for NTEXT columns were garbled text.

Version 1.0.0.0 [September 9, 2009]

New Features:

  • New File Properties Task Used to read the properties (Creation time, Is File in use, Hidden, Read-only, et cetera) of an existing file.
  • New Compression Task Used to compress or decompress files and directories.
    • Supports *.Zip, *.Z, and *.Bz2 compression algorithms as well as self-extracting executables.
  • New Secure FTP Task Used to interact with a secure FTP site.
    • Supports SSH as well as Implicit and Explicit SFTP.
    • Supports HTTP, SOCKS4, SOCKS4a, and SOCKS5 proxies.
  • New Upsert Destination Used to conditionally insert or update data into a table.
  • New Data Validation Transform Validates data from a source with the use of regular expressions.
    • Regular Expression editor included as part of the UI.
    • Outputs the results of the data check in each row of the transform output.