Text File format
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html> <head> <title></title> <meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1"> <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5"> </head>
<body> My text file need to be in this format. "FieldA","FieldB" 1,"A" 2,"B" 3,"C" -where "FieldA" and "FieldB" are the names of the 1st and 2nd fields. FieldA is an int field, so the header should be in quotes, but the column values should not be in quotes.
How to do it. I am using Data Flow Task. My source is a query (select FieldA, FieldB from tblname). The destination is the .txt file, mentioned above. Thanks. </body> </html>
June 14th, 2011 12:23pm
This topic is archived. No further replies will be accepted.
Other recent topics
