$query="BULK INSERT [database_name].[dbo].[table_name] FROM 'd:\import\dane_do_importu.csv' WITH(DATAFILETYPE='char',FIELDTERMINATOR=';',FIRSTROW=1)"
Invoke-Sqlcmd -Query $query -ServerInstance 'SQL01-MSFT\inst1' -Database database_name
Geniusz to 1% inspiracji i 99% potu.
$query="BULK INSERT [database_name].[dbo].[table_name] FROM 'd:\import\dane_do_importu.csv' WITH(DATAFILETYPE='char',FIELDTERMINATOR=';',FIRSTROW=1)"
Invoke-Sqlcmd -Query $query -ServerInstance 'SQL01-MSFT\inst1' -Database database_name