-----Create Schema------

CREATE SCHEMA Master_Data;

------Create Table---

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [Master_Data].[File_Load](

[Load_ID] [bigint] IDENTITY(1,1) NOT NULL,

[File_Record] [varchar](max) NOT NULL,

[IsError] [bit] NOT NULL,

CONSTRAINT [PK_MMR_File_Load] PRIMARY KEY CLUSTERED

(

[Load_ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

ALTER TABLE [Master_Data].[File_Load] ADD CONSTRAINT [DF_File_Load_IsError] DEFAULT ((0)) FOR [IsError]

GO

-----Create view for handling of identity field------

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE VIEW [dbo].[vw_File_Load]

AS

SELECT File_Record

FROM Master_Data.File_Load

GO

-----Sample File Data for file TestFile_20130731.txt-------

Claus|Santa

Fairy|Tooth

Bunny|Easter

-----Bulk Insert Script-------

BULK INSERT vw_File_Load

FROM '\\Vebasqlmmrdev01\trust\File_Table\FileTableTb\TestFile_20130731.txt'

WITH

(

ROWTERMINATOR = '0x0a'

)

------------------------------------

NOTE*** If I map the UNC path on the OS side and use the mapped drive in the BULK INSERT

statement then it works when using a windows login in SSMS. I then get into issues when trying to schedule in an SP using Dynamic SQL, mapped drives, etc... Thus why I am trying to keep the question as simple as possible: Is it possible to use the UNC path of a FileTable in a BULK INSERT statement?