Instead of using a custom SSIS-based project to upload content from an on-premise SQL Server database to Azure PaaS-based SQL Database, Marcin Policht presents an alternative approach. Using the bcp utility not only eliminates the need for any custom development, but also rivals SSIS in terms of its data transfer efficiency.
2014-03-17
3,582 reads
Dynamically build a comma delimited CSV file using the BCP utility from any table or view in your database with a useful code debugging parameter.
2015-05-04 (first published: 2013-08-12)
5,648 reads
I recently had an unrelated problem (nul ASCII characters in the text file that confused DTS about the end of the row). My solution was to read it in line by line in an ActiveX task and re-write each line back to a new file along with a row number. This should work for your situation […]
2004-03-22
Hi Steve,Thanks for the information. Actually I am looking for information or examples more related to setup processing rules to capture different type of events and generating alerts. Please let me know if you have some related information.--sntiwary
2004-03-09
I'm guessing the .cmd isn't getting the substitutions into the parameter of the odbcconf file. Since they are quoted, not sure if the parser correctly substitues these.
2004-03-09
Is there any way to display the Table Description property in Enterprise Mgr. It is easy to do in MS Access, but I can't figure out how to do it in SQL Server 2000 (I'm just getting my feet wet with this new set of tools) TIA Dean
2004-02-20
By Steve Jones
I had a lot of local branches for a repo (actually a few repos)....
Are you ready to take your SQL skills from theoretical to tactical? If you've...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers