Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ujjaval
Posting Yak Master
108 Posts |
 Posted - 2007-09-28 : 04:56:53
|
| Hi everyone,I'm not sure if this posts belongs here. But I was wondering, can I run SSIS package created on SQL Server 2005 to SQL Server 2000 database?I just need to run that job once off. It involves bit of comparison, derived columns etc. And I have SSIS package for 2005. So just looking to map it to 2000 database.Thanks,Ujjaval |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-09-28 : 05:04:56
|
| Yes if package refers to SQL 2000 database, it runs perfectly fine unless you use features specific to SQL 2005 like CTE.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
Running SSIS on SQL Server 2000