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 - 2007-04-26 : 07:05:49
|
| Hi,Enterprise Manager, DTS 2000 - Set Maximum Characters per column. I have a query which is okay when i run via Query Analyzer 2000 becuase I set the limit via Query Analyzer 2000: Tools - Options - Results - set maximum characters per columnBut when I create a DTS package - it does not work and cuts off the text. Does anyone know how to set this in Enterprise Manager + DTS ?Thank YouRegardsIsmail |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-04-26 : 07:09:11
|
| What is your source data, and how do your target table look like?Peter LarssonHelsingborg, Sweden |
 |
|
|
ismailc
Constraint Violating Yak Guru
290 Posts |
Posted - 2007-04-26 : 07:16:47
|
| Thank You for the response. I'm outputting to an ASC file. Which the end product being one column (OutputVar)which is derived from a pipe delimeted query. Query:select 'Period|Region|Node Level 1|Node Level 2|Node Level 3|Node Level 4|Customer|Merch Group|Merch Region|Merch Rep|Category|SubBus Unit|Sales Volume|Sales Value' as OutputVar Union All Select rtrim(V_Main) +'|'+str(Sales_Volume,9,4) +'|'+str(Sales_Value,9,4)Result: only stores 256 then cuts it off2007.04|EASTERN CAPE|PNP Supermarkets/Mini/Family|PNP Eastern Cape|PNP Family Stores-Eastern Cape|PNP Family Stores-Eastern Cape|Pick'nPay FF Oudtshoorn [76910]|Deon Morgan [00008]|PFMS Eastern Cape [00008]|PFMS [08035]|Yoghurt & Desserts [004]|Yoghurt [0 |
|
|
|
|
|
|
DTS 2000 - Set Maximum Characters per column