Business Intelligence Documents

SSIS, SSAS, SSRS, T-SQL, Optimization, DTS, ETL strategy ,ETL packages, Troubleshooting, Data Modeling, Dimensional Modeling, Data Warehouse Design, Cube Design, OLTP, OLAP, XML

Thursday, February 2, 2017

Dealing with joins

I had worked a lot with Data warehousing and database projects. So many people working told me join is really easy. Left join, right join, ...

Error handling in SSIS

There are five way to do Error handling. 1. Event handler 2. Error redirection 3. Event Log or Error Log 4. Checkpoint usage 5. Trans...

Monday, January 11, 2016

Find empty file using C# and script task

While processing different types usually the issues occurs file empty!! It causes failure of package in production. to get rid of this issu...

Issues with space in file and folder name while passing as arguments in Execute Process Task

After working on VB.NET or C#.net console applications or other shell script, you had created executable. But while working on that you fin...

Thursday, December 17, 2015

Shrink database SQL Server

Shrinking database is one of best option to reduce log space after taking Full Backup. To do that we requires to change your database in si...

View web version

Contributors

Infoitec Software Solutions
Jatin Shah

Powered by Blogger.