Solved

SSIS to export data in flat file

Posted on 2012-03-27
1
988 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

734 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