468,107 Members | 1,325 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,107 developers. It's quick & easy.

need help in SSIS ETL development

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

May 30 '06 #1
0 1529

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Rodrigo Bellusci | last post: by
1 post views Thread by Eric | last post: by
reply views Thread by hoots | last post: by
9 posts views Thread by gelangov | last post: by
reply views Thread by Mike Martin | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.