Hi Team, can i schedule a ssis package which is developed on 2000 database? I have a sql server 2000 server and i am accessing this database using 2005 in another machine and developed a ssis package can i schedule this package? Regards, Eshwar

You have to schedule and run the package on the SQL Sever 2005 server. It can connect to other servers, such as your SQL 2000 server, but the package must run on the machine upon which SSIS is installed, and for this example that is the 2005 machine.http://www.sqlis.com | http://www.konesans.com

Hi Darren, Thanks for reply sorry for late response... I just got a SQL Server 2005 client which am using to connect the 2000 server so it is possible now? Regards, Eshwar.

Still No. As I said before, you must schedule and run the package on a SQL Sever 2005 server. Using a 2005 client is good, but it must connect to a 2005 server, and that server must have SSIS installed. You must then deploy your package to that 2005 server, and then schedule it. How did you develop a SSIS package without the 2005 client to start with? Do you mean DTS or SSIS?http://www.sqlis.com | http://www.konesans.com

I don't have any SQL Server 2005 server. Is it possible still? Thanks, Eshwar

Eshwar, if you don't have SQL Server 2005, you cannot use SSIS.http://www.sqlis.com | http://www.konesans.com