About msbizoo
Hi All, MSBIZoo is published and maintained by Suvendu i.e. me :) I have graduated with B.Tech in Computer Science from one of the reputed engineering colleges in India.I also have 5 years of extensive experience on MSBI (SSIS and SSRS), datawarehouse and dimension modelling. Hope you like my posts!!!!
This gallery contains 7 photos.
Today we will be discussing on an interesting enhancement to SQL Server 2008 i.e. table valued parameters. What is a Table Valued parameter (TVPs)? TVPs are introduced in SQL Server 2008 which gives us another choice (Remember CTEs, Temp tables … Continue reading →
More Galleries
|
Tagged Advantages and disadvantages of table valued parameters, Bulk insert through table valued parameter, Bulk insert through TVP, New enhancement in SQL server 2008, Pass tables through a stored procedure, Pass TVPs through function, Table valued parameter, TVP advantages, TVP disadvantages, TVP limitations, TVPS, User defined table type
|
This gallery contains 10 photos.
Hello there! . In this post we will discuss how we can zip files available in different folder structure using SSIS. Prerequisite: Licensed version of Winzip 32 software Approach: Zipping of files can be done by loads of software such … Continue reading →