Friday, March 22, 2013
Windows Phone 8 SDK cannot be installed on Windows 8 32-bit machines instead it requires 64 bit. This is because Hyper-V Emulator can run only on 64 bit systems. Also because of 32 bit OS cannot address more than 3GB RAM.
Sunday, March 17, 2013
SSIS doesn't have a built-in component to support SFTP but the following codeplex component can be used or create a script task and write the SFTP file retrieval.http://ssissftp.codeplex.com/
- Copy the SSISSFTPTask100.dll to C:\Program Files(x86)\Microsoft SQL Server\100\DTS\Tasks\
- Register the SSISSFTPTask100.dll in the GAC using gacutil.exe (available under C:\Program Files(x86)\Microsoft SDKs\Windows\v7.0A\Bin)
- Open BIDS and click Tools > Choose Toolbox items > SSIS Control Flow Items > SFTP Task (Note: The SFTP Task will appear only if the SSISSFTPTask100.dll has been successfully registered in the GAC.