oh...well that might make a difference then! lol

Michael Weiss

If it were me, I would take a look at changing the design. If you think about it, being a male has nothing to do with being Australian...any more than...

What version of SQL Server are you running? Also, what is the latest service pack installed? Lastly, if you execute the last task in the package manually by right clicking...

I would get rid of the quotes around your column name aliases...the only thing that should be quoted to my knowledge is the comma being concatenated into the firstname/lastname field...and...

Did you try unchecking the chinese language selection and then doing the install?

Michael Weiss

Hi Steve!

Hey, check out this link (watch for wrap as always!)

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag01/html/DTS2000inAction.asp

There is a paragraph or two on using the Inner Globabl Variables and Outer Global Variables in an Execute Package...

I never have...much prefer to do my lookups via a sproc executed in an Execute SQL task. I do think DTS Lookups have too much overhead in them...but it would...

In the workflow properties for your cube processing task, is the "Execute On Main Thread" option checked? Doese the task work fine when you execute it directly from within the...

Try searching at http://www.msdn.microsoft.com for "file system object"...also might try running the same search on Google. Also maybe try searching this site for 'binary file'. There is lots of good...

One way would certainly be to save them out as VB files and search the code in those files...

hth,

Michael

Michael Weiss

Have you tried to create a linked server? I have never done this so I am not sure if you can select a different data source connection for the dimensions...

Take a look in SQL Server Books Online (BOL) and search for Data Types. As far as I know, Analysis Services can use any data type [that SQL Server uses]...

Have you checked the FoxPro documentation to see what character is used as a parameter marker and then try it with that character instead of a question mark? Just an...

Hi Ignacio,

Are you running SP3 on SQL Server 2000? How about the OS? Win2k Server? What service pack are you running on the OS? Have you applied any other updates...

oops...let me correct that piece of code...it should be:

Dim objfso

Set objfso = CreateObject("Scripting.FileSystemObject")

If objfso.FileExists(("\\myserver\myfiles\myfile.txt")

) Then

objfso.copyfile "\\myserver\myfiles\myfile.txt", "\\myserver\myfiles\newfilename.txt"

'CopyFile method will leave the original file intact...if you want to delete it, uncomment...