Hi guys,
I currently have two FTP jobs that use the FTP Enterprise stage. Both jobs have exact same settings, FTP from a Netezza Connector, and write a .txt file to a directory. The weird thing is that one .txt file has the column names as the first line, and the other does not.
The first job uses this query in the Netezza connector(no column names):
SELECT Supplier_ID,
Supplier_1,
Supplier_2,
Supplier_3,
Supplier_4,
Supplier_5,
Supplier_6,
Supplier_7,
Supplier_8,
Supplier_9,
Supplier_10,
RTrim(Supplier_11) AS Supplier_11,
Source_System_Code
FROM dim_supplier;
The second job uses this query in the Netezza connector(has column names):
select * from dim_item;
I know that the FTP plug-in has an option for column names. Since I don't see any option to have the column names as the first line in the FTP Enterprise stage, I was just wondering why one file has column names and the other does not.
Thanks.
-Sou
FTP Stage not sending Columns as First Line
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 33
- Joined: Tue Sep 02, 2014 7:43 am
-
- Premium Member
- Posts: 33
- Joined: Tue Sep 02, 2014 7:43 am