![[http]](/moniwiki/imgs/http.png)
xp_cmdshell + dtexec(http://databaser.net/moniwiki/wiki.php/Xp_cmdshell%2BDtexec)![[https]](/moniwiki/imgs/https.png)
Integration Services (SSIS) Scale Out(https://docs.microsoft.com/en-us/sql/integration-services/scale-out/walkthrough-set-up-integration-services-scale-out)프로그래밍 방식으로 패키지 작성(http://msdn.microsoft.com/ko-kr/library/ms345167.aspx)Deploy SSIS 2012 projects using catalog.deploy_project Stored Procedure(http://blogs.msdn.com/b/mattm/archive/2012/12/06/deploy-ssis-2012-projects-using-catalog-deploy-project-stored-procedure.aspx)SSIS with AlwaysOn(http://blogs.msdn.com/b/mattm/archive/2012/09/19/ssis-with-alwayson.aspx)Export images from a SQL Server Table to a Folder with SSIS(http://www.mssqltips.com/sqlservertip/2693/export-images-from-a-sql-server-table-to-a-folder-with-ssis/)Trash Destination Adapter(http://www.sqlis.com/sqlis/post.aspx?id=a6d4de99-caf2-473e-9663-354d17325fab)Checksum Transformation(http://www.sqlis.com/sqlis/post.aspx?id=b895e44d-bd33-4e3e-ad5b-b31be3a736d5)Data Generator Source Adapter(http://www.sqlis.com/sqlis/post.aspx?id=ed6a8927-596f-4509-ab73-48546ad4ca55)Regular Expression Transformation(http://www.sqlis.com/sqlis/post.aspx?id=543a2422-e5ec-4c94-9730-1e26382536b4)Row Count Plus Transformation(http://www.sqlis.com/sqlis/post.aspx?id=087141f2-b820-484c-bd6c-e9ce9844d0b6)Row Number Transformation(http://www.sqlis.com/sqlis/post.aspx?id=a4c753cc-257b-4d1c-b18b-e0d82e74bb5f)File Watcher Task(http://www.sqlis.com/sqlis/post.aspx?id=59563053-79cc-4961-8b39-fbd629c645c9)
Optimized Bulk Loading of Data into OracleCDC for Oracle in SQL Server 2012(http://blogs.msdn.com/b/mattm/archive/2012/03/26/cdc-for-oracle-in-sql-server-2012.aspx)EzAPI – Alternative package creation API(http://blogs.msdn.com/b/mattm/archive/2008/12/30/ezapi-alternative-package-creation-api.aspx) --> ssis package를 프로그래밍 하여 만들 수 있다.PostgreSQL OLEDB Provider(http://www.pgoledb.com/)Execute a SSIS package in Sync or Async mode from SQL Server 2012(http://sqlblog.com/blogs/davide_mauri/archive/2011/11/24/execute-a-ssis-package-in-sync-or-async-mode-from-sql-server-2012.aspx)What’s New in SSIS for SQL Server 2012 RC0(http://blogs.msdn.com/b/mattm/archive/2011/11/17/what-s-new-in-ssis-for-sql-server-2012-rc0.aspx)A C#.NET toolkit for writing SSIS Script Tasks(http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/76439/)A VB.NET toolkit for writing SSIS Script Tasks(http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/76438/)SSIS T-SQL API Overview(http://blogs.msdn.com/b/mattm/archive/2011/08/12/ssis-t-sql-api-overview.aspx)The Project and Parameter Object Model(http://blogs.msdn.com/b/mattm/archive/2011/08/04/the-project-and-parameter-object-model.aspx)A CLR-resident JSON serializer/deserializer for SQL Server(http://www.sqlservercentral.com/articles/CLR/74160/) source code download(http://databaser.net/moniwiki_doc/JSON.SQL.zip)SQL Server Denali : Integration Services (SSIS) Enhancement – Video Tutorials(http://sqlserver-training.com/sql-server-denali-integration-services-ssis-enhancement-video-tutorials/-)The Data Loading Performance Guide(http://msdn.microsoft.com/en-us/library/dd425070.aspx)Integration Services Balanced Data Distributor(http://www.microsoft.com/download/en/details.aspx?id=4123)MongoDB and SSIS(http://www.zero1design.com/2010/07/07/mongodb-and-ssis/)Consuming JSON Strings in SQL Server(http://www.simple-talk.com/sql/t-sql-programming/consuming-json-strings-in-sql-server/) parseJSON.sqlHow to Import Data from HTML pages(http://www.simple-talk.com/sql/learn-sql-server/how-to-import-data-from-html-pages/)Managing Remote Processes Using Script Task(http://www.databasejournal.com/features/mssql/article.php/3927921/article.htm)How To Use Regular Expressions for Data Validation and Cleanup(http://www.mssqltips.com/tip.asp?tip=2297&home)SQL Server Metadata Toolkit 2008(http://sqlmetadata.codeplex.com/)Hidden SSIS Features: Word Wrapping Your Annotations And More(http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/71516/)TechNet Wiki(http://social.technet.microsoft.com/wiki/contents/articles/sql-server-integration-services-ssis.aspx)Data Profiling without SSIS(http://www.sqlis.com/sqlis/post/Data-Profiling-without-SSIS.aspx) DataCleaner(http://datacleaner.eobjects.org/)Microsoft SQL Server Community Samples: Integration Services(http://sqlsrvintegrationsrv.codeplex.com/releases/view/21238)Using the Script Component as a Conditional Split(http://www.sqlis.com/sqlis/post.aspx?id=140922bb-c132-48f6-aa8b-267dcb20124d)Import SSIS Project in Denali CTP1(http://www.sqlis.com/sqlis/post.aspx?id=7f76e2a3-0643-41ba-8c4c-f060d229e30c)Creating Dynamic Outputs in SSIS to an SQL Database(http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70980/)Top 10 SQL Server Integration Services Best Practices(http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70995/)Sending scheduled SQL query results via HTML e-mail using SSIS(http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/62678/)Passing Variable Values from Parent Package to Child SSIS(http://www.bidn.com/blogs/MikeDavis/ssis/155/passing-variable-values-from-parent-package-to-child-ssis)디스크모니터링_WMI.dtsx (SSIS 2008 R2) --> 디스크 모니터링SQL Server 2008,Windows 2008 x64 and Excel(http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70636/)Copy-and-Paste SSIS Execution Monitoring with Failure-Alert Email(http://www.sqlservercentral.com/articles/Execution+Logging/69858/)How to Access SSIS Remotely(http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70345/)SSIS – Unpack a ZIP file with the Script Task (http://sqlblogcasts.com/blogs/jorg/archive/2009/08/27/ssis-unpack-a-zip-file-with-the-script-task.aspx)"SQL 실행 작업" 의 결과셋의 순서로 "Foreach 루프 컨테이너" 를 돌리는 방법 Extending_SSIS_with_Custom_Tasks.zipSSIS 파일 삭제 템플릿SSIS 디스크 모니터링 템플릿SSIS 패키지 템플릿 ssis로그뷰어SSIS Slowly Changing Dimension Component(http://scd.codeplex.com/)ssisUnit(http://ssisunit.codeplex.com/)SSIS Log Analyzer(http://ssisloganalyzer.codeplex.com/)SSIS ReportGeneratorTask(http://reportgeneratortask.codeplex.com/)SSIS SMSTask(http://smstask.codeplex.com/)RegExtractor SSIS Component(http://regextractor.codeplex.com/)SSIS Download File Task(http://ssisdownloadfiletask.codeplex.com/)SSISDowngrade(http://ssisdowngrade.codeplex.com/)DTLoggedExec(http://dtloggedexec.codeplex.com/)SSIS Encode File Task(http://ssisencodefiletask.codeplex.com/)Replacing Data Conversion Component for SSIS(http://rdc.codeplex.com/)SSIS Rank Transform(http://ranktransform.codeplex.com/)Error Output's Description(http://eod.codeplex.com/)SSIS ImageSource(http://imagesource.codeplex.com/)Run SSIS Package Workflow Activity(http://runssisactivity.codeplex.com/)Execute a SQL Server Agent Job - SSIS Package(http://ssmsagentjobvbs.codeplex.com/)FluentETL - Data automation made easy for coders(http://fluentetl.codeplex.com/)Download Mail Task(http://downloadmailtask.codeplex.com/)ORAYLIS BI.Quality(http://biquality.codeplex.com/documentation)xmlify(http://xmlify.codeplex.com/)IIS Log reader(http://iislogreader.codeplex.com/)MobilePhoneAssistant(http://mobilephoneassistant.codeplex.com/)Normaliser Component(http://normalisercomponent.codeplex.com/)No SFTP Task Component in SSIS 2005/2008? No Problem!(http://www.sqlservercentral.com/articles/SSIS/69931/)HASHBYTES can help quickly load a Data Warehouse(http://www.sqlservercentral.com/articles/Data+Warehouse/69679/)New and Improved Functionality in SSIS 2008(http://www.databasejournal.com/features/mssql/article.php/3869561/article.htm)PostgreSQL Native OLEDB Provider(http://www.pgoledb.com)Run SSIS packages from remote client with stored procedure(http://www.sqlservercentral.com/articles/SQL+Server+2005/68790/)SQL Server Integration Services (SSIS) - Design Best Practices(http://www.mssqltips.com/tip.asp?tip=1893&home)VB.NET and C# Comparison(http://www.harding.edu/fmccown/vbnet_csharp_comparison.html#strings)Handling Slowly Changing Dimensions in SSIS(http://blogs.msdn.com/mattm/archive/2009/11/13/handling-slowly-changing-dimensions-in-ssis.aspx)SQL Server Integration Services (SSIS) - Design Best Practices(http://www.mssqltips.com/tip.asp?tip=1893)SQL Server Integration Services (SSIS) - Best Practices - Part 2(http://www.mssqltips.com/tip.asp?tip=1867)SQL Server Integration Services (SSIS) - Best Practices - Part 1(http://www.mssqltips.com/tip.asp?tip=1840)SSIS Community Tasks and Components(http://ssisctc.codeplex.com/)Common Codepages (출처: http://asp3wiki.wrox.com/wiki/i-3-0-common-codepages)How to Execute Oracle Parameterized Queries Using SQL Server Integration Services(http://www.mssqltips.com/tip.asp?tip=1787)How to Import Data from Microsoft Office Excel 2007 to SQL Server 2005(http://www.sql-server-performance.com/articles/biz/How_to_Import_Data_From_Excel_2007_p1.aspx)Download Connector/Net 6.0(http://dev.mysql.com/downloads/connector/net/6.0.html) (.Net 3.5 이상 필요, .Net 2.0은 5.x 버전 사용)HOWTO: Connect to MySQL in SSIS(http://www.ideaexcursion.com/2009/06/04/howto-connect-to-mysql-in-ssis/)Logging connection strings(http://www.sqlis.com/post/Logging-connection-strings.aspx)Using XML Data Type Methods to query SSIS Packages(http://sqlblog.com/blogs/peter_debetta/archive/2006/07/13/Using-XML-Data-Type-Methods-to-query-SSIS-Packages.aspx)SSIS Lookup using a Script Component(http://www.sqlservercentral.com/articles/SSIS/64766/)Improving Incremental Loads with Change Data Capture(http://msdn.microsoft.com/en-us/library/bb895315.aspx)Top 10 SQL Server Integration Services Best Practices(http://sqlcat.com/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx)Lookup cache modes(http://blogs.msdn.com/mattm/archive/2008/10/18/lookup-cache-modes.aspx)Calculating the size of your Lookup cache(http://blogs.msdn.com/mattm/archive/2008/10/18/calculating-the-size-of-your-lookup-cache.aspx)The Subsystems of ETL Revisited(http://www.intelligententerprise.com/showArticle.jhtml?articleID=202405400&pgno=1)ASP.NET의 정규식(http://www.microsoft.com/korea/msdn/library/ko-kr/dev/aspdotnet/regexnet.aspx#regexnet_topic2)Integration Services Data Types(http://msdn.microsoft.com/en-us/library/ms141036.aspx)Using the Script Component to Execute PL/SQL Code in an Oracle Package from SQL Server Integration Services (SSIS)(http://www.mssqltips.com/tip.asp?tip=1448)CozyRoc SSIS+ 1.3 Library(우와~)(http://www.cozyroc.com/products.html)SSIS 2008 Data Profiler(http://www.sqlservercentral.com/articles/Integration+Services/64133/)SSIS: Data Profiling Task: Part 1 - Introduction (http://blogs.conchango.com/jamiethomson/archive/2008/03/02/ssis-data-profiling-task-part-1-introduction.aspx)SSIS: Data Profiling Task: Part 2 - Column Length Distribution (http://blogs.conchango.com/jamiethomson/archive/2008/03/02/ssis-data-profiling-task-part-2-column-length-distribution.aspx)SSIS: Data Profiling Task: Part 3 - Column Null Ratio (http://blogs.conchango.com/jamiethomson/archive/2008/03/02/ssis-data-profiling-task-part-3-column-null-ratio.aspx)SSIS: Data Profiling Task: Part 4 - Column Pattern (http://blogs.conchango.com/jamiethomson/archive/2008/03/02/ssis-data-profiling-task-part-4-column-pattern.aspx)SSIS: Data Profiling Task: Part 5 - Column Statistics (http://blogs.conchango.com/jamiethomson/archive/2008/03/02/ssis-data-profiling-task-part-5-column-statistics.aspx)SSIS: Data Profiling Task: Part 6 - Column Value Distribution (http://blogs.conchango.com/jamiethomson/archive/2008/03/03/ssis-data-profiling-task-part-6-column-value-distribution.aspx)SSIS: Data Profiling Task: Part 7 - Functional Dependency (http://blogs.conchango.com/jamiethomson/archive/2008/03/03/ssis-data-profiling-task-part-7-functional-dependency.aspx)SSIS: Data Profiling Task: Part 8 - Candidate Key (http://blogs.conchango.com/jamiethomson/archive/2008/03/04/ssis-data-profiling-task-part-8-candidate-key.aspx)SSIS: Data Profiling Task: Part 9 - Value Inclusion (http://blogs.conchango.com/jamiethomson/archive/2008/03/07/ssis-data-profiling-task-part-9-value-inclusion.aspx)SQL Server 2008- SSIS Data Profiling task(http://www.simple-talk.com/sql/learn-sql-server/sql-server-2008--ssis-data-profiling-task/)![[-]](/moniwiki/imgs/plugin/arrup.png "[-]")
![[+]](/moniwiki/imgs/plugin/arrdown.png "[+]")