Hello Experts,
I am using Commerce Server Standard Edition 2002+ FP1.
I am trying to im****t the data into Datawarehouse and I dont have the
Profile Data Im****t Task listed in the SQL when I am trying to create
the package for data im****t.
I understand with Standard Edition I dont get Profile Data Im****t Task
but how do I Im****t data into the data ware house as all the
do***entation I find to perform this has Profile Data Im****t Task
listed in hereit.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/csvr2002/htm/cs_mmc_2datawarehouse_dayx.asp
I read abt Scripting the Profile Data Im****t DTS Task but when I try
to run this script I get Invalid Class String error on Set oTask =
oPackage.Tasks.New("CS_UpmDtsTask.DTSUPMCustomTask")
Is there a way for me to im****t the data into the datawarehouse
without this task.
I tried to run this package with this workflow and it failed
Web Server Log Im****t->Configuration Synch->Product Catalog
Im****t->Transaction Data Im****t->Re****t Preparation
Secondly, this whole things started as I was trying to view a dynamic
re****t from one of the client machine.
When I open the bixdesk on the server and view the re****t ,re****t
looks great but when I have the client open the re****t from their
machine thru biz desk they get a blank screen.I read from knowledge
base articles that this happens when there is no data in the
datawarehouse and dynamic re****ts across the domain are accessed thru
OLAP, so I tried to im****t data in the datawarehouse.
Also when I try to login on BizDesk on Client machine and try to
create a re****t it says I do nto ahve permissions to Create Re****ts,
I check my permissions Iam and ADMIN on the server and added to
Administrators group...I can update the product catalog from his
machine but cannot create a re****t. arghhhhhh
I just need to have the client view this re****t ASAP...
Appreciate your help in advance...
Regards....
heres the script I was trying to use to create the task
'*********************************************************************
' Profile Data Im****t DTS Task
' This script creates a DTS package and runs it.
'**********************************************************************
Dim oPackage
Dim oTask
Dim oStep
Dim oProps
Dim oTaskProps
set oPackage = WScript.CreateOBject("DTS.Package")
'******************************************************************
' Define package properties.
'******************************************************************
oPackage.Name = "Profile Data Im****t DTS Task"
oPackage.Description = "Im****ts user profile data into the Data
Warehouse."
'******************************************************************
' Create a task.
'******************************************************************
Set oTask = oPackage.Tasks.New("CS_UpmDtsTask.DTSUPMCustomTask")
oTask.Name = "Task1"
oTask.Description = "Creates a task for ProfileDataIm****t DTS"
Set oTaskProps = oTask.Properties
'*******************************************************************
' Set DTS task properties.
'*******************************************************************
oTaskProps("SourceType").value = 1
' Make sure SourceName is set to the correct Data Warehouse name.
oTaskProps("SourceName").value = "Data Warehouse 1"
oTaskProps("DTSTaskIm****tStartDate").value = #01/01/2002# 'Put the
proper date here
oTaskProps("NumRetries").value = 3
oTaskProps("RetryInterval").value = 30
oTaskProps("DTSTaskTimeQuantum").value = 15
oTaskProps("ProcessingType").value = 100
oPackage.Tasks.Add oTask
'******************************************************************
' Create a step.
'******************************************************************
Set oStep = oPackage.Steps.New
oStep.Name = "Step1"
oStep.TaskName = "Task1"
'For custom tasks written in Visual Basic, the steps cannot run on a
' secondary thread.
oStep.ExecuteInMainThread = True
oPackage.Steps.Add oStep
' ******************************************************************
' Execute the package.
' ******************************************************************
oPackage.Execute
For I = 1 To oPackage.Steps.Count
If oPackage.Steps(I).ExecutionResult = 1 Then
iStatus = False
MsgBox oPackage.Steps(I).Name + " in the " + _
oPackage.Name + " failed."
End If
Next
MsgBox oPackage.Name + " Done"
Set oStep = Nothing
Set oTaskProps = Nothing
Set oProps = Nothing
Set oTaskProps = Nothing
Set oPackage = Nothing