Node builder error
Invalid Object Name 'Dynamics..SC9001'
I assume you have Smart Connect installed and previously set up at this point, but if not, you should do that first.
If you do have Smart Connect installed, try creating the SC9001 table with the definition below.
/****** Object: Table [dbo].[SC9001] Script Date: 06/19/2013 11:08:35 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
SET ANSI_PADDING ON
CREATE TABLE [dbo].[SC9001](
[PRODID] [smallint] NOT NULL,
[Series_Number] [smallint] NOT NULL,
[TABLTECH] [char](79) NOT NULL,
[TBLPHYSNM] [char](51) NOT NULL,
[TABLDESC] [char](51) NOT NULL,
[DEX_ROW_ID] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PKSC9001] PRIMARY KEY NONCLUSTERED
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
SET ANSI_PADDING OFF
If you would like to submit an answer or comment, please sign in to the eOne portal.