Displaying posts categorized under

SQL Server

Microsoft Database Technology.

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

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