We are not going to use our DTS 2000 packages anymore so now I need to connect to the DB2 Files (that are in the DTS 2000 Package) from connection manager in SSIS 2005.
I opened the DTS package in SQL 2005 which is called T16Pend. I opened the DTS 2000 Package Designer and clicked on the arrow (Transform Data Task) and a SQL Query is listed:
SELECT AL1.CLS, AL1.FLG_CDT, AL1.AGED_ALIEN_RSW, AL1.MFT_POSN1_CD, RIGHT(AL1.FO,3) AS FO
FROM MT16.CLAIM AL1, MT16.GEOGR AL2
WHERE (AL2.FO=AL1.FO) AND ((AL1.PEND_STUS_CD='P' AND (NOT AL1.FLG_CDT=' ') AND (NOT AL1.STDT_IND='S') AND AL1.ESCLD_CLM_CD=' ' AND AL1.DLAYD_APP_CD NOT IN ('B', 'C')))
How do I get to these files in the from section:
FROM MT16.CLAIM AL1, MT16.GEOGR AL2
I added a DataFlow in SSIS 2005
The Data Flow Sources are DataReader Source
Excel Source
Flat File Source
OLE DB Source
Raw File Source
XML Source
Where's the source to connect to the files in the DTS package?
I opened the DTS package in SQL 2005 which is called T16Pend. I opened the DTS 2000 Package Designer and clicked on the arrow (Transform Data Task) and a SQL Query is listed:
SELECT AL1.CLS, AL1.FLG_CDT, AL1.AGED_ALIEN_RSW, AL1.MFT_POSN1_CD, RIGHT(AL1.FO,3) AS FO
FROM MT16.CLAIM AL1, MT16.GEOGR AL2
WHERE (AL2.FO=AL1.FO) AND ((AL1.PEND_STUS_CD='P' AND (NOT AL1.FLG_CDT=' ') AND (NOT AL1.STDT_IND='S') AND AL1.ESCLD_CLM_CD=' ' AND AL1.DLAYD_APP_CD NOT IN ('B', 'C')))
How do I get to these files in the from section:
FROM MT16.CLAIM AL1, MT16.GEOGR AL2
I added a DataFlow in SSIS 2005
The Data Flow Sources are DataReader Source
Excel Source
Flat File Source
OLE DB Source
Raw File Source
XML Source
Where's the source to connect to the files in the DTS package?