Solved

SSIS to export data in flat file

Posted on 2012-03-27
1
982 Views
Last Modified: 2012-04-10
Hi All,
1. While exporting data in a flat file I am looking for an  example to add column header, footer, number of records  using ssis 2008.
2. Is it possible to see if file already exists and rename it before writing a new file?
3. Delete any files extracted older than 30 days
4. I also need to package and schedule for automatic execution . How one can do it thru ssis deployment?

Thanks
0
Comment
Question by:crazywolf2010
1 Comment
 
LVL 21

Accepted Solution

by:
Jason Yousef, MS earned 500 total points
ID: 37774552
Hi,

1 & 2, what do you mean by exporting data in a flat file, is that means exporting TO flat file or importing from flat file?

I'll assume you mean exporting to flat file,  explain more about what you need? because you could rename your columns headers to whatever you want.

or you mean a custom header? if a custom header, see this link http://agilebi.com/jwelch/2008/02/08/adding-headers-and-footers-to-flat-files/


3-use that link and change the hours to 30 days, http://asqlb.blogspot.com/2011/08/ssis-process-files-that-has-been.html

4-to schedule a c package you'll use sql server agent, check that link http://decipherinfosys.wordpress.com/2008/09/17/scheduling-ssis-packages-with-sql-server-agent/

let me know which step you need more help with
Regards,
Jason
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

803 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