What datatypes are you using for the parameters within the stored procedure?

You might try converting the date to the Oracle format using CONVERT(varchar(15), , 106)

If you don't want to use the full-blown Visual Studio.Net 2003, you can grab a copy of VB.Net approx. US$99. Other than that, your only other option is to type...

Well you not alone about sounding like a twit, there's many of us of there. It's real easy to sound like a twit when you're dealing with DTS

Unfortunately in v7 you don't have the inbuilt DTS package logging.

You'll have to put something together yourself using either ActiveScript or ExecuteSQL tasks.

Check BOL for the files that need to be distributed.

Although, why would you do this? Would be far easier to setup an ASP page for the user to run the...

I'd go with Derrick's suggestion. I've always found that data manipulation was much faster and cleaner once the data was in a SQL database.

Doing things like setting PK/FK is easy...

The age old answer is "... it depends ..."

What sort of network bandwidth do you have between the databases?

How much data are you transferring, thousands or millions?

Are you transferring all...

Check out the use of tokens for SQL Agent in BOL.

There is a good example of their use here,

http://www.sqldev.net/sqlagent/SQLAgentStepTokens.htm

Also, depending on ANSI settings, a COUNT(*) can cause NULL entries to be excluded from the COUNT.

Do you have any formulas in your report?

I found that when you have formulas it creates named ranges for each cell referenced in a formula. This not only slows the...

Use a workflow script and set the next step to inactive. This will cause the remaining steps to be bypassed.

You'll have to create an new ADO connection within your ActiveX task.

For our 24x7 website we have a number of tables that record session information, including each page a user visited. this table averages around 4-5mil records.

To keep the size manageable,...

There was an article posted recently about capturing the full text of the error message. It involved setting the error to log to the SQL error log and then retrieving...

Take a look at,

http://www.sqldts.com/default.aspx?103

Looping, Importing and Archiving

How can I check if a file exists?