DTS 2000 Migration Issue

Hi ,
I am trying to Migrate DTS 2000 package to SQL 2005.

I am opening the wizard form SQL Server Management Studio>Object Explorer>Management->Legacy->DTS ->Migration Wizard .

when i run the wizard with source location than folder destination .

In the third step of the wizard i am getting an error saying :

This wizard will close because it encountered the following error:

ADDITIONAL INFORMATION:

Index was out of range. Must be non-negative and less than the size of the collection.

Parameter name: index (mscorlib)

Please advice me how to proceed ?

Thank you

Syeda

This is a known issue. See:

http://support.microsoft.com/kb/917420/en-us

DtPicker Format

i have placed one date picker in a Vb form,while i select the value from datepicker the selected value is assigned to a textbox,while selection it is selecting in proper date format but my backend is SQL 2000,in backend it is storing the date as 1/1/1900 .00.00.00 ,so can help why this happens and send me the correct coding for that .

what i found out is while i select date between eg: 1/1/00 to 12/1/00 it will store in a correct format in backend,but if select 13/1/00 it won't store,i think it is taking in yyyy-dd-mm,i had given coding like this
insert into (regdate) values(' " & format(text1.text,"dd/mm/yy") & " ')"

can u help me for this by sending correct coding

thanks

saiju

saijumammen@.gmail.comTry this format

insert into (regdate) values(' " & format(text1.text,"dd-mmm-yyyy") & " ')"|||Dear Saiju
I had this problem , the best way to beat this is to change the date to "dd MMM yyyy" format and store it , Believe me it works

chk = format (dtpicker1.value,"dd MMM yyyy")
This is in a string format
Project it to the insert statement as a string and it works
This is to compliment what madhi has said|||Thank u ,Madhi & Rambi for the assistance for my Datepicker Problem.

This really helped me

Thanks once again

Saiju Mammen