Reference Sites

How to read Multiple XML files in SSIS

http://stackoverflow.com/questions/6956409/ssis-reading-multiple-xml-files-from-folder

SSIS Error: Source is empty (while using foreach loop)

http://stackoverflow.com/questions/10336263/how-to-fix-source-is-empty-error-in-xml-source-while-using-foreach-loop-containe

SSIS The package contains two objects with the duplicate name of “output column “ErrorCode”

http://bturnip.com/nerdalerts/archives/146

Import multible tables into Dynamic Excel destinations

http://www.rafael-salas.com/2006/12/import-header-line-tables-into-dynamic_22.html

Connecting to MySQL from SSIS

http://blogs.msdn.com/b/mattm/archive/2008/03/04/connecting-to-mysql-from-ssis.aspx


clear existing data in excel and add new data using ssis
-----------------------------------------------------------

http://stackoverflow.com/questions/20658591/clear-data-in-excel-using-ssis


http://samuelhaddad.com/2009/03/31/overwriting-an-excel-file-destination-using-ssis/


Delete work sheet from excell using vb script in SSIS Script task
-------------------------------------------------------------------------

http://social.technet.microsoft.com/Forums/sqlserver/en-US/2cbed29e-e8e2-421b-a530-062fd2f599da/renaming-worksheets-of-an-excelsheet-using-ssis?forum=sqlintegrationservices


Expose SQL Server data through web service
------------------------------------------

http://www.c-sharpcorner.com/UploadFile/1d42da/a-xml-web-service-that-exposes-the-default-table-from-sql-se/

SQL Server connection strings
-----------------------------

http://forums.asp.net/t/1679046.aspx?How+to+Data+base+Connection+in+Sql


Lead/Lag
---------
http://blog.sqlauthority.com/2011/11/15/sql-server-introduction-to-lead-and-lag-analytic-functions-introduced-in-sql-server-2012/