Problem with SCD connecting to Oracle

Hello Everyone,

I’m getting a problem in SCD connecting to oracle DB.

I had set the OLE DB Input Output Properties Tab

And mapped the columns in Column Mappings Tab

Every thing is taken care according to Type 2 load

But every time I run the job its inserting the records rather than updating it or ignoring if not find any new or changed records from source.

Can any one help me in sorting this issue.

Please.

From the SCD Component there are three out put links one is Inferred Member Updates Output (connecting to an OLE DB which is updating the target table based on business key), New Output (connected to union all component), &

Historical Attribute Inserts Output (connected to derived column component, OLE DB and union all component)

the problem is in next run the SCD is sending the input records to Historical Attribute Inserts Output pipeline and that is sending the data to destination which in turns inserting the data into target table.

can any one help me in resolving the issue.

this is very critical for my project and I’m not able to resolve it by any ways i had tired out.

my destination table is oracle

Problem with remove files older then in backup

I am using MSDE 2000 sp3 on Windows 2003 Server. I am connecting to this
MSDE from another computer using Enterprise manager. I have created a
maintenance plan that backup the DB once a day. The problem is that in the
option to "remove files older then" - the combo box where the day/week/month
should be is empty so I can not set this option.
How can I fix it ?
Thanks for your time
ra294@.hotmail.comIn the end, a maintenance plan just generates a parameter list for
xp_sqlmaint. You can modify this yourself in the job that is created. For
details on the options have a look in BOL for "sqlmaint utility" e.g. the
switch for deleting backups is
-DelBkUps <time_period> where
<time_period> ::= number[minutes | hours | days | weeks | months]
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"ra294" <ra294@.hotmail.com> wrote in message
news:%23CIRutpBEHA.3524@.TK2MSFTNGP10.phx.gbl...
> I am using MSDE 2000 sp3 on Windows 2003 Server. I am connecting to this
> MSDE from another computer using Enterprise manager. I have created a
> maintenance plan that backup the DB once a day. The problem is that in the
> option to "remove files older then" - the combo box where the
day/week/month
> should be is empty so I can not set this option.
> How can I fix it ?
> Thanks for your time
> ra294@.hotmail.com
>
>|||Thanks for the quick response.
Where is this script located ? What's the name of the file ?
ra294@.hotmail.com
"Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
news:%23c9MECrBEHA.1140@.TK2MSFTNGP10.phx.gbl...
> In the end, a maintenance plan just generates a parameter list for
> xp_sqlmaint. You can modify this yourself in the job that is created. For
> details on the options have a look in BOL for "sqlmaint utility" e.g. the
> switch for deleting backups is
> -DelBkUps <time_period> where
> <time_period> ::= number[minutes | hours | days | weeks | months]
> --
> HTH
> Jasper Smith (SQL Server MVP)
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "ra294" <ra294@.hotmail.com> wrote in message
> news:%23CIRutpBEHA.3524@.TK2MSFTNGP10.phx.gbl...
the
> day/week/month
>|||Jobs can be found in the Management>SQL Server Agent>Jobs section in
Enterprise Manager. You should see a job that references your maintenance
plan name. If not you can simply create a job yourself that calls
xp_sqlmaint directly and supply the switches as detailed in BOL
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"ra294" <ra294@.hotmail.com> wrote in message
news:%23%23K2E3rBEHA.140@.TK2MSFTNGP09.phx.gbl...
> Thanks for the quick response.
> Where is this script located ? What's the name of the file ?
> ra294@.hotmail.com
> "Jasper Smith" <jasper_smith9@.hotmail.com> wrote in message
> news:%23c9MECrBEHA.1140@.TK2MSFTNGP10.phx.gbl...
For
the
this
> the
>