DTS not working in sql 2008
-
I want to create the existing sql2000 DTS in sql 2008, i installed sql2000 backward compatibility. i can open the DTS in sql2008 and save as the location sql server. It is saving in sql2008 and when i open the dts in the popup window asking to select the version, but i can't see any version in the popup window.how can i sort this issue.
-
I want to create the existing sql2000 DTS in sql 2008, i installed sql2000 backward compatibility. i can open the DTS in sql2008 and save as the location sql server. It is saving in sql2008 and when i open the dts in the popup window asking to select the version, but i can't see any version in the popup window.how can i sort this issue.
DTS is sort of gone in 2005 and up. Look at SSIS.
-
I want to create the existing sql2000 DTS in sql 2008, i installed sql2000 backward compatibility. i can open the DTS in sql2008 and save as the location sql server. It is saving in sql2008 and when i open the dts in the popup window asking to select the version, but i can't see any version in the popup window.how can i sort this issue.
Rewrite the bloody thing, you are relying on a conversion utility to work perfectly, they almost never do, especially with anything that is even mildly complex.
Never underestimate the power of human stupidity RAH