November 22, 2012 at 7:32 am
I treid to install the Adventure Works sample database in my system but am not able to install that..
databse is creating with blank tables but no data is getting populating..
Setting in instadwb file:
:setvar SqlSamplesDatabasePath "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\"
:setvar SqlSamplesSourceDataPath "C:\{AdventureWorks 2008 OLTP Script Path}\"
i have sample source datapth on this C drive only..
Error message that I am getting:
Msg 4861, Level 16, State 1, Line 4
Cannot bulk load because the file "C:\{AdventureWorks 2008 OLTP Script Path}\Address.csv" could not be opened. Operating system error code 3(failed to retrieve text for this error. Reason: 15105).
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
November 23, 2012 at 12:32 pm
kapil_kk (11/22/2012)
I treid to install the Adventure Works sample database in my system but am not able to install that..databse is creating with blank tables but no data is getting populating..
Setting in instadwb file:
:setvar SqlSamplesDatabasePath "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\"
:setvar SqlSamplesSourceDataPath "C:\{AdventureWorks 2008 OLTP Script Path}\"
i have sample source datapth on this C drive only..
Error message that I am getting:
Msg 4861, Level 16, State 1, Line 4
Cannot bulk load because the file "C:\{AdventureWorks 2008 OLTP Script Path}\Address.csv" could not be opened. Operating system error code 3(failed to retrieve text for this error. Reason: 15105).
Why do you have the curly braces character "{" & "}" in your path for the csv file ? Its either the incorrect path or the file is open in anotheer program ?
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply