Displaying the most recent of 72 posts written by

nirav

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

Script to Remove Jobs History

Script to Remove Jobs History. You can remove jobs history for particular job for a fixed time. Below script will remove history data older then 30 days and where job name is “jobname”. I have used procedure “SP_PURGE_JOBHISTORY” provided by SQL Server, you just need to pass @JobName and @Date as a parameter. You can [...]

Script to get Jobs Execution Details

Script to get Jobs Execution Details. This script will give you whole execution details with job started time, job execution time, job finish time, and job execution status. Note: For multiple scheduled jobs it will fetche only last executed job details. You need to create one function for that with name “CONV_DATETIME”. Execute below script [...]

Script to get SSIS Jobs

Script to get SSIS Jobs. This script will help you out to get Job Details by category like SSIS,TSQL,etc..   Regards, Nirav Gajjar

Script to get Job Name from Command

Script to get Job Name from Command This script helps to get a job name from command or job script. If you remembered only one word that you have used in your job script and you want to get a job name, this script helps you. Just paste your word instead of “AnyOneWordFromJobScript”.   Regards, [...]

Script to get failed jobs

Script to get failed jobs Below is a TSQL query to get failed jobs last hour. if you want failed jobs for whole day then comment “AND Run_time >= @Ctime” line Regards, Nirav gajjar