Displaying posts tagged with

“SSIS”

SSIS Package to get Disk Space Info with WMI

SSIS Package to get Disk Space Info with WMI. I have created package that gives Disk Space info using WMI Data Reader Task. You need minor knowledge on WMI Query and WMI Class, here i have used “Win32_LogicalDisk” WMI class. This package checks disk info for logical disk of your machine and stores value to [...]

SSIS Package to Resize image

SSIS Package to Resize image. This script helps you to resize images as you needed in percentage(Dynamically). Step1 : drag n drop foreeach loop container. Step2 : drag n drop script task in to foreach loop container. Step3 : Right click on any part of your control flow and select variables to see list of [...]

SSIS Package to Read IISLog

SSIS Package to Read IISLog You need LogParser 2.2 installed on your machine. I need iislog every 1 hour so i have set this package to execute every hour and imports second last files to database. Before you start creating package you have to create one batch file and one table. Step1 : First of [...]