?
Solved

SSIS Scipt Task - file copy with append

Posted on 2009-05-20
3
Medium Priority
?
825 Views
Last Modified: 2013-11-10
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)
0
Comment
Question by:hockmanc
  • 2
3 Comments
 
LVL 22

Accepted Solution

by:
PedroCGD earned 2000 total points
ID: 24455498
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 24471606
Improvements?!
0
 

Author Closing Comment

by:hockmanc
ID: 31583616
Thanks for your help!
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Suggested Courses

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question