Showing posts with label hurdle. Show all posts
Showing posts with label hurdle. Show all posts

Friday, March 9, 2012

Migration of DTS to SSIS

Well..

Have migrated my SQL 2000 DTS packages to SSIS packages through the package migration Wizard.Also, the hurdle to schedule it as a job has been resolved.But, the concern is the package contains entries\lins for old dataserver.

Is it possible to edit the SSIS pckage using management studio or integration services?

Please move this question to the " SQL Server Integration Services forum" .

Thanks

Migration of DTS to SSIS

Well..

Have migrated my SQL 2000 DTS packages to SSIS packages through the package migration Wizard.Also, the hurdle to schedule it as a job has been resolved.But, the concern is the package contains entries\lins for old dataserver.

Is it possible to edit the SSIS pckage using management studio or integration services?

Please move this question to the " SQL Server Integration Services forum" .

Thanks