Hi @bvasu
Just to clarify, please refer to this post as far as support for existing legacy workflows are concerned:
This means that if you do struggle with the conversion, it is best to stick to the legacy workflow for now.
Also, the default conversion is making a copy of your project, so you should be able to easily go back to your old project
Now, as to the issue - could you please let us know the version of your Database package? Is this the latest 1.7.1 version? If not, does updating it helps to resolve this issue?
To debug things a bit more - does adding a new Connect to Database activity and configuring it from scratch help you resolve the issue?