Solved

DTS : Append Data.

Posted on 2003-12-11
8
1,020 Views
Last Modified: 2013-11-30
Hi ,
 Is there any way to Append data(in MSSQL Table) into text file in Dts.? (without running any .exe, .bat)

Regards
D.
0
Comment
Question by:dishanf
  • 3
  • 3
8 Comments
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 9926846
Assuming that it creates a new file everytime you data pump into a text file (not sure as I can't test)

1. You could use an ActiveX task to append two files together

OR

2. You can use the Execute process task to append two files using COPY File1.TXT + File2.TXT OutputFile.TXT


Let me know if you want more detail
0
 
LVL 34

Accepted Solution

by:
arbert earned 100 total points
ID: 9928569
Can't do it with the built in text file destination.  You could setup a Microsoft OLEDB driver for text files and do it or use nmcdermaid's workaround.
0
 
LVL 34

Expert Comment

by:arbert
ID: 9946960
Why the grade of a C?  
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 8

Author Comment

by:dishanf
ID: 9947014
Sorry arbert. missfired
0
 
LVL 34

Expert Comment

by:arbert
ID: 9947256
Cool, you can post a question in CS to do what's appropriate....
0
 
LVL 8

Author Comment

by:dishanf
ID: 9954321
OK . Give Grade "A" to arbert.
0
 
LVL 8

Author Comment

by:dishanf
ID: 9955809
Can I close or Delete this thing.?
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
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 backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

744 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now