|
Home > Archive > Commerce Server Analysis > November 2006 > data warehouse import wizard
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 |
data warehouse import wizard
|
|
| jordan 2006-09-27, 7:30 pm |
| Hello-
So i have the commerce server and import wizard on one box and the sql
server on another. I need to save the DTS packages and schedule them to run
nightly. However, they only save locally and where I am running the DTS
package, we have no sql box.
What is the best way to import data into the datawarehouse database in this
scenari. Run the import tool on my local dev environment saving the DTS
packages. Then copy these packages to the production sql box and schedule
them from there?
Thanks
Jordan
| |
| jordan 2006-09-27, 7:30 pm |
| Correction. This "However, they only save locally and where I am running the
DTS package, we have no sql box" should be - "However, they only save locally
and where I am running the DW import wizard, we have no sql box. Therefore,
we cannot save the DTS packages when we run the DW import wizard."
"jordan" wrote:
> Hello-
>
> So i have the commerce server and import wizard on one box and the sql
> server on another. I need to save the DTS packages and schedule them to run
> nightly. However, they only save locally and where I am running the DTS
> package, we have no sql box.
>
> What is the best way to import data into the datawarehouse database in this
> scenari. Run the import tool on my local dev environment saving the DTS
> packages. Then copy these packages to the production sql box and schedule
> them from there?
>
> Thanks
> Jordan
| |
| Brian Blum [MSFT] 2006-09-28, 1:28 am |
| The package should be saved on the SQL server that the DW is defined on,
which is the same server that it runs on when you choose run immediately.
If you're saving to a SQL 2005 box, you'll need the SQL 2000 DTS Designer
package installed on the SQL box before you can open the package.
This posting is provided "AS IS" with no warranties, and confers no rights.
EBuisness Server Team
--------------------
Thread-Topic: data warehouse import wizard
thread-index: AcbigxMMhafskQsiTC2+XV/n/EFKzA==
X-WBNR-Posting-Host: 12.144.130.7
From: =?Utf-8?B?am9yZGFu?= <jordan@discussions.microsoft.com>
References: <0FDF25A4-D153-4C84-844A-8B6AD3881CA7@microsoft.com>
Subject: RE: data warehouse import wizard
Date: Wed, 27 Sep 2006 15:20:01 -0700
Lines: 21
Message-ID: <56D76572-D898-47B5-81EF-E4DC7FFF2443@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.commerceserver.analysis
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:164
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.analysis
Correction. This "However, they only save locally and where I am running
the
DTS package, we have no sql box" should be - "However, they only save
locally
and where I am running the DW import wizard, we have no sql box.
Therefore,
we cannot save the DTS packages when we run the DW import wizard."
"jordan" wrote:
> Hello-
>
> So i have the commerce server and import wizard on one box and the sql
> server on another. I need to save the DTS packages and schedule them to
run
> nightly. However, they only save locally and where I am running the DTS
> package, we have no sql box.
>
> What is the best way to import data into the datawarehouse database in
this
> scenari. Run the import tool on my local dev environment saving the DTS
> packages. Then copy these packages to the production sql box and schedule
> them from there?
>
> Thanks
> Jordan
| |
| jordan 2006-09-28, 7:22 pm |
| Thanks. So then should I copy the DW Imort Wizard exe over to the SQL box and
run it from there? Because it sounds like run immediately and saving the
package only work with a machine that has a local sql server and this one
does not.
Would copying the DW import wizard exe over to the sql box work OR how else
would we import this data for reporting?
thanks for your time!
Jordan
"Brian Blum [MSFT]" wrote:
> The package should be saved on the SQL server that the DW is defined on,
> which is the same server that it runs on when you choose run immediately.
>
> If you're saving to a SQL 2005 box, you'll need the SQL 2000 DTS Designer
> package installed on the SQL box before you can open the package.
>
>
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> EBuisness Server Team
> --------------------
> Thread-Topic: data warehouse import wizard
> thread-index: AcbigxMMhafskQsiTC2+XV/n/EFKzA==
> X-WBNR-Posting-Host: 12.144.130.7
> From: =?Utf-8?B?am9yZGFu?= <jordan@discussions.microsoft.com>
> References: <0FDF25A4-D153-4C84-844A-8B6AD3881CA7@microsoft.com>
> Subject: RE: data warehouse import wizard
> Date: Wed, 27 Sep 2006 15:20:01 -0700
> Lines: 21
> Message-ID: <56D76572-D898-47B5-81EF-E4DC7FFF2443@microsoft.com>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="Utf-8"
> Content-Transfer-Encoding: 7bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Content-Class: urn:content-classes:message
> Importance: normal
> Priority: normal
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
> Newsgroups: microsoft.public.commerceserver.analysis
> Path: TK2MSFTNGXA01.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:164
> NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> X-Tomcat-NG: microsoft.public.commerceserver.analysis
>
> Correction. This "However, they only save locally and where I am running
> the
> DTS package, we have no sql box" should be - "However, they only save
> locally
> and where I am running the DW import wizard, we have no sql box.
> Therefore,
> we cannot save the DTS packages when we run the DW import wizard."
>
> "jordan" wrote:
>
> run
> this
>
| |
| Brian Blum [MSFT] 2006-09-28, 7:22 pm |
| You shouldn't have to copy the wizard. The wizard gets the connection
string to the SQL server from the Admin database.
When you run, the package is run on the SQL server machine. Are you seeing
it fail during the run? Are there any errors in the event log?
This posting is provided "AS IS" with no warranties, and confers no rights.
EBuisness Server Team
--------------------
Thread-Topic: data warehouse import wizard
thread-index: AcbjELrBOeVtw+uXSVyutFhqeNWb7Q==
X-WBNR-Posting-Host: 24.19.19.37
From: =?Utf-8?B?am9yZGFu?= <jordan@discussions.microsoft.com>
References: <0FDF25A4-D153-4C84-844A-8B6AD3881CA7@microsoft.com>
<56D76572-D898-47B5-81EF-E4DC7FFF2443@microsoft.com>
<IT#etXp4GHA.4344@TK2MSFTNGXA01.phx.gbl>
Subject: RE: data warehouse import wizard
Date: Thu, 28 Sep 2006 08:14:01 -0700
Lines: 76
Message-ID: <75C61573-B17A-4A1B-82E2-F6DAC494B33E@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.commerceserver.analysis
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:166
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.analysis
Thanks. So then should I copy the DW Imort Wizard exe over to the SQL box
and
run it from there? Because it sounds like run immediately and saving the
package only work with a machine that has a local sql server and this one
does not.
Would copying the DW import wizard exe over to the sql box work OR how else
would we import this data for reporting?
thanks for your time!
Jordan
"Brian Blum [MSFT]" wrote:
> The package should be saved on the SQL server that the DW is defined on,
> which is the same server that it runs on when you choose run immediately.
>
> If you're saving to a SQL 2005 box, you'll need the SQL 2000 DTS Designer
> package installed on the SQL box before you can open the package.
>
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> EBuisness Server Team
> --------------------
> Thread-Topic: data warehouse import wizard
> thread-index: AcbigxMMhafskQsiTC2+XV/n/EFKzA==
> X-WBNR-Posting-Host: 12.144.130.7
> From: =?Utf-8?B?am9yZGFu?= <jordan@discussions.microsoft.com>
> References: <0FDF25A4-D153-4C84-844A-8B6AD3881CA7@microsoft.com>
> Subject: RE: data warehouse import wizard
> Date: Wed, 27 Sep 2006 15:20:01 -0700
> Lines: 21
> Message-ID: <56D76572-D898-47B5-81EF-E4DC7FFF2443@microsoft.com>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="Utf-8"
> Content-Transfer-Encoding: 7bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Content-Class: urn:content-classes:message
> Importance: normal
> Priority: normal
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
> Newsgroups: microsoft.public.commerceserver.analysis
> Path: TK2MSFTNGXA01.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:164
> NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> X-Tomcat-NG: microsoft.public.commerceserver.analysis
>
> Correction. This "However, they only save locally and where I am running
> the
> DTS package, we have no sql box" should be - "However, they only save
> locally
> and where I am running the DW import wizard, we have no sql box.
> Therefore,
> we cannot save the DTS packages when we run the DW import wizard."
>
> "jordan" wrote:
>
to[vbcol=seagreen]
> run
> this
schedule[vbcol=seagreen]
>
| |
| Brian Blum [MSFT] 2006-09-29, 7:22 am |
| I had only tried this on a machine that already had SQL on the unpup
machine, which is not your scenario. I just tried your scenario and I see
the same issue. The code always tries to save the DTS package to the local
machine.
For your scenario, you'll need to install CS on the DW machine (to register
the DTS tasks) and configure it to point at the existing Admin db (rather
than create a new one). Then run the import wizard from the DW machine.
This posting is provided "AS IS" with no warranties, and confers no rights.
EBuisness Server Team
--------------------
X-Tomcat-ID: 352524258
References: <0FDF25A4-D153-4C84-844A-8B6AD3881CA7@microsoft.com>
<56D76572-D898-47B5-81EF-E4DC7FFF2443@microsoft.com>
<IT#etXp4GHA.4344@TK2MSFTNGXA01.phx.gbl>
<75C61573-B17A-4A1B-82E2-F6DAC494B33E@microsoft.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_NextPart_0001_3B949793"
Content-Transfer-Encoding: 7bit
From: brianbl@online.microsoft.com (Brian Blum [MSFT])
Organization: Microsoft
Date: Thu, 28 Sep 2006 16:06:51 GMT
Subject: RE: data warehouse import wizard
X-Tomcat-NG: microsoft.public.commerceserver.analysis
Message-ID: <6Oychgx4GHA.3352@TK2MSFTNGXA01.phx.gbl>
Newsgroups: microsoft.public.commerceserver.analysis
Lines: 239
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:167
NNTP-Posting-Host: TOMCATIMPORT1 10.201.218.122
You shouldn't have to copy the wizard. The wizard gets the connection
string to the SQL server from the Admin database.
When you run, the package is run on the SQL server machine. Are you seeing
it fail during the run? Are there any errors in the event log?
This posting is provided "AS IS" with no warranties, and confers no rights.
EBuisness Server Team
--------------------
Thread-Topic: data warehouse import wizard
thread-index: AcbjELrBOeVtw+uXSVyutFhqeNWb7Q==
X-WBNR-Posting-Host: 24.19.19.37
From: =?Utf-8?B?am9yZGFu?= <jordan@discussions.microsoft.com>
References: <0FDF25A4-D153-4C84-844A-8B6AD3881CA7@microsoft.com>
<56D76572-D898-47B5-81EF-E4DC7FFF2443@microsoft.com>
<IT#etXp4GHA.4344@TK2MSFTNGXA01.phx.gbl>
Subject: RE: data warehouse import wizard
Date: Thu, 28 Sep 2006 08:14:01 -0700
Lines: 76
Message-ID: <75C61573-B17A-4A1B-82E2-F6DAC494B33E@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
Newsgroups: microsoft.public.commerceserver.analysis
Path: TK2MSFTNGXA01.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:166
NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
X-Tomcat-NG: microsoft.public.commerceserver.analysis
Thanks. So then should I copy the DW Imort Wizard exe over to the SQL box
and
run it from there? Because it sounds like run immediately and saving the
package only work with a machine that has a local sql server and this one
does not.
Would copying the DW import wizard exe over to the sql box work OR how else
would we import this data for reporting?
thanks for your time!
Jordan
"Brian Blum [MSFT]" wrote:
> The package should be saved on the SQL server that the DW is defined on,
> which is the same server that it runs on when you choose run immediately.
>
> If you're saving to a SQL 2005 box, you'll need the SQL 2000 DTS Designer
> package installed on the SQL box before you can open the package.
>
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> EBuisness Server Team
> --------------------
> Thread-Topic: data warehouse import wizard
> thread-index: AcbigxMMhafskQsiTC2+XV/n/EFKzA==
> X-WBNR-Posting-Host: 12.144.130.7
> From: =?Utf-8?B?am9yZGFu?= <jordan@discussions.microsoft.com>
> References: <0FDF25A4-D153-4C84-844A-8B6AD3881CA7@microsoft.com>
> Subject: RE: data warehouse import wizard
> Date: Wed, 27 Sep 2006 15:20:01 -0700
> Lines: 21
> Message-ID: <56D76572-D898-47B5-81EF-E4DC7FFF2443@microsoft.com>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="Utf-8"
> Content-Transfer-Encoding: 7bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Content-Class: urn:content-classes:message
> Importance: normal
> Priority: normal
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
> Newsgroups: microsoft.public.commerceserver.analysis
> Path: TK2MSFTNGXA01.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:164
> NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> X-Tomcat-NG: microsoft.public.commerceserver.analysis
>
> Correction. This "However, they only save locally and where I am running
> the
> DTS package, we have no sql box" should be - "However, they only save
> locally
> and where I am running the DW import wizard, we have no sql box.
> Therefore,
> we cannot save the DTS packages when we run the DW import wizard."
>
> "jordan" wrote:
>
to[vbcol=seagreen]
> run
> this
schedule[vbcol=seagreen]
>
| |
| Willian Leite 2006-11-25, 1:28 am |
| Hi Brian,
I posted the same problem in the Alan Faulker Blog
(http://blogs.msdn.com/akfaulkner/ar...om-webcast.aspx).
By your answer I have to install de Commerce Server in the DW Machine,
right? But I'm working in a production environment and will be very dificult
to justify the instalation of CS on the SQL Server machine.
There are any workaround for this?
......
Original Post in Alan Faulkner's Blog :
Hi Alan,
I watched your webcast and I developed the Classes and Views for my Weekly
Typed Properties in my Purchase Orders(after do the
OrderObjectMappings.xml).
All this works fine in my Commerce Developer Environment (WebServer and SQL
Server in the same machine). Now I have to do this in an Enterprise Cenario.
The DTS Import Wizard fails in the start, showing this message : "Faild to
retrive DTS Task Information". In my cenario I have 2 WebServer
(ProductionServer and StagingServer) and two SQL Server 2K5 (Commerce
DataBase and DW/BI Database).
In the WebServer I dont have any SQL Server installed.
What I need to run the DTS Task in this environment?
.....
"Brian Blum [MSFT]" <brianbl@online.microsoft.com> wrote in message
news:LLhkLd14GHA.1860@TK2MSFTNGXA01.phx.gbl...
>I had only tried this on a machine that already had SQL on the unpup
> machine, which is not your scenario. I just tried your scenario and I see
> the same issue. The code always tries to save the DTS package to the
> local
> machine.
>
> For your scenario, you'll need to install CS on the DW machine (to
> register
> the DTS tasks) and configure it to point at the existing Admin db (rather
> than create a new one). Then run the import wizard from the DW machine.
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> EBuisness Server Team
> --------------------
> X-Tomcat-ID: 352524258
> References: <0FDF25A4-D153-4C84-844A-8B6AD3881CA7@microsoft.com>
> <56D76572-D898-47B5-81EF-E4DC7FFF2443@microsoft.com>
> <IT#etXp4GHA.4344@TK2MSFTNGXA01.phx.gbl>
> <75C61573-B17A-4A1B-82E2-F6DAC494B33E@microsoft.com>
> MIME-Version: 1.0
> Content-Type: multipart/alternative;
> boundary="----=_NextPart_0001_3B949793"
> Content-Transfer-Encoding: 7bit
> From: brianbl@online.microsoft.com (Brian Blum [MSFT])
> Organization: Microsoft
> Date: Thu, 28 Sep 2006 16:06:51 GMT
> Subject: RE: data warehouse import wizard
> X-Tomcat-NG: microsoft.public.commerceserver.analysis
> Message-ID: <6Oychgx4GHA.3352@TK2MSFTNGXA01.phx.gbl>
> Newsgroups: microsoft.public.commerceserver.analysis
> Lines: 239
> Path: TK2MSFTNGXA01.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:167
> NNTP-Posting-Host: TOMCATIMPORT1 10.201.218.122
>
> You shouldn't have to copy the wizard. The wizard gets the connection
> string to the SQL server from the Admin database.
>
> When you run, the package is run on the SQL server machine. Are you
> seeing
> it fail during the run? Are there any errors in the event log?
>
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
> EBuisness Server Team
> --------------------
> Thread-Topic: data warehouse import wizard
> thread-index: AcbjELrBOeVtw+uXSVyutFhqeNWb7Q==
> X-WBNR-Posting-Host: 24.19.19.37
> From: =?Utf-8?B?am9yZGFu?= <jordan@discussions.microsoft.com>
> References: <0FDF25A4-D153-4C84-844A-8B6AD3881CA7@microsoft.com>
> <56D76572-D898-47B5-81EF-E4DC7FFF2443@microsoft.com>
> <IT#etXp4GHA.4344@TK2MSFTNGXA01.phx.gbl>
> Subject: RE: data warehouse import wizard
> Date: Thu, 28 Sep 2006 08:14:01 -0700
> Lines: 76
> Message-ID: <75C61573-B17A-4A1B-82E2-F6DAC494B33E@microsoft.com>
> MIME-Version: 1.0
> Content-Type: text/plain;
> charset="Utf-8"
> Content-Transfer-Encoding: 7bit
> X-Newsreader: Microsoft CDO for Windows 2000
> Content-Class: urn:content-classes:message
> Importance: normal
> Priority: normal
> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
> Newsgroups: microsoft.public.commerceserver.analysis
> Path: TK2MSFTNGXA01.phx.gbl
> Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.analysis:166
> NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
> X-Tomcat-NG: microsoft.public.commerceserver.analysis
>
> Thanks. So then should I copy the DW Imort Wizard exe over to the SQL box
> and
> run it from there? Because it sounds like run immediately and saving the
> package only work with a machine that has a local sql server and this one
> does not.
>
> Would copying the DW import wizard exe over to the sql box work OR how
> else
> would we import this data for reporting?
>
> thanks for your time!
>
> Jordan
>
> "Brian Blum [MSFT]" wrote:
>
> rights.
> to
> schedule
>
>
>
|
|
|
|
|