Displaying posts categorized under

SSIS

SSIS Package with Dynamic ADO Connection

SSIS Package with Dynamic ADO Connection. I have created a package that collects database information from different instances all over the network and stored in one central database table. For this, I have collected Server Name, Database Name, Logical File Name, Physical File Name and File Size in MB. I have stored all instance info [...]

SSIS Package Foreach Loop with ADO Connection

SSIS Package Foreach Loop with ADO Connection. In my last blog i had written SSIS Package Foreach Loop with File Connection(Link: http://nirav.extreme-advice.com/2013/02/25/ssis-package-foreeach-loop-with-file-connection/). This package gives you same thing, variable mapping between Foreach Loop Container and any inner task contains in loop (here inner task is Script Task) but here i have used ADO Connection as [...]

SSIS Package Foreach Loop with File Connection

SSIS Package Foreach Loop with File Connection. This package gives you an idea to get file details and variable mapping between Foreach Loop Container and any inner task contains in loop (here inner task is Script Task). Step1 : Drag Foreach Loop and script task from SSIS Toolbox. Step2 : Create one variable with name [...]

SSIS Package to get Disk Space Info with WMI and Script Task

SSIS Package to get Disk Space Info with WMI and Script Task. In Previous blog i have created SSIS Package to get Disk Space Info with WMI.(Link: http://nirav.extreme-advice.com/2013/02/20/ssis-package-to-get-disk-space-info-with-wmi/) That was a simple way to gather disk space information with importing data in CSV file and exporting data in database. I have used same table in [...]

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 [...]