FIM MA Export to Excel files
Hi, Can any one tell me how to export objects from SqlServer to Excel file using FIM MA's I'm sure that we need to create MA to export from SqlServer to Metaverse and from MetaVerse to Excel how do we do that? is there any relevant website for my Scenario
July 26th, 2012 4:54pm

Do you need to have it as part of your provisioning solution and export these information for specific users only? Or you are trying to just export these data with FIM. If later maybe SQL integration Services or just Data Export tool would be more suitable. If You want to provision entries for Your users to something which will be then consumed by Excel you can configure text file MA either with standard file MA or Henrik's ultimete File ma http://fimfileconnector.codeplex.com/ and export these data to CSV.
Free Windows Admin Tool Kit Click here and download it now
July 26th, 2012 5:08pm

Hi Tomasz, In my situation I have few set of tables (3 tables) and i want to query those tables and exported to 2 Excel files via FIM MA's.
July 26th, 2012 5:18pm

Have you thought about doing this with SSIS? You could do it with FIM but I think SSIS would be a much easier solution.My Book - Active Directory, 4th Edition My Blog - www.briandesmond.com
Free Windows Admin Tool Kit Click here and download it now
July 26th, 2012 5:23pm

Hi Brian, That also a good solution in my case, but how can i implement that? is there any document describing it?
July 26th, 2012 5:27pm

Hi Brian, That also a good solution in my case, but how can i implement that? is there any document describing it? Start with the Import/Export Data wizard in SQL Management Studio. It can generate an SSIS package that you can tweak or just schedule as a SQL Agent job.My Book - Active Directory, 4th Edition My Blog - www.briandesmond.com
Free Windows Admin Tool Kit Click here and download it now
July 26th, 2012 5:28pm

Hi Brian, By using the SSIS is it possible to export the entire db or I can export necessary tables and necessary fields with Joiins and conditions as normally we do in MA's? in my situation i need to join tables and necessary fields to export to Excel
July 26th, 2012 5:45pm

Hi Brian, By using the SSIS is it possible to export the entire db or I can export necessary tables and necessary fields with Joiins and conditions as normally we do in MA's? in my situation i need to join tables and necessary fields to export to Excel Yes you can export the result of a SQL query.My Book - Active Directory, 4th Edition My Blog - www.briandesmond.com
Free Windows Admin Tool Kit Click here and download it now
July 26th, 2012 5:47pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics