Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    15

    Unanswered: Exporting data with dynamic fields

    Hi,

    I have one Query Builder application where user creates queries and generates output with required fields.Then user can export the same to excel (Using farPointSpread properties)
    But if no. of records goes beyond 10K it goes too slow or even user machine hangs up. I want to give proper export facility. Can it be given using DTS?

    I tried DTS (.vbs) file. but for random field selection it did not work.
    Rohit Chitre

  2. #2
    Join Date
    Sep 2004
    Posts
    15
    DTS package asks for new Transactions to be built for every change in Source table structure. It first creates the table in the destination databse and then exports the data.
    If I try modify the VB code generated by the package to match with new Source table it does'nt work.

    Can anyone tell me what should I do for export the data dynamically i.e. export the tables with differrent structres?



    Thanx in advance.
    Rohit Chitre

  3. #3
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    You should do a helluvalotta programming. DTS sucks, and I don't believe most people on this forum use it for much more than directly transfering defined recordsets.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •