My company is considering using web service as mean of ETL process. However I don t think web service fit into this purpose, for several reasons: 1. web service could possibly consume a lot of memory ...

I am looking for the best solution for custom file parsing for our enterprise import routines. I want to basically change one file format into a standard file format and have one routine that imports ...

SSIS package is just importing from txt file to sql database. when we made the package were using old file and its executing fine.the old source file got (10 columns) the new source file got 15 ...

I m into development of an application that fetches various inputs from internet pages whereas each information snippet comes from a different location (mashup). I would like to generate the mashup ...

We are upgrading a 15 year old code-base, there is a requirement to create some native BCP formatted data files. In the new system, we would ideally like to utilize data in a C# DataTable object to ...

I was looking for ETL tool and on google found lot about Pentaho Kettle. I also need a Data Analyzer to run on Star Schema so that business user can play around and generate any kind of report or ...

Often times when I am working on a project, I find my self looking at the database scheme and having to export the data to work with the new scheme. Lots of times there has been a database where the ...

I have familiarities with software automated build tools ( such as Automated Build Studio). Now I am looking at ETL tools. The one thing crosses my mind is that, I can do anything I can do in ETL ...