Friday, March 9, 2012

Import Data Form Access To Sql Server 2005

I have a database in ACCESS and i want everytime that there is a change made in Access the cude in SQL server to be automatically updated .Is there a way that this can be done with Integration Services?

I assume you mean that you want some data in SQL Server to be updated. SSIS can certainly do the required data manipulation but you need to solve the problem of automatically executing your SSIS package whena change occurs to the source. SSIS executes reactively, not proactively.

Regards

-Jamie

No comments:

Post a Comment