Rajanand Ilangovan
Rajanand Ilangovan

Rajanand Ilangovan

Follow
Rajanand Ilangovan

Rajanand Ilangovan

5 followers

I'm a Business Intelligence Developer with over a decade of experience in design and development of databases, data warehouse, ETL, business intelligence reports and data visualization/analytics.

SSIS Error: Failed to open package file "T:\SSIS\Package.dtsx" due to error 0x80070003 "The system cannot find the path specified.".

Feb 2, 20232 min read

Problem: I was trying to execute the SSIS package through SQL Server Agent and got the error below. Error Message :Message Executed as user: NT...

SSIS Error: Unable to load the package as XML because of package does not have a valid XML format.

Jan 31, 20232 min read

Failed to open package file "\\sharepath\ssis\package.dtsx" due to error 0x80070005 "Access is denied.". · Problem: I was trying to execute the SSIS...

SSIS Error: Cannot create a task from XML for task, "task" type Microsoft.ExecuteProcess due to error 0x80070057 "The parameter is incorrect

Jan 30, 20232 min read

Failed to load task "sftp download", type "". The contact information for this task is "". · Background: I have created a SSIS package in visual studio...

Dashboard Inspirations

Jan 20, 20233 min read

Sample Dashboards from web · 1. Geckoboard Executive CEO dashboard CEO Overview Executive Summary CMO dashboard CFO dashboard Forecast...

Dashboard Inspirations

SQL Server Performance tuning and troubleshooting checklist

Dec 20, 20225 min read

Notes · I have recently come across a wonderful Video on SQL Server performance tuning and troubleshooting checklist by Kevin Kline. and created the...

How to search for a table or column in all the databases in a server

Nov 17, 20221 min read

Using T-SQL in SQL Server · To search for a table across databases in a server EXEC sp_MSforeachdb 'SELECT "?" AS DB, * FROM [?].sys.tables WHERE name...