Invoke-SQLBulkCopy from PSObject

Open daisy613 opened this issue 4 years ago • 1 comments

Cannot Invoke-SQLBulkCopy from a PSObject instead of a source db.

Nov 03 '21 17:11 daisy613

This is not yet supported, though is on the wishlist. I do not have an ETA -- haven't been able to work on new features for the past year, though I've corrected bugs that arise.

Nov 03 '21 19:11 mithrandyr

@daisy613 -- I found a nuget package that will produce a datareader from any Enumerable object -- this should make it easy to support piping (or passing in an array of objects) to Invoke-SqlBulkCopy to be loaded. This is planned to be fixed in 2.0, which I'm actively working on.

Nov 18 '22 21:11 mithrandyr