November 26, 2008 at 1:47 am
Hi to all,
i have migrated my dts package from 2000 to 2005 server. But the problem is that, Where will the newly migrated SSIS (.dtsx) file(s) reside ? I also checked the log file its showing migrated source is '(local)\file name'. i searched but it in all drives but i havn't find out. please anybody help me out. and in log file it shows successfull migration.
Thanx in advance,
rgrds,
m.i.
________________________________________
M.I.
[font="Times New Roman"]
November 26, 2008 at 12:10 pm
Please describe how you migrated the DTS package to SSIS. Did you use the Migration Wizard in SSMS or in BIDS? If you did, you have to choose a location for the .dtsx file. You will find it there.
Greg
November 27, 2008 at 3:06 am
destination problem i have solved. but new problem is come in front of me when it complete the migration wizard that time its showing an error message,
'Exception of type 'Microsoft.SqlServer.Dts.MigrationWizard.HelperUtility.DTSMWException' was thrown.'
i skip this error and continued the migration after that i search my dts package file i have not found it on the destination. pleas help me out by this problem its really very urgent.
Thanks in advance.
rgrds,
m.i.
________________________________________
M.I.
[font="Times New Roman"]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply