DD deploys only 256 characters in SQL server

Hi,
I am doing data deployment to SQL server 2000. The deployment works fine. The problem is that, when I try to deploy a VFF filed to a table column, it just inserts 256 characters inside it. I am not getting any way to find it. The data type of table column is varchar(500).
It will be gr8, if anyone can throw some light on it.

Env: TS6.5 on windows server 2003, OD 6.1.0.0.0 to SQL server 2000

Thanks in advance,
amit

Find more posts tagged with

Comments

RajatChopra

Error Log Please.
I am assuming that VFF Filed implies VisualFormat Field.

This is strange. Your deployments aren't failing. You are able to enter more than 256 characters onto the textarea, and yet cant deploy all of it...
Is my understanding correct?

Anyhow, deployment descriptor and log files are a must to help troubleshoot

Amit_LnT

Rajat, it was due to buffer limit..
buffer limit of SQL query analyzer. It shows only 256 char.
Wrote a script to pull out the values. and got the complete data..

thanks,
amit