Sure. Create a table in SQL Server with all the fields that you are pulling from Oracle. We'll name the table "Staging" for now. In that table, make the fields that...

It would be faster to use the Staging table approach. While the ActiveX script approach works, it slows your transfer speed down. By using a staging table where the field...

I suspect that the problem might be that in Oracle the minimum allowed date is 1753-01-01, whereas in SQL Server it is 1900-01-01. When the DTS tries to load that record,...

You will have to do it in the ActiveX script as SQL 7.0 doen't have the Dynamic Properties Task.

There is a handy freeware tool on http://www.sqldts.com called DTSBackup 2000 that lets you select the DTS packages on the source and copy them to a destination server.

OK. I'll assume that you have already created the Transform Data (Data Pump) Task.

1. Create a Global variable called SQLString.

2. Drag the ActiveX Task object to the DTS Designer...

Actually, you may not need to use the ActiveX/Dynamic Properties. Try changing your SQL statement to:

SELECT * FROM SCHEDULE WHERE DATE=TODAY

I think that Ingres supports the TODAY Keyword.

I have run into that one too. Many ODBC drivers don't support the ? parameter in SQL DTS and return the error you got if you try to use it.

What...

You can use the ISNUMERIC() function. The code would look something like this (You would be in Database_A when running it) :

insert into TableA (ColumnA)

select ColumnB

from Database_B.dbo.TableB

where ISNUMERIC(ColumnB) = 1

Cheers,

Sounds like you may not have the MS Collaberation Data Objects installed. They do come with MS Office, but are not installed by default. You have to run the Office...