Unfortunately the SQL String is too long to fit inside 1 Varchar(8000) variable.  The statement has to have the ability to handle close to 16000 characters.  That's why I broke...

yeah I'm a bonehead... I was using SET instead of SELECT not that that wopuld make a difference, but I use 1 set of code for wwup to 8000 chars...

It has something to do with Veritas/Symantec Backup Exec.  See these posts here...

http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=3089

I would imagine that it would be an install over the current version and would keep all of the users etc.  I have not tested this however.  You'd want to ...

From The SQL 2005 Upgrade FAQ...

I'd imagine it's like calling any other stored procedure/query from another datasource.  Create an other ODBC conniction via your Sybase ODBC driver.

Then create an execute SQL Task and tyep in...

you are correct that's why I suggested the for Nali to look at the KB article that deals with which keys needs changed etc.  Also The do this is a...

you want this... 

sum(CASE ISNUMERIC(EDI_H_Cost)

          WHEN 0

               THEN 0

           ELSE EDI_H_Cost END)

Make sure you test this in a test environment!!!

You could attempt this from a batch file using sc commands

http://technet2.microsoft.com/WindowsServer/f/?en/Library/0a658e97-51d5-4109-b461-a474c799964e1033.mspx

something like this

SC [\\SERVERNAME] stop [servicename]

SC config [servicename] obj=[acountname]...

If you're getting a driver incapable error just for grins why don't you try running the odbcConf Tool it can be downloaded from microsoft here.  I had a problem...

another option could be to create a computed column and place an index on the computed column to help with performance issues...

Here's a link on how to create a computed...

you could combine the columns like so... and use this in your where statement...  If your date column was called datecreated, and your time column was called timecreated.  I'm assuming...

Yeah I'm not really planning to keep the data.  I already have it in my db and I can recreate the data with the tables by rerunning portions of the...

Theoretically I suppose you could save your DTS job as a vbs file and compile it into and executable.  Then you could use the information here http://support.microsoft.com/kb/q137890/ to set it...

I've come accross this error with a goodish number of different datasources.  Specifically with a postgreSQL db that was setup so that it was case sensative.  You could send a...