Viewing 6 posts - 1 through 7 (of 7 total)
I feel a bit dumb here but thanks to Greg's suggestions I've discovered that the packages are being executed from the jobs on the 2005 server but appear to be...
July 14, 2009 at 3:48 pm
2000 dts packages are msdb.
DTS jobs are of type "Operating System Command".
I don't think any of the DTS packages were converted to SSIS. I just think they were transfered...
July 14, 2009 at 3:29 pm
Addicted,
You have accurately described what I did.
Transferring the jobs also seems to have transferred the DTS packages that those jobs run. Jobs that kick off DTS packages work....
July 14, 2009 at 3:03 pm
Transferred the jobs using a "transfer job task" in visual studio.
July 14, 2009 at 12:40 pm
To be more accurate, I installed the 2000 DTS designer components. I just installed backward compatibility components (on my client) and I'm still not seeing the packages.
Thanks
July 14, 2009 at 12:22 pm
Thanks. I installed the backward compatibility tools and I can now see/modify one of the DTS packages that I transferred to the new server. It shows up under...
July 14, 2009 at 11:49 am
Viewing 6 posts - 1 through 7 (of 7 total)