Download and Install Microsoft Office Access Database Engine 2007 and restart the system
SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is availableFebruary 6th, 2013
Method 1 : set the 32 bit runtime environment using Project Properties -> Debugging -> Run64BitRuntime = False (in Visual Studio)
Method 2 : Open up the Agent Job -> Go to Steps -> Double click and Open the Step -> Go to Execution Options and Select Use 32 bit Runtime
TS into the machine on which SSAS is installed using Admin priviledges
Navigate to Start -> Administrative Tools -> Windows Firewall
Then Create Inbound Rules -> New Rule -> Port -> All Local Ports -> Allow the Connections -> Name the Rule and Click Finish
Then Create Outbound Rules -> New Rule -> Port -> All Local Ports -> Allow the Connections -> Name the Rule and Click Finish
Else create a Inbound Rule for Port 2383 and click on Finish
1.Click Start, and then click Run.
2.In the Open box, type cmd, and then click OK.
3.Type xcopy sourcedestination /O /X /E /H /K and then press ENTER, where source is the source path for the files to be copied, and destination is the destination path for the files.
For Example :
xcopy D:\Src \\Server2\Dst /O /X /E /H /K –Different Server
xcopy D:\Src E:\Dst /O/X/E/H/K — Same server
1.Click Start, click Run, type regedit, and then click OK.
2.Locate and then click the following registry subkey:
3.In the right pane, locate the ServicesPipeTimeout entry.
Note If the ServicesPipeTimeout entry does not exist, you must create it. To do this, follow these steps:
a.On the Edit menu, point to New, and then click DWORD Value.
b.Type ServicesPipeTimeout, and then press ENTER.
4.Right-click ServicesPipeTimeout, and then click Modify.
5.Click Decimal, type 60000, and then click OK.
This value represents the time in milliseconds before a service times out.
6.Restart the computer
Click on System Settings
Under Personal, double click on Keyboard Layout
Click on (+) symbol in the keyboard Layout window and select English(US)
Remove if any other Layout is present by selecting that layout and clicking on (-) symbol on the keyboard layout page.
Open Start – > All Programs ->Microsoft Office -> Excel 2007
Go to Excel Options on the Menu. Click on Advanced and then go to General Section.
Uncheck the checkbox for “Ignore other applications that use Dynamic Data Exchange (DDE)”
Click on OK
Open the Command prompt with administrator rights
Run the below command and prompted to deeleted ,enter Yes
tf workspace /delete [/server:servername] workspacename[;workspaceowner]
I changed my database Recovery model from simple to full. Then i tried to take the backup of the transaction log but got the above error.
Sol : Take the Full backup of the database and then try to take the backup of the log.
Click Start -> Control Panel
Open Administrative Tools
Open Local Security Settings
Click Software Restriction Policies
If no software restrictions are defined, right click the Software Restriction Policies node and select New Software Restriction Policy
Double click Enforcement
Select “All users except local administrators”
Reboot the machine