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.
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...
Failed to open package file "\\sharepath\ssis\package.dtsx" due to error 0x80070005 "Access is denied.". · Problem: I was trying to execute the SSIS...
Failed to load task "sftp download", type "". The contact information for this task is "". · Background: I have created a SSIS package in visual studio...
Sample Dashboards from web · 1. Geckoboard Executive CEO dashboard CEO Overview Executive Summary CMO dashboard CFO dashboard Forecast...
Notes · I have recently come across a wonderful Video on SQL Server performance tuning and troubleshooting checklist by Kevin Kline. and created the...
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...