The most recent content from our members.
When it comes to Task Factory, one of the most common questions I'm asked is, "How can I upgrade my SSIS packages with Task Factory components?" I'll walk you through each step of the upgrade process and explain why you should adhere to these best practices. Step 1: Back Up Projects Back up all projects! This is arguably…
When Microsoft first introduced how to install third-party components, such as SentryOne Task Factory, on an Azure-SSIS Integration Runtime (IR) in Azure Data Factory (ADF), I thought, "This could be a bit difficult for some users." At the time, you had to write a PowerShell script (Execute PowerShell Scripts in SSIS…
SQL Server Integration Services (SSIS) is Microsoft's long-standing ETL product that, with a little skill and effort, can be highly configurable and provide for a broad set of options when it comes to data warehousing and data integration. With some coding knowledge, time, and effort, you can integrate data and systems…
With Task Factory 2019.4.2, the SharePoint Destination can delete documents from a SharePoint documents list. To do so, the SharePoint SOAP API requires the ID and full URL path to the document(s) you want to delete. Due to API limitations, the Task Factory SharePoint Source does not return each document’s fully qualified…
As a product manager, I need to understand what pain points plague data professionals. Interacting with the customers I serve is an excellent way to accomplish this. Earlier this summer, I had the opportunity to connect with SentryOne customer—and brilliant Applegate BI Developer—Matt Cushing. As a bright engineer and…
I have a package in which the first task is to obtain a password for use by a project level SFTP connection manager. It doesn't work as I get authentication errors. If I use a package connection manager, it works fine. Should I be able to do this?
I'm sure this has been asked and answered but I can't find it. I want to build an expression for the body of an email that requires two lines.I want something like this: This is the first line. And this is the second line. So my expression is going to be something like "This is the first line." & "This is the second line."…
When uploading a document to a SharePoint document library (with the Sharepoint Documents task), is it possible to supply metadata for the columns defined in the document library? If so, how? And it not, seriously?
It has been some time since Task Factory 2023.3 release. I am interested in knowing if the compatibility issue resolution has an ETA? I am very much looking forward to being able to use Visual Studio 2022 and Upgrading to SQL Server 2022.
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…
It looks like you're new here. Sign in or register to get started.