May 30, 2015 at 7:21 am
I have an OLE DB Source with SQL creating data in a temp table.
When I preview the OLE data source I find data in it.
But when I try running the data flow task it does not populate the destination table.
But the data flow task does not show any error.
I need to populate the destination table with the temp data which is generated in the OLE DB Source.
The data flow task is part of a foreach loop container.So my data flow task will run against a bunch of servers.
And against each server a temp table with data is created and this temp data created in the OLE DB source should be dumped into the destination table.
I am getting a warning :
[SSIS.Pipeline] Warning: Warning: Could not open global shared memory to communicate with performance DLL; data flow performance counters are not available. To resolve, run this package as an administrator, or on the system's console.
How do I make this work
Source is SQL commands creating temp table data and destination is a single SQL table.
Thanks
July 7, 2015 at 9:24 am
To clarify, there are two different issues you're describing:
-- Warning about performance DLLs
-- Temp table use in SSIS
For the first one, this is a warning only and not an error. In most cases, you can open BIDS or SSDT as administrator to resolve the warning.
For the second issue, you've found an inherent issue in SSIS with respect to temporary tables. Because SSIS does a runtime validation before reading from or writing to tables, attempting to read or write temp table data will often result in unexpected behavior, including possibly failing the package. If you need to create temporary storage for ETL, my recommendation is to built permanent staging tables that are truncated (or selectively deleted) at the outset of each load. It takes some extra effort to set this up, but you'll have a more predictable experience when running ETL loads.
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply