Viewing 15 posts - 241 through 255 (of 669 total)
Have you considered using the System::PackageName variable.
This is a system variable and is ReadOnly.
November 23, 2010 at 3:48 am
Craig has answered you question completely. As a matter of design...create table --> Stage Data-->Data Transformations-->Truncate Table
November 16, 2010 at 5:42 am
You have to set appropriate cube security/browse properties..it has been long time though...but this is where you start exploring.
November 14, 2010 at 10:28 pm
Much hyped....all must have heard about BISM and the roadmap for SSAS and MDX
What happens next?
November 14, 2010 at 10:26 pm
Amazing things can happen from outside!!! Nice read though 🙂
November 11, 2010 at 6:47 am
This is one test case scenario...
There are also chances of pre assumptions by a certain lot of customers pre-assuming that since many stores have a definite store arrangement they may...
November 11, 2010 at 6:22 am
On the other hand, if you are happy to slip someone $50 via Paypal to write that script for you, we're in happier territory and I'm sure that you will...
November 9, 2010 at 12:39 am
sankarkot2007 (11/6/2010)
Hello Da-Zerodon't post these type of suggestions,ok.I learn beggener stage Thats why i want some questions
You are doing no good to the community by asking some set of...
November 9, 2010 at 12:22 am
Chris,
A design involving no Script Task/Component would be a bad idea considering the scenario you have in hand. Though it might be possible!!!
November 9, 2010 at 12:17 am
Phil Parkin (11/2/2010)
You are using a lot of guesswork here.
Somehow, I don't think so. 🙂
November 2, 2010 at 5:08 am
Think Big...Think Windows Service that will poll a directory implementing Windows Management Instrumentation Events..lol...
Yes Phil FEL can be used but the ST has to invlove a suitable code for threading...
November 2, 2010 at 4:52 am
Phil Parkin (11/2/2010)
Pulivarthi Sasidhar (11/2/2010)
Hi,Use Script Task go to design script
U can write C# or VB Script for the same
Cheers!
Sasidhar Pulivarthi
What does this give the OP that Steveb's post...
November 2, 2010 at 4:38 am
One of the suitable approach would be to watch the said directory using a FileSystemWatcher and fire appropriate events as associated. This seems doable as the system does not deems...
November 2, 2010 at 4:06 am
Adiga (11/2/2010)
You may find xp_fileexists extended stored procedure useful. More information on this XP here
The OP says, file name not known
November 2, 2010 at 4:02 am
Viewing 15 posts - 241 through 255 (of 669 total)