Wednesday, March 7, 2012

How to read a .PST file from a SSIS package?

Hi everyone,

I'd like to read a .PST file (which contains thousands of mails) regardless of Exchange client.

Is it possible?

Thanks for your input

SSIS doesn't have an out-of-the-box component to do just that. If there's an OLE DB, .NET or ODBC provider for that data source, you can try that (I'm not sure there is one, but it's amazing to see the wealth of connectors out there for surprising data sources, you might want to check that).

Perhaps, another way could be exporting .PST file into some format SSIS can consume (i.e. flat file or xml) and get the data into SSIS that way.

And of course, you can always write your own component and plug it in SSIS.

|||Thanks for that.

No comments:

Post a Comment