How do I output a CSV using PowerShell without the "#TYPE" line? -
this sort of related post. i've got following script written:
get-aduser -filter * -searchbase 'dc=aaaa,dc=com' | export-csv "adusers.csv"
this outputs csv file @ first row of file reads:
#type selected.microsoft.activedirectory.management.aduser"
this messing ssis when tries read it. there way of not adding first line?
add notypeinformation
switch, this:
export-csv "../ssis/import data/adusers.csv" -notypeinformation
Comments
Post a Comment