Posted by AMAN on 05/30/06 07:56

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

• Next in forum: 2005: SIMPLE QUESTION: error log
• Prev in forum: Re: Help Needed
• Thread view: need help in SSIS ETL development

[Reply to this message]