Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cannot define columns for text file on DTS Package

Status
Not open for further replies.

DDR

Technical User
Aug 22, 2001
54
0
0
US
Hi All
I'm trying to make a tab delimited text file out of a query that works fine , but when I go to define columns from the source query on the text file all I get is blank and nothing gets populated, then when I try to go back and define columns again the MMC just crashes.
Can anyone helpme on this?

Here is the query


SELECT FinalItem, t_dsca, t_cuni, t_item, itemgroup, EngStatus,
leadtimecode, t_dten, glacct, t_citg, t_stoc, t_maxs, t_sfst, t_wght,
t_fltm, '' as pur_lt, '' as mfg_lt, t_osys, t_mioq, t_maoq, t_oqmf,
'' as IgnoreOh, '' as ProdCode, '' as MfgLTMethod,
'' as PlpoRpnFlg, '' as ConsPlanXfers, '' as MrpAnalyPer,
'' as WaXferCalcTyp, '' as FkstItem, '' as TranLTCode, '' as OrdPol
, '' as BKConsMPS, '' as ATPShpOfst, '' as ATPPerTChk
, '' as OBKPer, '' as OrdSplt
FROM items
group by FinalItem, t_dsca, t_cuni, t_item, itemgroup, EngStatus,
leadtimecode, t_dten, glacct, t_citg, t_stoc, t_maxs, t_sfst, t_wght,
t_fltm, t_osys, t_mioq, t_maoq, t_oqmf
having right(FinalItem,1)<>'Z'
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top