December 14, 2009 at 1:10 pm
We added two new columns to a table. That table is used in a SSIS package.
So i have to change whole package to accomodate those two new columns.
I changed data flow task and next to data flow task there is a Execute Sql loader for headers- name of the execute process task.
There is a .bat file already made for that. So now i have to edit the execute process task so that i can add two new columns.
How can i edit those .bat files.
December 14, 2009 at 1:29 pm
rahulsony111 (12/14/2009)
How can i edit those .bat files.
You can edit a .bat file (batch file) from any text editor, including notepad.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 14, 2009 at 1:47 pm
As you said i right clicked the .bat file and clicked EDIT
It opened in a notepad
Can you explain me what this code is doing
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
This is the code inside bat file
December 14, 2009 at 2:34 pm
[font="Comic Sans MS"]
set NLS_DATE_FORMAT=Mon dd YYYY HH:mi:ssAM
setting session 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
above lines are just comments
cd ..\..\..\..\..\..K:
cd BCP
cd DEV
cd SQL_LOADER
Moving out of 6 directories .. then K:\BCP\DEV\SQL_LOADER
sqlldr DWSSTG01/pwd4DVstg@DWBDV101 control=Control_Files\AWT20120_ORD_FACT_HEADER.ctl DIRECT=TRUE log=logs\AWT20120_ORD_FACT_HEADER.log
using sqlloader utility to load the file (details mentioned in Control_Files\AWT20120_ORD_FACT_HEADER.ctl )
For more information see:
http://www.oracleutilities.com/OSUtil/sqlldr.html
[/font]
[font="Comic Sans MS"]--
Sabya[/font]
December 14, 2009 at 2:45 pm
Thank you vey much for detailed explanation
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply