Importing Tricky CSV Files with PowerShell
A means of importing large csv files (where there may be commas in quote-delimited free text) into SQL Server tables using PowerShell
2018-07-03
7,038 reads
bulkinsert
RE: Passing dynamic variable in a DTS
To Call DTS:1) use dtsrunui.exe (in 80/tools/bin under SQL Program Files) to generate a DTSRun command string. Set variable FY="default value" to generate global variable portion of command line.2) Copy command line and set a varchar variable in proc to that value.3) replace "default value" in string with a "server" parameter from proc (using string concatenation)4) exectute […]
2005-04-08
Blogs
Deleting Old Local Git Branches–#SQLNewBlogger
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Real-World SQL Mastery: Your Hands-On, Mess-Free Sandbox
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers