Automate export to a text file

To manually export to a TSV file, refer here:[Viewing and Exporting Data from the Local SQL Instance (Providus)]

To automate exporting a table to a TSV file, use the following syntax within a package command task:
{{{{cmd /c bcp DatabaseName.dbo.TableName out "C:\Program Files\Web Scraper Plus+\OutputFileName.tsv" -S .\PROVIDUSSTD -U sa -P velocityscape -c}}}}

To automate exporting the results of a query to TSV, use the following syntax within a package command task:
{{{{cmd /c bcp "SELECT * FROM DatabaseName.dbo.TableName" queryout "C:\Program Files\Web Scraper Plus+\OutputFileName.tsv" -S .\PROVIDUSSTD -U sa -P velocityscape -c}}}}

Note that you can also connect with a trusted connection (through windows authentication) with "-T" instead of "-U sa -P velocityscape". Either should work, but a trusted connection can go bad if someone changes a domain setup or something like that.

Refer [http://msdn2.microsoft.com/en-us/library/ms162802.aspx|here] for more on bcp. Using the standard TSV format is the easy way to go, messing with the format files can get tricky.

Web Scraper and Web Macros FAQs

Navigation

Automate export to a text file