Viewing 15 posts - 256 through 270 (of 270 total)
There are two activex tasks in the package...but these are set to execute on the main package thread as they should and they run fine...any other ideas on what I...
July 17, 2002 at 10:05 am
You want to do something like this:
Set objPackage = CreateObject("DTS.Package")
objPackage.LoadFromSQLServer "Morpheus","","","256",,,,"mypackage"
Set objExecSQLPackage1 = CreateObject("DTS.Package")
objExecSQLPackage1.LoadFromSQLServer "Morpheus","","","256",,,,"myotherpackage"
If foo = 0 Then
objExecSQLPackage1.Execute
Else
objPackage.Execute
End If
Hope this helps!
Michael
quote:
2...
July 16, 2002 at 8:11 am
Sorry...should have added that you will need to modify this code to do what you want...
quote:
Using an ActiveX task...set up variables to...
July 11, 2002 at 7:00 pm
Using an ActiveX task...set up variables to reference each task object (a and b) and then set your package b global variable equal to package a global variable inside your...
July 11, 2002 at 6:59 pm
It is my understanding that they execute on the server...if anyone else can verify or refute this, I would like to know what the correct answer is...
Michael
Michael Weiss
July 11, 2002 at 6:17 pm
yes, you can use the filesystemobject's filexists property to check for the file and if it is there, then run your dts job via an activex script object...call this package...
July 11, 2002 at 6:13 pm
Sure you can...I do it and it works slick...
'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************
Function Main()
Dim responsesuccess
responsesuccess = 0
responsesuccess = ImportFile(DTSGlobalVariables("gvfilepath").Value)
If responsesuccess <> 0 Then
Main = DTSTaskExecResult_Success
Else
Main = DTSTaskExecResult_Failure
End...
July 9, 2002 at 6:27 pm
I really dont have a clue here, Jennifer...but is there a chance the connection is timing out? I would think you would receive a time out error message though...
Sorry cant...
July 9, 2002 at 6:15 pm
I would use Distinct myself...
quote:
I have a keyword search against a table that has around 10000 records. Many( about 2000) are duplicated...
July 9, 2002 at 4:51 pm
Have you processed your dimensions? And your shared dimensions? If not, you will get errors as the AS engine will not know where the foreign key values are for the...
July 9, 2002 at 4:34 pm
I ran the query (that anlaysis services was attempting to run for processing a dimension) in QA and it runs fine...I still think it is a permissions issue on the...
June 25, 2002 at 8:54 am
Thank you, Jay...I will try that and let you know what I come up with...I do know that the process is hanging on counting the members of whatever dimension I...
June 25, 2002 at 8:04 am
I would be interested in the position description even if it has been filled...am curious to see the detailed requirements for a two week gig...
Thank you,
Michael
June 20, 2002 at 1:24 pm
It is my understanding that incremental processing does not reflect changes to existing members unless those members are included in the where clause for the incremental processing. Full processing does...
June 20, 2002 at 12:44 pm
It is my understanding that you would need to do a full process when the underlying structure of the cube or dimension changes, ie adding new fields, deleting fields, etc....
June 20, 2002 at 11:25 am
Viewing 15 posts - 256 through 270 (of 270 total)