Shalini's Knowledge Share

SSIS

  • How to use the transformations in a Dataflow to optimize the performance

      In SSIS, we have many different kinds of transformations that we can use to cleanse and restructure our data in the way we want before sending to our destination. However, key thing to note is that behind our designer, all these transformations do not behave the same way. Each have their own way of Continue reading

  • SSIS Variables Vs Parameters

      Many people are quite confused on how parameters and variables work. However to clearly demonstrate the differences, you need to deploy a package in the SQL server. Parameters There are 2 types of Parameters: Package Parameters and Project Parameters. The only thing to that differentiates in these 2 types is the scope. Project parameters Continue reading

  • Accessing FTPS using SSIS

      Although there is a FTP task within native SSIS, it lacks both SFTP and FTPS tasks. There are 3 methods to access: 1. Using third party components – ex: zappySys, Cozyroc etc. 2. Purely code based 3. Using command line tools Using a third party component is pretty straightforward if you have an understanding Continue reading