Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12345»»»

Creating Header AND Footer to a flat file destination file Expand / Collapse
Author
Message
Posted Tuesday, September 14, 2010 9:53 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, December 8, 2014 1:04 PM
Points: 3,840, Visits: 3,854
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
Posted Wednesday, September 15, 2010 8:56 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, February 7, 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
Posted Wednesday, September 15, 2010 9:09 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, December 8, 2014 1:04 PM
Points: 3,840, Visits: 3,854
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
Posted Wednesday, September 15, 2010 9:21 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, February 7, 2011 1:58 PM
Points: 90, Visits: 221
Hitting enter doen't really works
Post #986386
Posted Wednesday, September 15, 2010 9:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 11:18 AM
Points: 5,316, Visits: 12,346
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.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

It is better to keep your mouth shut and appear stupid than to open it and remove all doubt. (Mark Twain)
Post #986402
Posted Thursday, September 16, 2010 7:54 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

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

Thanks, so much

It worked out. It solved my problem.
Post #987264
Posted Thursday, September 16, 2010 11:33 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, February 7, 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
Posted Thursday, September 16, 2010 11:36 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, February 7, 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
Posted Tuesday, February 15, 2011 6:46 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, December 14, 2014 7:43 PM
Points: 4, Visits: 119
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
Posted Friday, March 25, 2011 2:23 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase ««12345»»»

Permissions Expand / Collapse