<div>
<div class="content wysiwyg-content">
In SSIS I need to accomplish: &nbsp;copy file1 + file2, file1<br />
<br />
Have had success copying using a vbscipt, but not when it comes to appending a file to another. &nbsp;Would prefer to use the Scipt Task as opposed to xp_cmdshell if possible.<br />
<br />
(using SQL 2005)
</div>
</div>


In SSIS I need to accomplish:  copy file1 + file2, file1

Have had success copying using a vbscipt, but not when it comes to appending a file to another.  Would prefer to use the Scipt Task as opposed to xp_cmdshell if possible.

(using SQL 2005)

SSIS Scipt Task - file copy with append

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.