Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Commerce Server Dataware Housing > Profile Data Im...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 1 Topic 158 of 184
Post > Topic >>

Profile Data Im****t Task

by rayeesur@[EMAIL PROTECTED] (csstarter) Dec 15, 2005 at 07:42 PM

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
 




 1 Posts in Topic:
Profile Data Import Task
rayeesur@[EMAIL PROTECTED  2005-12-15 19:42:46 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 17:19:07 CST 2008.