Monday, February 29, 2016

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.

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





Tuesday, February 23, 2016

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’
iXqHJld[1]


Monday, February 1, 2016

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.