加载AdventureWorks Azure DataWarehouse时,必须安装BCP错误



我正在尝试测试Azure数据仓库。我成功创建并连接到数据库,但是当我尝试加载表时,我遇到了一个障碍。我正在尝试执行以下说明:

To install AdventureWorksSQLDW2012:
-----------------------------------
4. Extract files from AdventureWorksSQLDW2012.zip file into a directory.
5. Edit aw_create.bat setting the following variables:
   a. server=<servername> from step 1.  e.g. mylogicalserver.database.windows.net 
   b. user=<username> from step 1 or another user with proper permissions
   c. password=<passwordname> for user in step 5b
   d. database=<database> created in step 1
   e. schema=<schema> this schema will be created if it does not yet exist
6. Run aw_create.bat from a cmd prompt, running from the directory where the files were unzipped to.
   This script will...
   a. Drop any Adventure Works tables or views that already exist in the schema
   b. Create the Adventure Works tables and views in the schema specified
   c. Load each table using bcp
   d. Validate the row counts for each table
   e. Collect statistics on every column for each table

我完成了安装BCP和SQLCMD的先决条件并使用了 - ?命令确认安装。

不幸的是,当我尝试完成上面的步骤6时,我会收到以下错误:

REM AdventureWorksssqldW2012示例数据库版本3.0 DW服务时06/27/2017 20:31:01.99 BCP。

是否有人遇到此错误,或者任何人都可以提出潜在的解决方案。

更新:我还复制了BCP位于我的路径环境变量的路径。仍然没有运气。

aw_create.bat包含一行,您需要提供BCP程序的路径。一旦提供了ANS,保存脚本就会像魅力一样工作。

最新更新