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.

All Forums  SQL Server 2005 Forums  SSIS and Import/Export (2005)  "Execute DTS 2000" task and compatibility mode

Author  Topic  iltop Starting Member 1 Post Posted - 2010-03-01 : 15:42:08 Hello everyone, Got 2 questions regarding ssis and dts 2000: 1. Say you have a ssis package that contains "Execute DTS 2000 package" task and structured storage dts 2000 file that gets executed from that ssis - would changing target database compatibility level property to 90 effect the execution of that ssis package? 2. Would usage of SQL Server 2005 encryption components(certificates) effect the execution of that ssis package? Thanks in advance.