Have anyone work with this file format in SSIS.
I am migrating a DTS package to SSIS one.
In the DTS, they use the DIF file format (Data Interchange Format).
I tried ODBC and Excel Source in the SSIS but still no luck.
Here is the dif file sample:
------------------------------------------
TABLE
0,1
"EXCEL"
VECTORS
0,2
""
TUPLES
0,6
""
DATA
0,0
""
-1,0
BOT
1,0
"Chg User"
1,0
"Addr#"
1,0
"FieldName"
1,0
"Old Value"
1,0
"New Value"
1,0
"Chg Date"
-1,0
BOT
1,0
"agk"
1,0
"agk"
1,0
"agk"
1,0
"abc"
1,0
"abc"
0,11/27/2009 16:37
V
-1,0
EOD
------------------------------------------