Re: Create Access Tables with a Pass Through Query from SQL2000 with SQL

From: "jc" <jc_usernet@xxxxxxxxxxxx>
Date: 22 Mar 2007 06:19:48 -0700

Have you investigated DTS to see if it will do what you need?

Yes. DTS can generate SQL code (or it can be used) but it is no
flexible. It creates a DTS module but the Columns names become hard
coded within. Can it take parameters ? Not from what I have found.

Regards JC.......

.

References:
- Create Access Tables with a Pass Through Query from SQL2000 with SQL
  - From: jc
- Re: Create Access Tables with a Pass Through Query from SQL2000 with SQL
  - From: Gord

Prev by Date: Re: Calendar Templates
Next by Date: Re: Create Access Tables with a Pass Through Query from SQL2000 with SQL
Previous by thread: Re: Create Access Tables with a Pass Through Query from SQL2000 with SQL
Next by thread: Re: Create Access Tables with a Pass Through Query from SQL2000 with SQL
Index(es):
- Date
- Thread

Relevant Pages

How to do this from DTS?
... I have some sql code that I'm working on that I need to create a text file ... The 05 records are built from a second table, where I do similar formatting ... 05's for customer X together, as apposed to putting customer Y's data ... Question is - since this is really 3+ queries, how can I do this in DTS? ...
(microsoft.public.sqlserver.dts)
How to do this from DTS?
... I have some sql code that I'm working on that I need to create a text file ... The 05 records are built from a second table, where I do similar formatting ... 05's for customer X together, as apposed to putting customer Y's data ... Question is - since this is really 3+ queries, how can I do this in DTS? ...
(microsoft.public.sqlserver.programming)
Re: Multi Rows Into One
... DTS have many problems with sql query, a good way to never have surprise is ... DTS does not excute your SQL code like the query anylyzer, ... sql code vis a Systeme Stored procedure (sp_execpreparedsql or something ...
(microsoft.public.sqlserver.dts)