Creating Header AND Footer to a flat file destination file

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Creating Header AND Footer to a flat file...

49 posts, Page 2 of 5

««1 2 3 4 5 »»»

Creating Header AND Footer to a flat file destination file

Rate Topic

Display Mode

Topic Options

Author

Message

John Rowan

Posted Tuesday, September 14, 2010 9:53 AM

Hall of Fame

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 10:54 AM
Points: 3,837, Visits: 3,821

Set your variable up to Evaluate as Expression and use the expression builder to add the carriage returns into your variable.

"This " + "\r is " + "\r a " + "\r test"

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden

Post #985641

preensheen

Posted Wednesday, September 15, 2010 8:56 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, February 07, 2011 1:58 PM
Points: 90, Visits: 221

when select [flatfile].[HEADER] for the data flow task.
Then in the expression, I am trying to give CR\LF but the expression doesn't get validated can you please show me an examplE with a screen shot.

Thanks

Post #986350

John Rowan

Posted Wednesday, September 15, 2010 9:09 AM

Hall of Fame

Group: General Forum Members
Last Login: Tuesday, January 29, 2013 10:54 AM
Points: 3,837, Visits: 3,821

Please post your expression.

John Rowan

======================================================
======================================================
Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden

Post #986366

preensheen

Posted Wednesday, September 15, 2010 9:21 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, February 07, 2011 1:58 PM
Points: 90, Visits: 221

Hitting enter doen't really works

Post #986386

Phil Parkin

Posted Wednesday, September 15, 2010 9:26 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 9:18 AM
Points: 4,238, Visits: 9,478

preensheen (9/15/2010)

Hitting enter doen't really works

Is that your expression?

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #986402

preensheen

Posted Thursday, September 16, 2010 7:54 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, February 07, 2011 1:58 PM
Points: 90, Visits: 221

Hey jhon,

Thanks, so much Smile

It worked out. It solved my problem.

Post #987264

preensheen

Posted Thursday, September 16, 2010 11:33 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, February 07, 2011 1:58 PM
Points: 90, Visits: 221

Hey, Is there a way that we can bold the headers for the flat file.

Post #987523

preensheen

Posted Thursday, September 16, 2010 11:36 AM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, February 07, 2011 1:58 PM
Points: 90, Visits: 221

There was some problem yesterday and I was not able to view all your replies and was going on posting my problems..Sry about that

Post #987525

barb0822

Posted Tuesday, February 15, 2011 6:46 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, April 09, 2013 5:37 AM
Points: 4, Visits: 94

i have a job that is reverse of this topic but involves parsing out a ragged flat file details from the header and footer. there are two headers, two details, two footers.
header1=Header000
detail data
footer1=Trlr 1111 records
header2=Header000
detail data
footer2=Trlr 2222 records.
How can I get the details into a Sql Table without the header and footer. The row delimited is crlf with no text qualifyer. I am having difficulty getting this to work. Any help appreciated.

Post #1064672

paterjean

Posted Friday, March 25, 2011 2:23 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, March 25, 2011 2:21 PM
Points: 1, Visits: 6

Hi John Dempsey,
All i want to say is AWESOME !!!
AWESOME post saved lots of my time like a day or two.
Thanks a LOT again..

Post #1084351

« Prev Topic | Next Topic »

49 posts, Page 2 of 5

««1 2 3 4 5 »»»

Permissions