Thanks!! I'm going to try and incorporate that with the Powershell  function. Can you call the function in a batch(cmd) file
and supply different values values at run time rather...

That sounds like a great solution any hints\examples to get me started?

 Thanks.

I have been trying to use PS to load text files to SQL using the script from article "Import tricky CSV's". The script is very good
but the speed seems...

How could that be accomplished(example) if no header available.

 Thanks.

I know which fields in csv contain dates

I was looking for a generic Insert that would read a csv and dynamically create a SQL table based upon number of columns in csv then do the
ETL in...

Need an example of how to wrap the if statement checking if date exists and conforms to format dd-mm-yyy (null or empty can pass check but maybe log the line...

any thoughts on how to convert this script .. without going the SSIS route?

 Thanks

any idea what caused this error?

 Thanks.

How does the process work\handle(using format file) with truncation of a field in csv larger than sql table defintion.

 Thanks.

If you have certain fields in the csv input that you would like to do a pre-processor for, to perform checks before loading to SQL.

 This could be used...

It throw and error at the end.

 +  throw "$($badLines) lines contained invalid dates"
+  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  + CategoryInfo    : OperationStopped: (97 lines contained invalid dates:String) [],...

Its an older DTS package that has "NOT" has been converted to SSIS. 

Its an older DTS package that has been converted to SSIS.