FILESTREAM

• sjorsd

  Valued Member

  Points: 65

  More actions

  June 12, 2017 at 7:58 am

  #343234

  I have created a database that is named Products. This database contains two filegroups: PRIMARY and FileStreamGroup1. For the FileStreamGroup1 I have created the folder C:\Data.
  In the Windows start menu I used SQL Server Configuration Manager to enable the Transact SQL access and Enable FILESTREAM for file I/O streaming access and i executed the following query in SSMS:
  EXEC sp_configure filestream_access_level, 2
  RECONFIGURE

  Finally, I have created a table called Package

  USE [Products]
  GO
  CREATE TABLE [dbo].[Package](
      [ID] [uniqueidentifier] ROWGUIDCOL NOT NULL,
      [Product_code] [nvarchar](25) NOT NULL,
      [Package_Code] [nvarchar](10) NOT NULL,
      [Name_Package] [nvarchar](50) NOT NULL,
      [Filename] [nvarchar](50) NULL,
      [Document] [varbinary](max) FILESTREAM NULL,
      [Start] [datetime] NULL,
      [End] [datetime] NULL,
      [Date] [datetime] NOT NULL,
      [ListPrice] [money] NOT NULL,
  CONSTRAINT [PK_package] PRIMARY KEY CLUSTERED
  (
      [Product_code] ASC,
      [Package_Code] ASC
  )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] FILESTREAM_ON [FileStreamGroup1],
  UNIQUE NONCLUSTERED
  (
      [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] FILESTREAM_ON [FileStreamGroup1]
  GO
  ALTER TABLE [dbo].[Package] ADD DEFAULT (newid()) FOR [ID]
  GO

  I use SSIS to import the product rows from Excel to SQL Server.

  The problem is that the column [Document] remains empty (NULL) even if the column [Filename] has a value (for example C:\Data\A0638-UP-2012 W26.docx).
  Who can tell me what causues this problem and how to solve it?
  

• sjorsd

  Valued Member

  Points: 65

  More actions

  July 12, 2017 at 6:11 am

  #1950501

  I;ve figured it out myself with the help of some online articles.