Hi all, I am migrating data from sql server 2008 to Access. I am getting this error Please help me out, [OLE DB Command [3957]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. sAn OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Field 'Test Info/Results.QBM Product Name' cannot be a zero-length string.".

Maybe you have some constraint in Access that the column Info/Results.QBM Product Name can't have a zero length? You could replace empty strings with "unknown" in a derived column.MCTS, MCITP - Please mark posts as answered where appropriate.