Month: March 2008

  • Importing Excel Into SQL Server Using SSIS

    I ran into an issue the other day while importing data from an Excel file into SQL Server 2005. I had columns that contained fields that have more than 255 characters. When running the import, SSIS failed because it kept truncating the fields which caused the task to fail. It fails because the Microsoft Excel…

  • Enable Remote Desktop Remotely

    This is a great tip to enable remote desktop: 1. Open the registry editor: Start –> Run –> regedit –> OK 2. Select the Connect Network Registry option under the File menu and find the machine you want to connect to. 3. Goto this key: HKLM\SYSTEM\CurrentControlSet\Control\Terminal Server 4. Under the Terminal Server key, you’ll find…

  • Disable The Windows 2003 Shutdown Event Tracker

    Type ‘gpedit.msc’ at the command line Open this policy and click on ‘Disabled’ and then click ‘OK’. To force this changes instead of rebooting just open a command window and type: ‘gpupdate /f’ to force the changes.