It is possible to make DTS skip a number of steps according to the result of
a query for example:
IF (SELECT     *
     FROM          Modified_sage_tables

I think I'm going to ask the stupidest question there is but,
I need to download a file daily from a website, it will always be the same
filename, just different content.  Now I can schedule a job to run on my
server (SQL Server 2000) but what script do I use to tell the pc that ...

I have a simple DTS package which imports rows from a text file into a sql
database table.
Connection 1 -> Connection 2
The DTS is just a tab delimited text file (Connection 1) of data going into

I need some help on creating a process where i need to save webpages as a
text file and load it into sql server.  Can this be done using DTS?  
Thanks!

I am importing data from one database to another using DTS. During the
importation process, I get the following error message:
INSERT statement conflicted with COLUMN FOREIGH KEY constraint.
“FK_foot_Gen”. The conflict occurred in database ‘Sales’, table ‘Gen’, column

I've created some packages to transfer data from text files to SQL Server
tables. I need to do this whenever I receive new data.
Can I execute those packages from a stored procedure so that I don't have to
run them one by one manually?

I created a simple DTS package which uses the FTP task in Enterprise
Manager. I want to get a file off of the SQL Server D:\ Drive and copy
it to a network server , the F:\ Drive.
When I manually execute the job (right click execute package) it runs

I have 2 tables. At a timed interval I have  "transform Data task"
setup to copy the data from one table to the other. I want to delete
the transfered data from the first one once the transfer is complete.
I can create the SQL task to do the delate. However, I was think, what

I'm not sure if this is where I post this but here it goes.
I have already imported the data from an excel file, in excel it has the
ability to display this field as the total amount of time sense the start of
the clock for example "66:21:22" is 66hrs 21mins and 22secs.

I have a fields with the space char in data.
How to find a space character in query?
'Smith David'

   I have a DTS with "Execute Process Task" and I tried to execute
"osql.exe" with
the following parameters, and was executed correctly
/U roberto /P c3tech /w 1000 /Q "select * from Parts where ItemNumber = '' "

I am having a problem sending emails from DTS.  I want to look through a
customer database and send out emails depending on the status of the
customer, for example to inform them that their membership is about to
expire.  By the the way I am working with SQL Server 7.0

I need help... I get the next error when i try to import data (using DTS
Wizard)  from a OLAP Cube,  that have a "custom rollup" dimension:
  "CONTEX: ERROR CALLING OPENROWSET ON THE PROVIDER"
I am using SQL Server 2000 and "Microsoft OLE DB Provider for OLAP Services

Is it possible to convert a dts package saved as .bas file back to
a sql server package so it can be opened, designed,saved and used again in
sql server?
Thanks alot

When i execute the same DTS job on another server not running SQL Server I
get the following errors. But if i run the job on the same server as the SQL
Server it works.
This is driving me mad - please if anyone has any pointers.