Blog Archives

Automating Deployment of SQL Server Maintenance Plans

Introduction SQL Server maintenance plans provide automated backups of SQL Server databases. What if you want the same maintenance plan to be deployed to one or more additional servers? The deployment can be automated as explained here using SQL Server

Tagged with: , , , , ,
Posted in Development

SSIS 2012 Package Editing using Visual Studio 2012

When attempting to open an SSIS package created by Sql Server Data Tools from the Sql Server 2012 install, using Visual Studio 2012, the text (incompatible) appears beside the project name and the package icon appears with a blue circle

Tagged with: ,
Posted in Development

OLE DB provider SQLNCLI.1 is not registered

If you get the following error while trying to run an SSIS package on SQL Server 2012. The requested OLE DB provider SQLNCLI.1 is not registered. If the 64-bit driver is not installed, run the package in 32-bit mode. error

Tagged with: ,
Posted in Development

Using Sql Server Integrations Services (SSIS) with Identity Columns

What do you do when you have to transfer data into an Identity column when you already have the identity values filled in the source? Do you?  a) change the schema to remove the identity column, transfer the data and

Tagged with:
Posted in Development

The Empty Toolbox – SSIS 2012

I stared at this toolbox in disbelief. White and spacious with a confirming message that gave me no comfort: “There are no usable controls in here … “. What happened to the Source Assistant? Where in the world is the

Tagged with:
Posted in Development