Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Changing query in DTS package

Author  Topic 

venkath
Posting Yak Master

202 Posts

Posted - 2007-06-27 : 11:56:56
Hi all

I have a query which dumps the data in text file
Recently we have dropped 5 columns in a table which is being used by this data dump query.

Now i want to remove the dropped column names from the query to make it run with out any issues.

What are the steps to Drop the columns from the query in DTS package
and make it run again
Thanks

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-27 : 23:25:51
How did you build the package? Use export wizard or sql task?
Go to Top of Page
   

- Advertisement -