PowerShell 2008

http://www.sqlservergeeks.com/blogs/piyush.bajaj.2007/sql-server-bi/113/sql-server-powershell-in-sql-server-2008-part-i

http://www.sqlservergeeks.com/blogs/piyush.bajaj.2007/sql-server-bi/120/sql-server-powershell-in-sql-server-2008-part-ii

http://www.sqlservergeeks.com/blogs/piyush.bajaj.2007/sql-server-bi/121/sql-server-powershell-in-sql-server-2008-part-iii


http://www.sqlservergeeks.com/blogs/sarab/sql-server-bi/214/how-to-enable-powershell-feature-in-windows-server-2008-r2

Installation steps for SQL Server 2008 R2

http://www.sqlservergeeks.com/articles/sql-server-bi/32/installation-guide-for-sql-server-2008-r2

One-click Deploy SSIS Package from Visual Studio to SQLServer

http://blog.boxedbits.com/archives/25

SSIS Packages deployment

http://decipherinfosys.wordpress.com/2008/09/16/deploying-ssis-packages-in-sql-server-2005/

There are two options available for us to deploy the SSIS Packages.

a) File System Deployment:

As the name suggests, this option allows us to deploy the SSIS Project to the File System i.e. a physical location on the hard disk on the target server. If this option is chosen, we have to back up the SSIS Packages manually every night for any disaster recovery.

b) Sql Server Deployment:
This option allows us to deploy the SSIS project to the SQL Server i.e. on the MSDB database. Since the msdb is usually backed up every night, this method of deployment saves us some extra work of backing up the SSIS Packages manually if deployed using the file system.

SSIS Packages execution  options:


Syntax:   dtexec /option [value] [/option [value]]...
1. Command prompt

dtexec /f "c:\pkgOne.dtsx"  --File system

dtexec /sq pkgOne /ser productionServer -- SQL Server

2. Using the xp_cmdshell extended stored procedure by using the dtexec command line utility

EXEC xp_cmdshell 'dtexec /f "C:\UpsertData.dtsx"'

3.Using BIDS

Could not save the package "D:\Test\Deployment1\Package2.dtsx" to SQL Server "(local)".

Error while deplying the SSIS Packag: Could not save the package "D:\Test\Deployment1\Package2.dtsx" to SQL Server "(local)".
The SaveToSQLServer method has encountered OLE DB error code 0x80004005 (Login timeout expired).  The SQL statement that was issued has failed.

Solutuon:  http://msdn.microsoft.com/en-us/library/ms137789.aspx

Modify the MsDtsSrvr.ini.xml, file ( ServerName\InstanceName)
,which is located in the folder, %ProgramFiles%\Microsoft SQL Server\100\DTS\Binn.