Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Location
    Philippines
    Posts
    14

    Unhappy Unanswered: BI Accelerator 1.1 and Bulk Insert

    Dear Anyone,

    I had been using BI Accelerator 1.1 for 2 years now. In our current project, I encountered the following error during the importing phase of BI.

    I traced the problem to the bulk insert statement that BI Accelerator is executing which is ...

    BULK INSERT [Project88_Staging]..[S_Fact_BrdcastAlert] FROM 'C:\Program Files\Microsoft SQL Server Accelerator for BI\data\Project88\Import\S_Fact_BrdcastAlert.txt' WITH ( FORMATFILE = 'C:\Program Files\Microsoft SQL Server Accelerator for BI\data\Project88\DTS\Import\Format\S_Fact_Brdcast Alert.fmt' , DATAFILETYPE = 'widechar', BATCHSIZE = 100000 , MAXERRORS = 100 )


    The error that it generates is as follows:

    Bulk Insert: DataFileType was incorrectly specified as widechar. DataFileType will be assumed to be char because the data file does not have a Unicode signature.



    We export data to text files that BI Accelerator picks up. All other files imports properly imported without problems except for one fact table text file. We use the same format file that BI Accelerator uses to export to file the data to make sure that there would be no incompatabilities. File size is about 2.3GB++, which is a standard size with our other fact table files that doesnt have any errors.

    We also checked for data error which we found none. We also checked the txt file we generate, notepad confirms that it is a unicode file.

    Can anyone please shed a light in what is happening. Is this a bug? As much as possible I dont want to place a workaround on this one since our entire framework for loading data is all the same and has already been set up. Any help would be apreciated.


    Thank You

  2. #2
    Join Date
    Aug 2003
    Location
    Philippines
    Posts
    14

    Post

    Any reply would be appreciated.

    Joseph Ollero
    jollero@wizardsgroup.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •