Is there an alternative to run "SSIS like" process on remote client server without a full SQL Server install?
Posted on 2010-01-08
We are working on a project that will allow remote clients to pull data from legacy databases into a SQL express table that we will consume via a web service. There will be some data transformation that needs to take place in the import process. In the past I have simply used SSIS for this type of task, however, since this is in a client environment that may be duplicated 100 times, the cost of implementing full SQL servers in every remote site is killing us. I would like to simply install SQL Express, and use some other method of getting the data from the legacy databases into our SQL tables. Is there any good alternatives? How is PowerShell at doing pivot or sync operations? Is PowerShell too slow to handle as many as a few thousand records? Is there a way to perform SSIS functionality in a custom C# application without writing LOTS of code? I wish there was an SSIS runtime...