I think it cannot be that much simple...since

In the SSIS DB Catalog, i have configured the Environment variable which contains three parameters to the Project which got deployed .

This projects...

,,,,,,,,,,,,

Hi Phil,

I need info on the Deployment side..

I have built my package and and deployed the package to the SSISDB Catalog..

My project is something like......

Yes I agree !! For Oracle I am getting the Full Connection String and for the SQL DBs i am getting only ServerName property of those connection Managers ..:-)

Thanks bro.....

Are Connection Strings rather different than Connection Managers ? I dont know that !!!

I am using the Project Connection Managers and i have parameterize them (Made them as Parameters)...

Yes , I agree. So how i have tried the solution currently is that I have defined the

1. Oracle source connection string as a Parameter_1

2. Stg Source only ServerName...

Hi , I should not use ?

I have tried the other method as Deployed my project in the SSIS catalog and then created a Environment variable in...

Hi ,

Thanks for the suggestions. I have achieve it somehow you can say by creating a function which just gives me a bit as the output...

Then i hope this should work out !!!

Thanks and Hats off PB_BI for your commitment !!!:-)

Yes , thats correct , but what if i have got the required columns in the main fact too which i need to use them in my reporting with the...

Hi Vineet,

Not quitely , since the Fact we have...

PB_BI (9/26/2014)

---

So you just need a count of the occupied rooms over the course of months, quarters and years?

I still don't think you need to distinctly count anything. Why not...

I agree to this, normally when we built a Dimensional modelling then automatically through slicing and dicing we will get the required data o/p based upon their hierarchy levels..

Consider No....

Hmm...As we have built everything in one Fact , we got this duplicate value issue and we cant go back at our current scenario and i have checked the link...

Our Fact is having many records and even the duplicates of it too.. so if i consider counting distinct on day basis which is correct but if i consider the...