> Hi all,
>
> I am a newbie to SSIS.Need a solution to couple of issues I am
> currently facing while developing ETL in SSIS
>
> 1) Under SSIS Package Folder I have defined mappings for 17
> dimensions.
> 1st Dimension say Account has been Set up as a startup object.
> Now when I run the package ir runs only my account dimension and loads
> the target,other dimensions are not run at all!
> Arent the other dimensions run in the order present in SSIS Package
> Folder? If not how are they to be connected with each other?
>
> 2) Second issue is of passing parameters in an Execute SQL task.
> I have defined 3 variables with the scope of Package Level.
> 3 parameters have been mapped to these 3 variables. Parameters are a
> part of the SQL,but are not getting parsed.
> I need to pass them somehow? Can anyone suggest how?
> Please give your inputs SSIS gurus.
>
> Thanks in advance.
>
> Regards,
>
> Aman Anand
>