Flat files

How to create a temporary table in sql 2005 via SSIS

I need to load a flat file into a temporary table. So I need to know how to step by step how to in SSIS "Data Flow Task" create a temporary table, load one col from the flat file to the temporary table along with the date it was loaded. I will then use the temporary table to delete from another...

View Answer   |  Oct 1 2008   8:55 PM GMT   |  asked by NewBee7
SQL tables, SQL 2005, SSIS

Update in SQL

I have a flat file which I want to update starting from position 2 to 4. I used below UPDATE statement:UPDATE FLAT_FILESET SUBSTR(FLAT_FILE,2,2)= 'AA'WHERE SUBSTR(FLAT_FILE,1,2) = 'HH'The above SQL Query is throwing an error SQL0104 for missing token.Can anybody suggest me on the above.Thank You.

View Answer   |  Sep 30 2008   12:01 AM GMT   |  asked by Vids
SQL/400, SQL0104, UPDATE statement

Inserting a flat file into a temporary table

I need to take a flat file and insert it into a temporary table, then use that table to delete from another table all rows based on "col 7" of the temp table which may have duplicate values. Then from the temporary add to the perm table all rows. Do you have any suggestions, step by step for this...

View Answer   |  Sep 29 2008   9:40 PM GMT   |  asked by ITKE
Flat files

How can I define a flat file in RPGLE?

How can I define a flat file in RPGLE?

View Answer   |  Sep 16 2008   10:39 PM GMT   |  asked by Claudiarce
Flat files, RPGLE, RPG

Problems with tranferring flat file from mainframe to Outlook as CSV file

I am trying to e-mail a plain text comma delimited flat file from the mainfram to Outlook. I have the coding working to transfer the file but when the file arrives in outlook the first character on each line is an '&'. When EXCEL trys to open the file it generates an error message that this is an...

Answer Question   |  Sep 2 2008   4:59 PM GMT   |  asked by Rickb1974
MIME, CSV, Outlook

Actuate 8 enterprise reporting tool,Text files

Hello,Am currently using actuate 8 as a reporting tool.The major problem encountered is to deal with flat files with fields separated with other delimiters other than commas.For example I encountered a flat file delimited with back slash am unable to tackle.Is there any way out in Actuate 8 or...

View Answer   |  Aug 7 2008   10:44 AM GMT   |  asked by Ingosi
Actuate, Database reporting, Actuate 8

ODSObject to Infocube

TransactionData Loading from ODSobject to Infocube Manually from FlatFile

View Answer   |  Aug 4 2008   3:45 PM GMT   |  asked by ITSME
InfoCube, ODSObject, Flat files

restore AS400 to flat file

How can I restore an AS400 backup tape to flat file?We don't have an AS 400 system.

View Answer   |  Jul 28 2008   2:29 PM GMT   |  asked by NVDV
AS/400 backup, Backup & recovery, Flat files

how to Move one file(flat file or PF) which is created in a batch job, to the systems C: drive.

how to Move one file(flat file or PF) which is created in a batch job, to the systems C: drive. sing CL

View Answer   |  Jul 22 2008   6:09 AM GMT   |  asked by It doubts
Flat files, PF/LF, CL

mdb talk to jdbc

is it possible to make an inner procedure in (any) jdbc db that will produce simple p2p connection with another db for example a mdb, this is highly needed that the other db will be a flat file (mdb),if you know any way to create connection through another db, with a non-java db (not a jdbc server)...

Answer Question   |  Jun 6 2008   3:40 PM GMT   |  asked by Elad Karako
JDBC, Query, Microsoft Access

Packed fields in Flat Files

I have a flat 400 file wich is 36 long internally described as follows: 1 2 0ICL 3 6 0ORDNO 7 8 0SUB 9 11 0DEPT P 12 13 2RATE P 14 18 2TOTMTH P 19 23 2OTODAT P 24 28 1HRS2DT 29 36 0INFODT I creasted...

View Answer   |  Jun 3 2008   3:27 PM GMT   |  asked by JAC
AS/400, Flat files, OS/400

how to create a flat file

how to creat a flat file,

Answer Question   |  Oct 11 2007   7:09 AM GMT   |  asked by Madhumadhu
Flat files