OPENQUERY arrives with a lot of baggage. Try this alternative technique to inserting stored procedure results into a new table.
2017-09-22 (first published: 2016-03-22)
With the Konesans File Watcher Task for SSIS we can import files as soon as they arrive.
2014-10-10 (first published: 2012-08-13)
With the WMI Event Watcher Task in SSIS we can import files as soon as they arrive.
2014-10-03 (first published: 2012-07-02)
Learn how you can process data files with SSIS as soon as they arrive using the Script Task.
2014-09-01 (first published: 2012-10-25)