How do I output a CSV using PowerShell without the "#TYPE" line?

Question

this is sort of related to another post. I've got the following script written:

Get-ADUser -Filter * -SearchBase 'DC=aaaa,DC=com' | Export-CSV "ADUsers.csv" 

This outputs a CSV file but at the first row of the file reads:

#TYPE Selected.Microsoft.ActiveDirectory.Management.ADUser" 

This is messing up SSIS when it tries to read it. Is there any way of not adding that first line?

Answer 1

Add the NoTypeInformation switch, like this:

Export-Csv "../SSIS/Import Data/ADUsers.csv" -NoTypeInformation