Results 1 to 3 of 3

Thread: SQL DTS problem

  1. May 20th, 2005, 01:47 PM #1
    Zakary
    Zakary is offline

    Thread Starter
    Frenzied Member Zakary's Avatar
    Join Date
    Mar 2005
    Location
    Canada, Quebec, Montreal
    Posts
    1,654

    SQL DTS problem

    Hi !!
    I'm trying to create a DTS on SQL Server 7.0, that take a table and copy it to a Access Database. and i'm have having some trouble.

    I have
    - a connection to my Access DB
    - a connection to my SQL Server
    and
    - a DataDrivenQuery

    but each time à ran the DTS, a error is raise that tell me "The Data Driven Query task requires at least one query (And associated columns) to be specified)


    Can somebody help me with this one
    Using VS 2010 on Fw4.0
    Reply With Quote Reply With Quote
  2. May 20th, 2005, 01:49 PM #2
    Zakary
    Zakary is offline

    Thread Starter
    Frenzied Member Zakary's Avatar
    Join Date
    Mar 2005
    Location
    Canada, Quebec, Montreal
    Posts
    1,654

    Re: SQL DTS problem

    When i try to create a "insert" query, i can't find how to select the source table, it just show me the destination table of my "transformation"
    Using VS 2010 on Fw4.0
    Reply With Quote Reply With Quote
  3. May 20th, 2005, 02:11 PM #3
    Zakary
    Zakary is offline

    Thread Starter
    Frenzied Member Zakary's Avatar
    Join Date
    Mar 2005
    Location
    Canada, Quebec, Montreal
    Posts
    1,654

    Resolved Re: SQL DTS problem

    Forget it ... i have found ...

    There's not need of "The Data Driven Query" just Data transformation...
    Using VS 2010 on Fw4.0
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width