One thing missing from the SSIS PowerShell task is the ability to write *from within the script* to SSIS variables. Here's an example: $d=get-date -f yyyyMMddHHmmss $filename="/path/to/folder/file_$d" # We'd like to use this filename variable--which was created within the PS script--in SSIS later # so we want to be…
My organization, and many others, are increasingly moving their database solutions to the cloud. It would be extremely useful if Task Factory included the ability to create connections in SSIS to be able to pull/ push data from Snowflake or other cloud services.
The Surrogate Key Transform is very useful to generate a running row counter across all processed rows within a data flow path. However, it is not useable when the counter needs to be reset when a change happens within a data set. E.g.: I need to create order line numbers and the counter needs to reset when the order…
As per the "TF Secure FTP Task", it would be useful to extend the "TF SharePoint Documents Task" to include the "Get list of files" / "Get list of files with metadata" actions. This would enhance the functionality to handle: - upload only if the file isn't there - download file only if it has changed just as a couple of…
The TF (MSSQL) Upsert destination transform has the ability to pass error rows to (for instance) a flat file for error handling. The Oracle Upsert destination, however, appears to lack this functionality. It would be really great to have the ability to redirect error rows from the Oracle upsert destination, giving us the…
Most of our configurations call for Slowly Changing Dimension Type 2 Historical data changes (SCD2.) Rarely do we use Type 1, only when 1 column is updated daily such as a timestamp column. The current default in the Dimension Merge SCD is SCD1 Type 1 changes. Sometimes our source systems have very wide tables, more than…
Currently the Task Factory email connection supports only POP3 and IMAP protocols. Both of those protocols are insecure by today's security standards and many email providers have plans to soon deprecate their support for them. I request that the email connection be modified to use Modern Authentication (based on ADAL and…
Please enable a limitation of emails to be collected per use of EmailConnectionManager or EmailOAuth2ConnectionManager. Imagine you have thousands of emails in your mailbox and you want to process only 50 of them per package run. We are getting thousands of electronic invoices with attached PDF files day by day and often…
When decompressing a file in Task Factory, it would be helpful to be ably to apply a filename filter. I often have huge zips containing a few thousand files and I only need a small subset (20 - 30). I currently have to decompress everything (which takes a while) and uses disk space in order to just get 20-30 files. Thanks,…
It looks like you're new here. Sign in or register to get started.