QUESTION POSED ON: 05 December 2007
I am just starting to learn SQL Server 2005 and I can't believe how absurdly difficult SSIS is when compared to DTS. I have been trying to import an Excel spreadsheet for two hours (would take me two minutes with DTS) and I continue to get the error: The column can't be inserted because the conversion between types DT_R8 and DT_STR is not supported. I don't even know what DT_R8 is?
I'm using an Excel source and a SQL Server destination. I've tried importing to an existing table and creating a new one. I've tried changing all the cells to text in the spreadsheet. Nothing works. Do you have any ideas for me?
|