Ignore relations on import? (or export)

#1

Is there a way to do that?

TIA!

Stanko.
www.milosev.co.yu

#2

"Stanko Milosev" wrote:

Quote:

Is there a way to do that?

TIA!

Stanko.
www.milosev.co.yu

#3

If you look on the last tab of the DataPump task you will see a little
checkbox to say whether you want to check constraints. Simply uncheck this.

"Stanko Milosev" wrote:

Quote:

Is there a way to do that?

TIA!

Stanko.
www.milosev.co.yu

#4

Thank you Frank for your answer,

I need one more information, we have more than 120 tables, which we still
develop, we will change structure, and maybe add some new table and/or
referential integrity, and users already started to enter data.

We would like, on right click to export database, to a temp database, delete
master database, run sql script which we will bring from our company, and
then import data back to master. This will happen frequently, it is too much
to go on every task to uncheck check constraints, is there any wizard which
will do that instead of us?

Thank you once again, for your time,
Stanko.
www.milosev.co.yu

"frank chang" <frankchang (AT) discussions (DOT) microsoft.com> wrote

Quote:

If you look on the last tab of the DataPump task you will see a little
checkbox to say whether you want to check constraints. Simply uncheck
this.

"Stanko Milosev" wrote:

Is there a way to do that?

TIA!

Stanko.
www.milosev.co.yu

#5

Stanko, Do you have an email? Thank you.

"Stanko Milosev" wrote:

Quote:

Thank you Frank for your answer,

I need one more information, we have more than 120 tables, which we still
develop, we will change structure, and maybe add some new table and/or
referential integrity, and users already started to enter data.

We would like, on right click to export database, to a temp database, delete
master database, run sql script which we will bring from our company, and
then import data back to master. This will happen frequently, it is too much
to go on every task to uncheck check constraints, is there any wizard which
will do that instead of us?

Thank you once again, for your time,
Stanko.
www.milosev.co.yu

"frank chang" <frankchang (AT) discussions (DOT) microsoft.com> wrote in message
news:E23F87B6-3A28-4EE4-869B-2E6C8ECDD8BD (AT) microsoft (DOT) com...
If you look on the last tab of the DataPump task you will see a little
checkbox to say whether you want to check constraints. Simply uncheck
this.

"Stanko Milosev" wrote:

Is there a way to do that?

TIA!

Stanko.
www.milosev.co.yu

#6

Stanko, One can write a small program that would would programmatically
uncheck all the check constraints in your package. I can email it to you.

"Stanko Milosev" wrote:

Quote:

Thank you Frank for your answer,

I need one more information, we have more than 120 tables, which we still
develop, we will change structure, and maybe add some new table and/or
referential integrity, and users already started to enter data.

We would like, on right click to export database, to a temp database, delete
master database, run sql script which we will bring from our company, and
then import data back to master. This will happen frequently, it is too much
to go on every task to uncheck check constraints, is there any wizard which
will do that instead of us?

Thank you once again, for your time,
Stanko.
www.milosev.co.yu

"frank chang" <frankchang (AT) discussions (DOT) microsoft.com> wrote in message
news:E23F87B6-3A28-4EE4-869B-2E6C8ECDD8BD (AT) microsoft (DOT) com...
If you look on the last tab of the DataPump task you will see a little
checkbox to say whether you want to check constraints. Simply uncheck
this.

"Stanko Milosev" wrote:

Is there a way to do that?

TIA!

Stanko.
www.milosev.co.yu

#7

I am sorry Frank for not answering you yesterday, my e - mail's are:

stanko (AT) netcomp (DOT) co.yu
stanko (AT) milosev (DOT) co.yu

If it is not taking you time too much, I would be very thankful for that
program.

Thank you very much,
Stanko.

"frank chang" <frankchang (AT) discussions (DOT) microsoft.com> wrote

Quote:

Stanko, Do you have an email? Thank you.

"Stanko Milosev" wrote:

Thank you Frank for your answer,

I need one more information, we have more than 120 tables, which we still
develop, we will change structure, and maybe add some new table and/or
referential integrity, and users already started to enter data.

We would like, on right click to export database, to a temp database,
delete
master database, run sql script which we will bring from our company, and
then import data back to master. This will happen frequently, it is too
much
to go on every task to uncheck check constraints, is there any wizard
which
will do that instead of us?

Thank you once again, for your time,
Stanko.
www.milosev.co.yu

"frank chang" <frankchang (AT) discussions (DOT) microsoft.com> wrote in message
news:E23F87B6-3A28-4EE4-869B-2E6C8ECDD8BD (AT) microsoft (DOT) com...
If you look on the last tab of the DataPump task you will see a little
checkbox to say whether you want to check constraints. Simply uncheck
this.

"Stanko Milosev" wrote:

Is there a way to do that?

TIA!

Stanko.
www.milosev.co.yu

#8

Stanko, I have no problem with the fact that you did not answer me
yesterday. The solution to your question is to create an Active X script
task at the beginning of your package. In this Active X Script, please
insert the following VBScript code :

Set oPkg = DTSGlobalVariables.Parent
For Each oTask In oPkg.Tasks
If oTask.CustomTaskID = "DTSDataPumpTask" Then
Set cus = oTask.CustomTask
cus.FastLoadOptions = 0
End If
Next

If you have any further questions, please email me at
frank_chang91 (AT) hotmail (DOT) com.
Thank you.

"Stanko Milosev" wrote:

Quote:

I am sorry Frank for not answering you yesterday, my e - mail's are:

stanko (AT) netcomp (DOT) co.yu
stanko (AT) milosev (DOT) co.yu

If it is not taking you time too much, I would be very thankful for that
program.

Thank you very much,
Stanko.

"frank chang" <frankchang (AT) discussions (DOT) microsoft.com> wrote in message
news:6A4D4416-36D4-4FBC-A0BB-7F7B3BB7FB44 (AT) microsoft (DOT) com...
Stanko, Do you have an email? Thank you.

"Stanko Milosev" wrote:

Thank you Frank for your answer,

I need one more information, we have more than 120 tables, which we still
develop, we will change structure, and maybe add some new table and/or
referential integrity, and users already started to enter data.

We would like, on right click to export database, to a temp database,
delete
master database, run sql script which we will bring from our company, and
then import data back to master. This will happen frequently, it is too
much
to go on every task to uncheck check constraints, is there any wizard
which
will do that instead of us?

Thank you once again, for your time,
Stanko.
www.milosev.co.yu

"frank chang" <frankchang (AT) discussions (DOT) microsoft.com> wrote in message
news:E23F87B6-3A28-4EE4-869B-2E6C8ECDD8BD (AT) microsoft (DOT) com...
If you look on the last tab of the DataPump task you will see a little
checkbox to say whether you want to check constraints. Simply uncheck
this.

"Stanko Milosev" wrote:

Is there a way to do that?

TIA!

Stanko.
www.milosev.co.yu

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Ignore relations on import? (or export)

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Ignore relations on import? (or export) - 07-25-2005 , 05:45 AM

RE: Ignore relations on import? (or export) - 07-25-2005 , 07:56 AM

RE: Ignore relations on import? (or export) - 07-25-2005 , 07:56 AM

Re: Ignore relations on import? (or export) - 07-25-2005 , 08:29 AM

Re: Ignore relations on import? (or export) - 07-25-2005 , 09:10 AM

Re: Ignore relations on import? (or export) - 07-25-2005 , 09:35 AM

Re: Ignore relations on import? (or export) - 07-26-2005 , 01:26 AM

Re: Ignore relations on import? (or export) - 07-26-2005 , 07:27 AM