Solved

SSIS to export data in flat file

Posted on 2012-03-27
1
976 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:
huslayer 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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

Suggested Solutions

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…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

743 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