Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Article Discussion
 Article: Fast CSV Import in PowerShell to SQL Server

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2014-03-18 : 09:59:29
I recently had to write some simple scripts for a proof of concept. These scripts use PowerShell to import and export CSV files from SQL Server. The scripts were simple to write and maintain but were slow. It turns out there are a few ways to improve CSV import and export performance in PowerShell.

Read Fast CSV Import in PowerShell to SQL Server

btatro
Starting Member

1 Post

Posted - 2014-12-21 : 12:12:51
Is there a way to determine the total number of rows in the csv file?
Go to Top of Page

rechly150
Starting Member

1 Post

Posted - 2015-02-18 : 23:54:18
Thanks for sharing this information with us. Its really more comprehensive and have exclusive point about information. I appreciate your blog post.

Thanks & Regards,
Rechly Parker
IT Analyst
SageNext Infotech LLC
Go to Top of Page
   

- Advertisement -