GM

I did unzip the file and now I have this file.

AdventureWorks2014.bak

May I ask you how do I install the DB from here. I am sure this can be done via...

I found this script to populate the DimDate table

BEGIN TRAN

declare @startdate date = '2005-01-01',

@enddate date = '2014-12-31'

IF @startdate IS NULL

BEGIN

...

However there are a lot more tables that start with the word "Dim" .

If anyone has the full database with the data ( mdb file ) let me know.

I found the tables script on some internet site. I am going to paste this hoping it may help someone

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

IF NOT EXISTS (SELECT * FROM...

I am sorry, that was not the question. I should have mentioned this properly.

We are able to deploy.

However when you call it from a job it gives us an error........

pmscorca (4/3/2014)

---

Hi, thanks for your reply.

You are saying that in SSDT 2010 it is right that I cannot see the SSIS Data Flow Items tab when I select the voice...

This is the output I get in response to the command...

File activation failure. The physical file name "C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWorks2012_Log.ldf" may be incorrect.

New log file 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\AdventureWorks2012_log.ldf'...

Reply to BLOB and LUIS

DONE! WORKED!

CREATE DATABASE AdventureWorks2012

ON (FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Data\AdventureWorks2012_Data.mdf')

FOR ATTACH_REBUILD_LOG;

TRICK: - The file had to be in this folder. ( I got this folder...

Folks read this please. ( 10/25/2016 2.09 PM )

Earlier I had a extra space in the path so that was reasonable for SQLServer to say could not find file...

REPLY TO BLOB

CREATE DATABASE AdventureWorks2012

ON (FILENAME = ' C:\AdventureWorks2012_Data.mdf')

FOR ATTACH_REBUILD_LOG;

Here is the error msg

Msg 5105, Level 16, State 2, Line 1

A file activation error occurred. The physical file name...

Reply to LUIS

Microsoft SQL Server 2012 - 11.0.2100.60 (X64)

Feb 10 2012 19:39:15

Copyright (c) Microsoft Corporation

Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

I get an error....

Msg 5105, Level 16, State 2, Line 1

A file activation error occurred. The physical file name ' C:\Users\xxxxx\Desktop\AdventureWorks2012_Data.mdf' may be incorrect. Diagnose and correct additional errors, and...

Thom A

Agreed! But our challenge is no xp_CMDSHELL

The access issues were reported because the OPENROWSET was not able to identify the JSON file

John M:

Still this is what I get if I used the fully qualified path...

Msg 4860, Level 16, State 1, Line 1

Cannot bulk load. The file "\acorp1.xxx.org\integrations\api.json" does not exist.

Not sure what a UNC path is Are you saying withot using S:\ or H:\ you want me to use the full path ( hard coded server...