Registering multiple servers in Central Management Server (CMS) using PowerShell Script

  Below are the steps using PowerShell script (learned from another Kalyan Yella, Microsoft): Step 1: Open notepad and copy and paste below PowerShell script and save the file as “RegisterServers.ps1”  at c:\scripts\   — you can save anywhere you want – just make a note of it as you will use this in next step…

1

Importing Data from MS Access 2010 64-bit .accdb database into SQL Server using SSIS

  Problem: You can’t connect using Native OLEDB \Microsoft Jet 4.0 OLEDB Provider.  It fails with following error message: Test connection failed because of an error in initializing provider. Unrecognized database format ‘C:\Users\vishah\Documents\myDB.accdb’. Solution: Download 2007 Office System Driver: Data Connectivity Components from here – http://www.microsoft.com/downloads/en/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en then choose Microsoft Office 12.0 Access Database Engine OLE…

6