Possible to call SSIS from Sharepoint 2007?

[jimmyfishbean]

Hi,

I have a Sharepoint 2007 intranet solution (free version) and would like to know if it is possible to have a button on the front-end that when pressed, calls SSIS (to initiate a Data Flow process - i.e. do some importing of data into a SQL Server 2005 DB)?

Thanks.

Jimmy

 

[philhege]

You can write an aspx Web part to do this for you. Just keep in mind that you may have to use some impersonation to allow the user to kick off an SSIS package.

Phil H.
Some Bank
-----------
Time's fun when you're having flies.