Current a page to list out some notes that I have come across while working on an SSIS implementation.

Execute Process Task
- Cannot execute a task on a mapped network drive
-- Fixed by moving execute to local drive
- Maybe cannot through a network share
-- This was not tested

Problem: Copy/paste function no longer working on a remote desk desktop (ie RDP, mstsc) connection
Scenario: Windows XP Workstation to Windows 2003 Server
Solution: Restart rdpclip on remote desktop server
1. On remote desktop server, end process "rdpclip.exe"
2. Start > run, execute rdpclip.exe