Latest Application Design Assistance for Web SSIS/DTS application RRS feed

  • Question

  • Respected Community Members,

    I got a requirement to create a App to have SQL server data export functionality implemented such a way that

    1) user will select the list of column/table/view from any database/SQL Server

    2) Based on User Query Selection, the data will be exported into XML/CSV file at flexible frequnecy.

    I know DTS/SSIS will provide such a feature, but we actually wants user to define query on the fly.

    As far as the Application development, please assist me if any Article/Tool/Samples/Packages should i consider/refer??

    Since now a days we have many flexible Visual Studio patform/design/Patterns available, its hard to select which one i should go with? I am familiar with typical Web/Window form local/web kind of applications, but needs to check with community with their ideas that might be helpful.

    Let me know if you know any good forum that i should use for this kind of questions?

    Thursday, November 21, 2013 5:13 PM