Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ismailc
Constraint Violating Yak Guru
290 Posts |
 Posted - 2008-03-11 : 05:20:55
|
| Hi, I need help please!I have a text file destination, the sql is in pipe delimted with one column writing an asc file. But i notice in my asc file the data gets trimmed off which did not happen previously. I add another measure. I then checked on Transform Data Task Properties that my column size has increased to 620. How do i set Enterprise Manager to allow the column size? Is this my problem or is is something else?Regards, |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-03-11 : 07:32:27
|
| Didnt understand your exact problem. Is your source data coming from a table? whats length of source data? |
 |
|
|
ismailc
Constraint Violating Yak Guru
290 Posts |
Posted - 2008-03-11 : 09:10:25
|
| Hi, I'm outputting in pipe delimted as one column.eg: select 'Item|Channel|Region|SubBrand|Category|SubBus Unit|LifeStage|Regrade Filter|Brand Office|Product Manager|Master Brand|Item Usage Level 2,SalesVolume,SalesValue,BudgetVolume,BudgetValue,HistoryVolume,HistoryValue,ForecastVolume,LPDBudget,LPDForecast' as OutputVar Union All Select +'|'+rtrim(V_Main) +'|'+str(SalesVolume,9,4) as SalesVolume +'|'+str(SalesValue,9,4) as SalesValue |
|
|
|
|
|
|
|
|
Column Size of 620, how do i set Enterprise Man?