Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
How to bind the mining structure to a data source for the imported project?

Unanswered How to bind the mining structure to a data source for the imported project?

  • Saturday, February 02, 2013 3:47 PM
     
     
    Sign In to Vote
    0

    Hi All,

    I imported a database from SSMS (2008) into a BIDS project.  When I tried to process it, I got the following error:

    Error (Data mining): The 'Bike Mailing' structure does not contain bindings to data (or contains bindings that are not valid) and cannot be processed.

    (The 'Bike Mailing' is the mining structure.)

    The database was created using DMX and it does not use a data source views.  The mining models run well in the SSMS environment without any problem.

    How can I bind the mining structure to a data source for the imported project?


    BI Analyst

     

All Replies

  • Thursday, February 07, 2013 10:30 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi BIAnalyst,

    I am afraid you need to define the mining structure using BIDS, the data mining structure stores the definition of the data source and the columns in it in the form of bindings to the source data, please refer to: http://msdn.microsoft.com/en-us/library/ms174757.aspx

    And here is a similar thread, please see: http://msdn.microsoft.com/en-us/library/ms174757.aspx

    Thanks,
    Eileen

    Eileen Zhao
    TechNet Community Support

     
  • Thursday, February 07, 2013 6:16 PM
     
     
    Sign In to Vote
    0

    Thank you, Eileen.

    I know how to create the models in the BIDS, but I just do not know how to bind it to a data source.

    So there is no way to reconnect the existing models to a new data source?  To "define the mining structure using BIDS" is like to reconstruct the project from scratch.  

     

    BI Analyst

     
  • Thursday, March 07, 2013 7:28 PM
     
     
    Sign In to Vote
    0

    This thread has not been answered for a month and I am wondering if there are some experts out there who may be able to solve this (or is there no way to do this)?

    BI Analyst