Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DTS truncates Excel sheet column while using the template file Expand / Collapse
Author
Message
Posted Thursday, December 08, 2011 5:52 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, May 21, 2012 11:56 PM
Points: 92, Visits: 79
Hi,

I am using dts package to execute a stored procedure and storing the output in a excel file. I was facing a problem in which the next time package runs the data was getting appended on the same file . so i used a template file and i solved this prob. But when I use the template file the data is getting truncated in between. Its truncated with 256 characters which was not happening before.

Could any one please throw some light on this to resolve this issue.

Thanks in advance.

Jeyis
Post #1218559
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse