Category Archives: Uncategorized

Table Valued Parameters – SQL Server 2008

Posted on August 26, 2012 by msbizoo

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 | 1 Comment

Zip utility through SSIS

Posted on August 19, 2012 by msbizoo

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 →

More Galleries | Tagged Execute process task SSIS, SSIS, SSIS 2008 R2, Winzip and SSIS, Zip file utility through SSIS, Zip files through execute process task, zip files through SSIS | 5 Comments

	msbizoo on Zip utility through SSIS
	Thato on Zip utility through SSIS
	Thato on Zip utility through SSIS
	sushma.koyi on Table Valued Parameters…
	msbizoo on Zip utility through SSIS

Category Archives: Uncategorized

Table Valued Parameters – SQL Server 2008

Zip utility through SSIS

Recent Posts

Recent Comments

Archives

Categories

Meta