TechNet
Products
IT Resources
Downloads
Training
Support
Products
Windows
Windows Server
System Center
Internet Explorer
Office
Office 365
Exchange Server
SQL Server
SharePoint Products
Lync
See all products »
Resources
Curah! curation service
Evaluation Center
Learning Resources
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Script Center
Server and Tools Blogs
TechNet Blogs
TechNet Flash Newsletter
TechNet Gallery
TechNet Library
TechNet Magazine
TechNet Subscriptions
TechNet Video
TechNet Wiki
Windows Sysinternals
Virtual Labs
Solutions
Networking
Cloud and Datacenter
Security
Virtualization
Updates
Service Packs
Security Bulletins
Microsoft Update
Trials
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Related Sites
Microsoft Download Center
TechNet Evaluation Center
Drivers
Windows Sysinternals
TechNet Gallery
Training
Training Catalog
Class Locator
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
e-Learning overview
Certifications
Certification overview
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Other resources
TechNet Events
Second shot for certification
Born To Learn blog
Find technical communities in your area
Support options
For small and midsize businesses
For enterprises
For developers
For IT professionals
From partners
For technical support
Support offerings
For home users
More support
Microsoft Premier Online
Microsoft Fix It Center
TechNet Forums
MSDN Forums
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Sign in
SQL Server KBs and Blogs
Quick access to blogs posts from SQL Server Support Team., Some of the new KBs published for SQL and SQL Content news
Options
RSS for posts
Atom
RSS for comments
OK
Search Blogs
Tags
2008
2008 R2
ADAM
Alwayson
Connectivity
database engine
DBVideo
Engine
How It Works
Kerberos
NONSSIS
Performance
Reporting Services
SharePoint
SharePoint Adventures
SharePoint Integration
SQL 2005
SQL 2008
SQL 2012
SQL 2014
SQL Server 2008
SQL Server 2008 R2
SQL Server 2008 SP1
SQL Server 2012
SSIS
Archive
Archives
December 2014
(4)
November 2014
(5)
October 2014
(3)
September 2014
(1)
August 2014
(4)
July 2014
(5)
June 2014
(5)
May 2014
(5)
April 2014
(12)
March 2014
(3)
February 2014
(4)
January 2014
(2)
December 2013
(2)
November 2013
(14)
October 2013
(12)
September 2013
(6)
August 2013
(13)
July 2013
(10)
June 2013
(9)
May 2013
(9)
April 2013
(13)
March 2013
(15)
February 2013
(13)
January 2013
(3)
December 2012
(16)
November 2012
(4)
October 2012
(2)
September 2012
(10)
August 2012
(6)
June 2012
(7)
May 2012
(1)
April 2012
(4)
March 2012
(5)
February 2012
(5)
January 2012
(7)
December 2011
(1)
November 2011
(2)
October 2011
(4)
September 2011
(1)
August 2011
(4)
June 2011
(2)
May 2011
(2)
April 2011
(1)
February 2011
(2)
January 2011
(2)
December 2010
(2)
November 2010
(1)
August 2010
(1)
June 2010
(2)
April 2010
(1)
February 2010
(2)
January 2010
(2)
December 2009
(2)
August 2009
(1)
July 2009
(2)
May, 2014
TechNet Blogs
»
SQL Server KBs and Blogs
»
May, 2014
Featured
Subscribe via RSS
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
No blog posts have yet been created.
Sort by:
Most Recent
|
Most Views
|
Most Comments
Excerpt View
|
Full Post View
SSIS package fails with error : The step did not generate any output. The return value was unknown
Posted
7 months ago
by
SQL Server Support Content
One of my customers recently ran into a very strange issue. We had many SSIS Packages that were running as a SQL Server Job. But, off late we saw all the Jobs that were running a SSIS Package failed. All other SQL Jobs were executing without any issues
...read more
SSIS Packages executed from Visual Studio Business Intelligence Development Studio - BIDS [Design time] on a 64bit development server goes to unresponsive state during package execution.
Posted
7 months ago
by
SQL Server Support Content
Through the use of this blog, I would like to address a common scenario that you would run into when executing a complex SSIS package from within the BIDS environment in a x64 bit development server, where the visual studio- BIDS environment goes to a
...read more
UNVIPOT TRANSFORMATION WITH A COMBINATION OF SINGLE AND MULTIPLE DESTINATION COLUMNS
Posted
7 months ago
by
SQL Server Support Content
It is highly not uncommon that while using Unpivot Transformation in SSIS you feel the need to unpivot the columns to multiple destination columns along with single destination column. Dealing with them individually is easy but together is a little complicated
...read more
Capping CPU using Resource Governor – The Concurrency Mathematics
Posted
7 months ago
by
SQL Server Support Content
Here is what you need to know: A = πr 2 Okay, not really as that is the formula for the area of a circle but it does set the stage for this discussion. I have been working with the CAP_CPU_PERCENT (RESOURCE POOL) setting as it relates to concurrency
...read more
Can I decrypt TDE enabled database if I have access to the master database’s mdf and ldf files or the master database backup?
Posted
7 months ago
by
SQL Server Support Content
If someone gets access to the master database, i.e., if s/he can manage to copy the MDF, LDF or the master database backup, along with the USER database, will s/he also be able to decrypt the data? This was a question asked by one of our customers
...read more