<div>
Thanks<br />
<br />
I would love to use SSIS, but SQL Server does not have SSIS.<br />
<br />
I got it to work with your suggestions.<br />
<br />
glen
</div>


Thanks

I would love to use SSIS, but SQL Server does not have SSIS.

I got it to work with your suggestions.

glen

<div>
<div class="content wysiwyg-content">
The following is a BCP command in a Batch file I want to use to copy a SQL table to a CSV file:<br />
<br />
bcp &quot;livendb.dbo.zzz_VTE6&quot; out &quot;C:\users\FSAdmin\Document<wbr />s\VTE6.csv<wbr />&quot; -c -t, -T -SHPC-DR1<br />
<br />
When I run the batch file, it does not stop.<br />
<br />
Can anyone see something wrong with the syntax?<br />
<br />
I have something similar for a query which runs without a problem.<br />
<br />
Thanks<br />
<br />
Glen
</div>
</div>


The following is a BCP command in a Batch file I want to use to copy a SQL table to a CSV file:

bcp "livendb.dbo.zzz_VTE6" out "C:\users\FSAdmin\Documents\VTE6.csv" -c -t, -T -SHPC-DR1

When I run the batch file, it does not stop.

Can anyone see something wrong with the syntax?

I have something similar for a query which runs without a problem.

Thanks

Glen

BCP command from batch file runs cithout stopping

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

The Microsoft Legacy Operating System topic includes legacy versions of Microsoft operating systems prior to Windows 2000: All versions of MS-DOS and other versions developed for specific manufacturers and Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions, and Windows Mobile.

Microsoft Legacy OS

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data. SSIS replaced Data Transformation Services, which had been a feature of SQL Server since Version 7.0.