Hi all,
Have a table, say tab1(any schema, few rows)

and I want to execute this query through DTS

select * into tab2 from tab1
select * from tab2 and store the result in a text file.


I am using following object.

Microsoft oledb provider for SQL server
Transform data task
text file destination.

when i execute , gives error
error description: Invalid pointer

any help is appreciated.

How are you trying to do this.

I would do it like this

1. An ExecuteSQL task against the SQL Server connection for your SELECT
INTO statement
2. Datapump task from tab2 --> tab1

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"mahak" <anonymous (AT) discussions (DOT) microsoft.com> wrote

I am doing the same what u have told but the only problem
is my tab2 has to be a temp table or table variable.
but if I use permanent table (tab2) instead it works,
problem is I have to use temp. table.

A table variable will NOT work

use ## tables instead of # tables

--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"mahak" <anonymous (AT) discussions (DOT) microsoft.com> wrote

even ## table does not work, seems we need to set some SQL
paramaterers. any Idea?