|
Home > Archive > MS SQL Server DTS > July 2005 > Ignore relations on import? (or export)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Ignore relations on import? (or export)
|
|
| Stanko Milosev 2005-07-25, 7:34 am |
| Is there a way to do that?
TIA!
Stanko.
www.milosev.co.yu
| |
| frank chang 2005-07-25, 7:34 am |
|
"Stanko Milosev" wrote:
> Is there a way to do that?
>
> TIA!
>
> Stanko.
> www.milosev.co.yu
>
>
>
| |
| frank chang 2005-07-25, 7:34 am |
| 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
>
>
>
| |
| Stanko Milosev 2005-07-25, 9:29 am |
| 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@discussio
ns.microsoft.com> wrote in message
news:E23F87B6-3A28-4EE4-869B- 2E6C8ECDD8BD@microso
ft.com...[color=darkred]
> 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:
>
| |
| frank chang 2005-07-25, 9:29 am |
| 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@discussio
ns.microsoft.com> wrote in message
> news:E23F87B6-3A28-4EE4-869B- 2E6C8ECDD8BD@microso
ft.com...
>
>
>
| |
| frank chang 2005-07-25, 9:29 am |
| 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:
> 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@discussio
ns.microsoft.com> wrote in message
> news:E23F87B6-3A28-4EE4-869B- 2E6C8ECDD8BD@microso
ft.com...
>
>
>
| |
| Stanko Milosev 2005-07-26, 3:24 am |
| I am sorry Frank for not answering you yesterday, my e - mail's are:
stanko@netcomp.co.yu
stanko@milosev.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@discussio
ns.microsoft.com> wrote in message
news:6A4D4416-36D4-4FBC-A0BB- 7F7B3BB7FB44@microso
ft.com...[color=darkred]
> Stanko, Do you have an email? Thank you.
>
> "Stanko Milosev" wrote:
>
| |
| frank chang 2005-07-26, 7:23 am |
| 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@hotmai
l.com.
Thank you.
"Stanko Milosev" wrote:
> I am sorry Frank for not answering you yesterday, my e - mail's are:
>
> stanko@netcomp.co.yu
> stanko@milosev.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@discussio
ns.microsoft.com> wrote in message
> news:6A4D4416-36D4-4FBC-A0BB- 7F7B3BB7FB44@microso
ft.com...
>
>
>
|
|
|
|
|