i'm getting unusual 1 cannot find reference out there?? hope of have seen this? have number of packages in project working fine, using project level connection manager, sql server db. configuring number of source destination flows in data flow, import text files stage tables. configure source connect text file , preview data no problem. add ole db connection db , select desired table in dropdown. click view existing data button , following error;
an ole db record available. source: "microsoft sql server native client 11.0" hresult: 0x80004005 description: "unspecified error". ole db record available. source: "microsoft sql server native client 11.0" hresult: 0x80004005 description: "communication link failure". error @ dft_name [tablename [230]]: failed open fastload rowset tablename. check object exists in database.
i similar error if try click mappings tab. connection manage working fine have execute sql task in control flow runs fine.
i should mention in desperation, deleted data flow tasks , saved package. recreated data flows , worked fine. come in today , problem back, although no changes made!! has to password caching or such, using windows authentication , cm tests fine , execute sql task still runs !! help?
Comments
Post a Comment