Create script task in SSIS

One of the efficient way to extend SSIS control flow is to create  script task. 

Need : We can perform custom task that cannot be performed using default task

Steps involved

1) Select the script task from the toolbox

 

Running angular applications in IE 8 and other browsers

We recently published a angular application to production. There was couple of tickets created with "Application failing in Enterprise mode in IE" . 

Fetch all files from FTP or DFTP Site

There could be business need where we need to get all the files from the secured or non secured servers. which includes folders and sub folders. This can be done easily by using Task factory secured FTP site.

The steps involved in this task

1) Fetch the Task factory task from the toolbox

Add Expressions in SSIS

We can easily add expressions for our connection manager. This can be achieved as shown below

Steps involved

1) Select the connection manger which needs to have an expression

Batarang chrome extensions for debugging angular applications

As we are using angular to develop SPA applications, this chrome extension would be helpful for debugging.

You can add this to your chrome extension from here.

https://chrome.google.com/webstore/detail/angularjs-batarang-stable/niopocochgahfkiccpjmmpchncjoapek?hl=en-US

Advantages.

1   1) We would be able to visually select the scope

PGP Tutorial For Windows (Kleopatra – Gpg4Win)

The security of your data is the most important thing. The focus of Gpg4win is on secure file and email encryption as well as good usability.

Part 1.  Installing Kleopatra 

1. Head on over to https://gpg4win.org/download.html. We want the full version, so click ‘Gpg4win 2.2.3’

Custom Csv import for angular UI-Grid

We can have a customized csv import for angular UI-Grid.

Integrate task factory in BIDS

Task Factory offers essential, high-performance components and tasks for SSIS that eliminate the need for programming. With over 50 components, Task Factory can increase productivity, improve performance and increase your ROI.