Friday, March 22, 2013

Windows Phone 8 SDK on Windows 8 32-bit?

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

SFTP using SSIS 2008 & 2008 R2

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/

Note:

  • 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.