Am reusit sa rezolv cu variabilele alea,insa cand rulez packetul in dreptul DataFLFow tasks care au obiect sqlserver destination am o eroare de oledb:[SQL Server Destination [121]] 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(error not found). Make sure you are accessing a local server via Windows security.". .Am cautat pe net si am gasit ca packagul trebuie sa ruleze pe acelasi server cu cel al obiectului sqlserverdestination ceea ce nu mi se pare ok...
Multumesc
Secolul XXI ori va fi religios ori nu va fi deloc