Frank is Right, It is not necessary to use variables, although it is good prtaice. for me, i always try to avoid it for 2 reasons. first i am new...

hey Ananth, When you create dtsconfig file, just open it in the text editor and the change the name of server and if database, change database name in the config...

Hey Todd, If i were you, which i am not..

I would use DTS Migration wizard to migrate 2000 dts packages to 2005 SSIS. This wizard is very poerful and helpful...

Hey Gray CHEERSSSSSSSSSSSSSSSS !!!

Ur package is much simpler than what i have expected. There will 95 % migration in this package.

I see it has dynamic properties task, not supported...

Hey Gray , rt now i am doing DTS migration. I have 70 dts packages. ( but i am not a pro....) this is my first migartion too... But i...

I don't agree with above. the whole purpose of XMl config file is to ease during deployment. If i have to make config file for each package, then why u...

I did some in JAVA and little in .net, but that was long back in the college only.

Let's give a lift to the topic, as i want to learn this too.

Hey john Sorry for late Thanks..

Actually i am doind DTS migration, so i am just trying to avoid any compexcity here. Another thing, I am very new to SSIS, so...

Thanks Paul, App..... Ur Time !!!!

I do belive books by wrox are very helpful. I do have both expert and pro.....

As I feel little uncomfortable with variables and also because...

Looks Like we are in the same situtaion. Rt. Now i am in a project where i am migrating almost 70 dts packages into SSIS. Most of the work for...

Hey USE "Export Import " Wizard in SSIS. Either save it as package or run right there.

Its much easier and faster...

KUMAR

Thanks Jack, I know the problem , ALl the rows where 3rd column which is database timestamp is the problem. the rows where this column is empty is given...

Dear Matt, Looks like u have lots of Knowledge. I tried all possibles that i can find inside the box. I believe i need to look outside of the box....

Dear Matt, SOrry If i sounded bir Hrash!!!

The problem is i cannot do conditional split becoaz he wants the data in the same order as it...