DTS Failure

[sommers56]

I am attempting to export data to a flat file from the database. I am attempting to use the following query:

SELECT
T1.CONFLICT_ID,
CONVERT (VARCHAR (10),T1.LAST_UPD, 101) + ' ' + CONVERT (VARCHAR (10),T1.LAST_UPD, 8),
CONVERT (VARCHAR (10),T1.CREATED, 101) + ' ' + CONVERT (VARCHAR (10),T1.CREATED, 8),
T1.LAST_UPD_BY,
T1.CREATED_BY,
T1.MODIFICATION_NUM,
T1.ROW_ID,
T1.SR_TITLE,
T8.NAME,
T8.DESC_TEXT,
T1.CST_OU_ID,
T8.INTEGRATION_ID,
T8.LOC,
T8.CUST_STAT_CD,
T1.SR_AREA,
T1.ASSET_ID,
T1.ASGN_USR_EXCLD_FLG,
T1.BILLABLE_FLG,
CONVERT (VARCHAR (10),T1.ACT_CLOSE_DT, 101) + ' ' + CONVERT (VARCHAR (10),T1.ACT_CLOSE_DT, 8),
T2.NAME,
T1.PR_CON_ORG_ID,
T2.INTEGRATION_ID,
T6.WORK_PH_NUM,
T6.FST_NAME,
T1.CST_CON_ID,
T6.LAST_NAME,
T3.LOGIN,
T8.OU_NUM,
T1.ORG_PRDINT_ID,
T1.SR_CST_NUM,
T1.DESC_TEXT,
T4.LOGIN,
T8.ROW_ID,
T2.ROW_ID,
T6.ROW_ID,
T8.MAIN_FAX_PH_NUM,
T8.MAIN_PH_NUM,
T1.ASGN_MANL_FLG,
T1.OWNER_OU_ID,
T1.OWNER_EMP_ID,
T4.LOGIN,
T6.EMAIL_ADDR,
T9.NAME,
T6.WORK_PH_NUM,
T1.PRI_LST_ID,
T8.PR_ADDR_ID,
T6.PR_OU_ADDR_ID,
T1.BU_ID,
T8.PR_SRV_AGREE_ID,
T1.PR_SYMPTOM_CD,
T8.PR_SYN_ID,
T1.SR_PRIO_CD,
T10.NAME,
T1.PRDINT_ID,
T1.RATE_LST_ID,
T1.SR_REPRODUCE,
T1.ROW_STATUS,
T5.SERIAL_NUM,
T7.SVC_CALENDAR_ID,
T1.SR_TYPE_CD,
T1.SR_SEV_CD,
T1.SR_SUBTYPE_CD,
T1.SR_NUM,
T1.SR_CAT_TYPE_CD,
T1.SR_STAT_ID,
T1.SR_SUB_AREA,
T1.SR_SUB_STAT_ID,
T1.ASGN_SYS_FLG,
T8.OU_TYPE_CD,
T1.SR_PROD_VERSION,
T11.SYMPTOM_CD,
T11.ROW_ID
FROM
dbo.S_SRV_REQ T1
LEFT OUTER JOIN dbo.S_ORG_EXT T2 ON T1.PR_CON_ORG_ID = T2.PAR_ROW_ID
LEFT OUTER JOIN dbo.S_USER T3 ON T1.CREATED_BY = T3.PAR_ROW_ID
LEFT OUTER JOIN dbo.S_USER T4 ON T1.OWNER_EMP_ID = T4.PAR_ROW_ID
LEFT OUTER JOIN dbo.S_ASSET T5 ON T1.ASSET_ID = T5.ROW_ID
LEFT OUTER JOIN dbo.S_CONTACT T6 ON T1.CST_CON_ID = T6.PAR_ROW_ID
LEFT OUTER JOIN dbo.S_ENTLMNT T7 ON T1.AGREE_ID = T7.ROW_ID
LEFT OUTER JOIN dbo.S_ORG_EXT T8 ON T1.CST_OU_ID = T8.PAR_ROW_ID
LEFT OUTER JOIN dbo.S_ORG_EXT T9 ON T1.OWNER_OU_ID = T9.PAR_ROW_ID
LEFT OUTER JOIN dbo.S_PROD_INT T10 ON T1.PRDINT_ID = T10.ROW_ID
LEFT OUTER JOIN dbo.S_SYMPTOM T11 ON T1.PR_SYMPTOM_CD = T11.ROW_ID
WHERE
(T1.TEMPLATE_FLG != 'Y')

The DTS fails first with the following error:

Error Description: Please specify a valid Name and Ordinal values for the Column.

If I then double click on the Step Name, I am presented with this:

The Data Pump Task requires transformations to be specified.

No transformations should be required because I am exporting, one-for-one, each column in the source to the destination.

Can anyone help? I've seen a lot of examples of this error on the 'Net, but none seem to fit my situation.

Thanks,

Steve

 

[mrdenny]

You need to setup aliases for the computted columns.

Transformations are still required even if it's a one to one mapping.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com