Data Not tranfering
Hi
I have a problem. I have used the import wizard to import data from an access 2 database, however only the colums labels and column format was transfered no data. I have since used the SSIS wizard to create a dataflow (checking all tables and columns match up). If I execute the dataflow all tables with no data, tranfer and go green but the tables with data transfer all rows but stay yellow and waits in debug mode. Even on simple tables where there is just one entry which is the number "10" the dataflow remains yellow. I have check the table data view and confirm that there is no data where data should be. There is no errors written to the event log (EventViewer).
I have uninstalled SQl 2005 and re-installed it and installed SP1.
Can anyone help?
