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: Tuesday, August 19, 2014 10:01 AM
Points: 3,844, Visits: 3,841
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: Tuesday, August 19, 2014 10:01 AM
Points: 3,844, Visits: 3,841
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: Yesterday @ 7:23 AM
Points: 5,074, Visits: 11,852
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.
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: Friday, March 28, 2014 7:31 PM
Points: 4, Visits: 118
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