I am trying to run an SSIS package. I connect to a unidata database and transfer data into a SQL2005 table. When I try to run the package I get the following error:
[SQL Server Destination ] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E14. An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80040E14 Description: "Could not bulk load because SSIS file mapping object 'Global\DTSQLIMPORT ' could not be opened. Operating system error code 2(The system cannot find the file specified.). Make sure you are accessing a local server via Windows security.".
This is basically a straight transfer with the exception of a dataconversion piece that converts a date field.
Can someone please help me?