none
SSIS to report on all specific documents

    Question

  • Hi

    The business want a report on all documents in a site collection which have a renew date of today.

    A report needs to be generated every day.

    Can SSIS be used to perform this?

    Thanks

    Tuesday, January 07, 2014 2:50 PM

Answers

All replies

  • I believe so, with http://sqlsrvintegrationsrv.codeplex.com/. Any reason you want to do SSIS, though? PowerShell or using C#/VB.NET may be more efficient.

    Trevor Seward

    Follow or contact me at...
      

    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    Tuesday, January 07, 2014 8:05 PM
    Moderator
  • Hi

    I guess I can do this in Powershell  and c#(using timer job). Never used SSIS so wanted to see what all the fuss is about ;).

    If I use SSIS can all documents in site collection with a certain atribute be referenced? I've done this easily in a timer job in the past where I itterate the webs and libraries.

    Thanks

    Wednesday, January 08, 2014 9:39 AM
  • I've only seen the above solution used once, so I'm not intimately familiar with it. Give it a try, although I felt it was pretty 'messy'.

    Trevor Seward

    Follow or contact me at...
      

    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    Wednesday, January 08, 2014 2:57 PM
    Moderator