-
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 :blush:
-
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"
-
Re: SQL DTS problem
Forget it ... i have found ...
There's not need of "The Data Driven Query" just Data transformation...