Wednesday, May 7, 2008

CREATE TABLE [dbo].[Crm

Importer] ( [Id]  uniqueidentifier ROWGUIDCOL  NOT NULL , [CrmActivityGuid] [varchar] (50) NOT NULL , [MsgFileName] [varchar] (2000) NOT NULL ) ON [PRIMARY]GO

Comments to this table its goal is storing MS CRM activity GUID relationship to file name with email attachment (email message), which needs to be attached to the activity. We will store activity GUID in the field CrmActivityGuid and file name in the import directory of the attachment in the MsgFileName field.

Configuration file for our utility will be the following:

provider=SQLOLEDB;Initial Catalog=Albaspectrum;Data Source=MSSQL1;User Id=sa;Password=sa; data

Labels: , , , , ,