Categories
Sql Server

Cannot retrieve the column code page info from the OLEDB provider

Cannot retrieve the column code page info from the OLEDB provider Hi friends, recently I am working on SSIS package, in which we have to fetch data from SQL Server and send that data to oracle. But i am getting an error: Cannot retrieve the column code page info from the OLEDB provider. If the component […]

Categories
Sql Server

SQL Server 2012 Interview Question Answers

SQL Server 2012 Interview Question Answers Q: Difference Between DTS and SSIS. DTS SSIS DTS stands for Data Transformation Services 1.SSIS stands for Sql Server Integration Services DTS is a set of objects using an ETS tool to extract, transform, and load information to or from a database SSIS is an ETL tool provided by […]

Categories
Sql Server

SQL Server Database Mirroring in Domain Environment

SQL Server Database Mirroring in Domain Environment Hi friends, in this post we will discuss how to configure SQL Server Database Mirroring in Domain Environment. Earlier we have discussed How To Set Up Database Mirroring In Windows Workgroup. Here are some conditions to be meet to configure Database mirroing: For a mirroring session to be […]

Categories
Sql Server

How to Configure Scheduled Backup in SQL Server Express Edition

How to Configure Scheduled Backup in SQL Server Express Edition Hi friends in this post we will learn how to configure scheduled backup in sql server express edition. First of all let we all know that sql server express edition cannot use sql server agent, and all our scheduled task are done through sql server […]