You were getting varchar(0) issue before as Date Data type was not supported in SQL Server. Effective in version 10.2 HotFix 1, you can read or write the date data type when you use the Microsoft SQL Server connection in an Informatica mapping.
Let me know If this helps.
Can you confirm If provided response has helped in answering your queries? If yes, Please mark the above Reply as helpful and so that we can close this thread.