I'm trying to create a mining model for forecasting against some DW data. I'm using SSIS for my ETL, and trying to use the Data Mining Model Training destination.
Unfortunately I'm receiving an error whenever the column I'm trying to predict is numeric or decimal format. I don't get the error when I create the model by hand in SSMS, and I don't get the error if I create the error using an Analysis Services project in Visual Studio. I am, however, receiving the error inside of SSIS.
Has anybody been successful when using the Data Mining Model Training destination with numeric data? If not, what are some options within SSIS that would allow me to accomplish what I need to accomplish?