No announcements
Found 2237690 threads
-
0 VotesDestination Flat File creates empty row at end of csv file
I am exporting SQL table data to a csv file.Answered | 1 Replies | 5449 Views | Created by JSanden - Friday, February 4, 2011 8:17 PM | Last reply by Sudeep Raj - Friday, February 4, 2011 8:37 PM
-
2 Votes
Send notifiEcation on a Empty CSV file
Johns, The File will have just header if it is an empty file.Answered | 15 Replies | 906 Views | Created by Sid_2014 - Thursday, June 9, 2016 1:24 PM | Last reply by Rachit Sikroria - Thursday, June 16, 2016 6:50 PM -
3 Votes
BizTalk Receive Location - CSV File - Only Column Headers - Alert Email
Depending on how you Schema is structured, you can set the MinOccurs for the data rows to 1, then the XmlValidator component to validate the message.Answered | 3 Replies | 902 Views | Created by vspvajja - Friday, August 21, 2015 8:18 AM | Last reply by Johns-305 - Friday, August 21, 2015 11:23 AM -
1 Votes
Importing a .csv File with two header rows
Hello, In "Flat File Connection Manager" there is a property "Header rows to skip"; set it to 2 and your ...Answered | 2 Replies | 3592 Views | Created by PSULionRP - Tuesday, November 26, 2013 2:02 PM | Last reply by Olaf Helper - Tuesday, November 26, 2013 2:11 PM -
1 Votes
CSV & pipe delimited export options - no header row
6) Insert the underlying query of the SSRS report into the OLE DB Source component the data flow, 7) Create a flat file ...Answered | 5 Replies | 8596 Views | Created by Peedoe - Thursday, July 1, 2010 6:02 AM | Last reply by Kieran Patrick Wood - Thursday, July 1, 2010 1:44 PM -
2 Votes
Removing empty rows from csv
I built a script to create new users recently hr started sending me the csv file with blank lines.Answered | 12 Replies | 21706 Views | Created by PowerShellNovice - Saturday, September 14, 2013 1:56 AM | Last reply by Robert Howard - Tuesday, November 21, 2017 5:15 PM -
1 Votes
Import only first row from CSV file
You can use BULK insert inside an Execute SQL Task in your package to import the first row into your target table.Answered | 5 Replies | 5910 Views | Created by ScottCabral - Monday, December 15, 2014 5:46 PM | Last reply by ScottCabral - Tuesday, December 16, 2014 3:29 AM -
0 Votes
CSV destination with no headers
I make a bit of a longwinded description, but essentially all I want to do is output only the data to a csv, not the headers.Answered | 9 Replies | 2912 Views | Created by urbanmojo - Monday, July 16, 2012 12:15 PM | Last reply by Sudeep Raj - Wednesday, July 18, 2012 8:56 AM -
1 Votes
Import-csv - show header only
If you want to do it on the imported .csv, $a = import-csv filename.csv $a[0] | gm -membertype noteproperty | select ...Answered | 3 Replies | 7869 Views | Created by Cyreli - Thursday, December 2, 2010 6:32 PM | Last reply by Tome Tanasovski - Thursday, December 2, 2010 9:46 PM -
0 Votes
Importing CSV files with variable rows
I am trying to import csv files into SQL server.Answered | 2 Replies | 2308 Views | Created by Iowa Bob E - Wednesday, February 22, 2012 8:41 PM | Last reply by Todd McDermid - Wednesday, February 22, 2012 10:57 PM -
0 Votes
Export rows out of a CSV containing a certain string & email the output
$result = Import-Csv 1.csv | ?Answered | 2 Replies | 4195 Views | Created by TheContemplator - Wednesday, March 16, 2011 8:14 PM | Last reply by TheContemplator - Monday, March 28, 2011 8:35 PM -
0 Votes
Pipeline component for removing header row from incoming CSV file.
My colleague need header in processing and further that we need to have file without header in it, so I am just trying ...Answered | 9 Replies | 1898 Views | Created by _NiLeSh - Thursday, November 24, 2016 5:47 AM | Last reply by Rex van der laan - Tuesday, November 29, 2016 4:15 PM -
3 Votes
How do I use Out-File and not create headers in my output?
Get-Help Export-CSV -Parameter NoTypeInformation I agree with Blindrood that, in this case, one is likely better off putting the data into a ...Answered | 6 Replies | 46084 Views | Created by SdeDot - Tuesday, October 2, 2012 9:54 AM | Last reply by Al Dunbar - Tuesday, October 2, 2012 5:18 PM -
2 Votes
Import csv error when select 1st row as header
Does your header row have any special characters or other language characters?Answered | 2 Replies | 1924 Views | Created by paleta2003 - Monday, February 5, 2018 10:39 PM | Last reply by Visakh16 - Tuesday, February 6, 2018 6:26 AM -
10 Votes
Powershell read CSV file line by line and only first header
jrv, my point was merely to demonstrate how the columns become properties of an object when imported via Import-Csv and that they can be iterated one at a time using a ...Answered | 15 Replies | 223411 Views | Created by jawano - Thursday, April 23, 2015 10:48 AM | Last reply by AStay - Monday, June 10, 2019 8:57 PM -
0 Votes
Convert txt file to csv file with header
'row count' should read 'column count' \_(ツ)_/Answered | 2 Replies | 2582 Views | Created by Nidhin CK - Friday, December 30, 2016 5:03 AM | Last reply by jrv - Friday, December 30, 2016 5:58 AM -
13 Votes
How can I compute the number of fields in a CSV file that does not contain a header ?
It only becomes an issue if you have a header row that starts with #, and isn't quoted (or, in the GetContent | ConvertFrom-Csv scenario, any line ...Answered | 34 Replies | 9745 Views | Created by Larry Weiss - Friday, August 2, 2013 2:58 PM | Last reply by Larry Weiss - Friday, August 30, 2013 2:16 PM -
3 Votes
Multiple CSVs from Folder result in multiple header rows
It will actually properly combine CSV files with columns in different orders and accommodate unmatched columns.Answered | 10 Replies | 4868 Views | Created by Gerhard Brueckl - Thursday, January 30, 2014 9:21 AM | Last reply by Imke Feldmann - Friday, April 8, 2016 3:10 PM -
0 Votes
Add header and footer to csv output
or you want to create a single flat file for all iterations?Answered | 9 Replies | 10329 Views | Created by BoxheadMonkey - Monday, November 7, 2011 11:22 AM | Last reply by BoxheadMonkey - Monday, November 14, 2011 1:14 PM -
12 Votes
How to delete contents of a csv file except header using powershell
\test.csv' $header = Get-Content -LiteralPath $file | Where-Object { $_ -notmatch '^#type' } | Select-Object -First 1 Set-Content ...Answered | 10 Replies | 13399 Views | Created by pks21457 - Thursday, March 6, 2014 3:25 PM | Last reply by David Wyatt - Wednesday, July 9, 2014 7:11 PM - Items 1 to 20 of 2237690 Next ›
No announcements
