Grab your computer and get registered for SQL Saturday 85 in Orlando. If you’re new to the SQL world and have never heard of SQL Saturday, it is a free event put on by the SQL community…for the SQL community… This is an opportunity to learn new things and brush up on some of those less frequently used. Shawn McGeehee and others have worked very hard to make this a really great event, so click on one of the links below and register. At this event, I will be giving a talk at 4P...
Read More
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use the Surrogate Key Transform to generate a new surrogate key while in the data flow. Here are the key features and details from PragmaticWorks.com about this task: Adds an identifier column to a data flo...
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use the SFTP Task to securely perform various file transfer tasks such as download or upload a file to a remote server. You can also do things like download a complete directory, remove files and create dir...
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use the Email Source and Delete Email task to search through and remove emails from an email server. Here are the key features and details from PragmaticWorks.com about this task: Reads email from a mailbox...
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use the Data Validation Transform to verify that data is consistent before loading it into a database. I’ll also show you how to create a regular expression for a date value in integer format. For exa...
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use the Data Cleansing Transform to correct some data before it gets put into a destination. Here are the key features and details from PragmaticWorks.com about this task: Used to cleanse data from a source...
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use the Compression Task to zip and unzip a file. Here are the key features and details from PragmaticWorks.com about this task: Compresses or decompresses a file or directory. Many companies struggle with ...
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I am going to show you how to use the Address Parse Transform available in Task Factory to parse address related data and convert it into a Standardized US Postal Services format. For key features and details check out PragmaticWorks.com to ...
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use the Terminator Destination be used as a way to test and view the data before performing more transforms or dumping into a destination. This component is completely free and can be downloaded on Pragmati...
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use the File Properties task to check to see if a file exists before attempting to load it into a SQL Server database. Here are the key features and details from PragmaticWorks.com about this task: Reads th...
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating SSIS packages become more efficient. And as we all know, when we are more efficient, we are more productive. In this nugget, I’m going to show you how to use the Advanced Email and SMS Task. Yeah, that’s right, I said SMS. You can even send a message to a mobile device on any carrier service or using POP3, IMAP or SMTP Here are the key features from Pr...