Vinod Kumar

Vinod has done his Bachelors in Mechanical Engineering from Anna University, Chennai (formerly known as Madras), India. He has been working on Microsoft Technologies for the past 4+ years. He is a Microsoft Most Valuable Professional (MVP) on SQL Server and a Microsoft Certified Professional. Going by the passion for MS Technologies, Certification exams has been one of his areas of interest and he has completed MCSA (2000, 2003), MCSE (2000), MCDBA, MCSD (VB, .NET), MCAD. More of his SQL Server expertise can be caught at the site he hosts www.ExtremeExperts.com. Vinod has initiated a SQL Server community in Bangalore, popularly known as the Silicon Valley of India. To capture more events on SQL Server, join the group at http://groups.msn.com/SQLBang which was formed as an initiative to bring PASS community in India.

All authors

Introduction to SSIS in SQL Server 2005

by Vinod Kumar

SQLServerCentral.com

DTS was one of the true innovations in SQL Server 7. SQL Server 2000 greatly enhanced this tool and SQL Server 2005 makes it truly a programming environment, well beyond the ETL functions of DTS in SQL Server 2000. New author Vinod Kumar gives a brief introduction to this new environment.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(18)

You rated this post out of 5. Change rating

2008-02-03 (first published: 2004-09-27)

167,679 reads

Discuss

All authors

Read the latest Blogs

Visit the forum

Question of the Day

Creating a JSON Document III

I have this data in a table called dbo.NFLTeams

TeamID  TeamName       City             YearEstablished
------  --------       ----             ---------------
1       Cowboys        Dallas           1960
2       Eagles         Philadelphia     1933
3       Packers        Green Bay        1919
4       Chiefs         Kansas City      1960
5       49ers          San Francisco    1946
6       Broncos        Denver           1960
7       Seahawks       Seattle          1976
8       Patriots       New England      1960

If I run this code, how many rows are returned?

SELECT TOP 2 
  json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;

See possible answers

Vinod Kumar

Introduction to SSIS in SQL Server 2005

Blogs

T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?

Understanding Fabric MCP

AWS RDS Aurora - our first approach

Forums

BCA KCU GUNSA 45 Hubungi.0821•3111•185

BCA KCP Mal Taman Anggrek No.Telponcs 083831618865

BCA KCP Kas Golden Vienna TLP/WA 082169777497

Question of the Day

Creating a JSON Document III