RUN SQL 2005 SSIS Package on SQL 2000 BOXES?

I have a package designed and working correctly for months now. My challenge now is to run this package on a box that does not have SQL 2005 SSIS install. It has SQL 2000 installed.

My question is - Can I compile the SSIS into EXE or any other kind of DTS package to run on a none-SQL 2005 box?

Thanks!

--Jon

You don't need ANY version of SQL Server (i.e. the database engine) installed in order to run a SSIS package. You just need SSIS installed.

And no, its not possible to run it without having SSIS installed. That's what you pay the money for.

-Jamie

Rtrim

If Rtrim doesn't catch space at the end is there a way to catch strings that match but don't seem to get selected correctly when matching?Um, what do you mean by "Rtrim doesn't catch space at the end"? Or by "catch strings that match but don't seem to get selected correctly when matching"?|||Some sample data and some code would be helpfull.|||Is it possible there is some unwriteable chars there? Ie ASCII below 32?

I don't if the show up or not in SQL-Server, just related to C++ programming where unwriteable chars can mess up things.|||use this to check if the last char really is a space...

SELECT
ASCII(SUBSTRING(yourcolumnname, len(yourcolumnname), 1))
FROM yourtable