#script task

[questpond]

This article will explain how we can send email using Script task component and how we can perform script task.

[questpond]

In this lab will demonstrate how to work with Script Component.

[dkvalz]

SSIS Importing and Validating Credit Card Data

SSIS Importing and Validating Credit Card Data

I spent a lot of my early career working with POS data. The irony of Point of Sale data is it is really was POS data. I spent a lot of time validating data all sorts of data, one of the big pain points was validating credit card data. When I decided to write a presentation that’s all about SSIS Scripting, the first demo idea that came to me was validating credit card data. In this blog post we…

View On WordPress

[dkvalz]

Simple SSIS: Date Formats

Simple SSIS: Date Formats

One feature that I would like to see added to SSIS is the ability to format a date string with a specified format. I have been tasked many times with outputting file names or folders with a specific date format, such as YYYYMMDD, and found myself writing custom functionality to accomplish this task. This is not difficult in T-SQL, but in SSIS it’s not all that easy. In this blog post I am going…

View On WordPress

[dkvalz]

SSIS Find Non-Imported Files

SSIS Find Non-Imported Files

Traversing a folder looking for files to import into a database table is a common practice using integration services. What if you have little control over the import folder or files because of security restrictions? What if there are many files stored in the folder and number of files grows daily? One way to deal with this is using a Foreach Loop Container, call to a database table or log and…

View On WordPress