December 14, 2009 at 2:18 pm
I added two new columns to a tablw which in turn is used by a SSIS package.
I have a Exexute process task and its name "Execute Sql loader for headers". In that there is a path to a batch file.
Now i have to edit that batch file so that those two new columns shoul dbe accomodated.
I have the batch file and when i open that in notepad i can see this code
set NLS_DATE_FORMAT=Mon dd YYYY HH:mi:ssAM
REM set NLS_TIMESTAMP_FORMAT=Mon dd YYYY HH:mi:ffAM
REM set NLS_LANGUAGE=<insert the language of your database here e.g., US7ASCII>
REM sqlplus <Username>/<Password> < pre_load.sql
cd ..\..\..\..\..\..\
K:
cd BCP
cd DEV
cd SQL_LOADER
sqlldr DWSSTG01/pwd4DVstg@DWBDV101 control=Control_Files\AWT20120_ORD_FACT_HEADER.ctl DIRECT=TRUE log=logs\AWT20120_ORD_FACT_HEADER.log
REM sqlplus <Username>/<Password> < post_load.sql
What does this code mean and how can i modify this code so that two newly added columns can be added
December 14, 2009 at 2:35 pm
[font="Comic Sans MS"]
Duplicate post - use http://www.oracleutilities.com/OSUtil/sqlldr.html
[/font]
[font="Comic Sans MS"]--
Sabya[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply