Sql Server 2005 BI Experience & Knowledge Sharing

This blog is specially for Microsoft SQL BI articles, tips and tricks. Some articles written here in Telugu language.

Wednesday, April 28, 2010

The "input "OLE DB Destination Input" (29)" failed because error code 0xC020907B occurred, and the error row disposition on "input "OLE DB Destination Input" (29)" specifies failure on error

Problem: I got below errors encountered when importing data into table Table1 though SSIS package. • [OLE_DES_Table1 [16]] Error: SSIS Err...

Wednesday, February 3, 2010

Exam 70-432 TS: Microsoft SQL Server 2008, Implementation and Maintenance Tutorial

The below site put all the required Microsoft stuff at one place. Check it. Prepare it. http://blogs.msdn.com/buckwoody/archive/2009/02/25...

Monday, December 7, 2009

Error 952 Database is in Transition

Problem DataBase In transition...Error 952 error. Solution : Restart Management Studio on client machine will solve this problem.

To Find List of Jobs, Last Run Status and Schedules

To find out lsit of jobs and thier details. SELECT J.Name ,CASE WHEN J.Enabled=1 THEN 'Enabled' ELSE 'Disabled' END AS...

Tuesday, November 3, 2009

SQL Server FAQ : Single line Answers

Log Shipping : Log Shipping provides a means to maintain a secondary server on an automated basis using a chain of transaction log backups. ...

View web version

Powered by Blogger.