Some queries regarding SSIS ETL Development

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

.

Relevant Pages

  • need help in SSIS ETL development
    ... Under SSIS Package Folder I have defined mappings for 17 dimensions. ... Now when I run the package ir runs only my account dimension and loads ...
    (comp.databases.ms-sqlserver)
  • Re: Error While Processing CUBE through SSIS Package.
    ... Pain Started when we try to do the same thing Through a SSIS Package. ... Some of the Dimensions are created from Views(Which return data from ... Linked Server). ... changing Object Ownerships etc... ...
    (microsoft.public.sqlserver.olap)