Hey,

No, I was not able to get the value to display when I used the none agrregate method, I solved this by making changes to the views that I...

Ok Cool , Thanks so I add the primary key and setup a relationship to each dim table ?

Cool Thanks

Hello Again,

I Found the error in my ways, in the Derived Column the lenght for the user variable was set to '0' (this is I guess since it does...

Hey there,

Thanks for the help, it didn't do exactly what i wanted, but I can see how I should now build my views a little diffrently, and once that...

Hello,

Thanks for the help, I have been trying to implement what you suggested but have not been able to get any results, or even affect the sort order

I select...

Excellent, Thanks I will try that out this weekend , let you all know thansk again

hi there,

in the beginning no i was not using a ADO enumerator, I was using a variable - that might have been another way to do it I think....

SOLUTION:

Hello, Here is the solution I found to my problem:

For doing a task like sending html mail (built using a SQL script and a Script Task) the for each...

True, I see what you mean - I get a result the resutl is null but I assume that the foere each loop still sees it as a row, will...

Hi Jeff,

you are right, sorry for the very limited details. I have made the following changes to the process, and made the following progress

Script number 1 executes and...

Hello

I have found the reason why I was getting errors. I had been able to get the for each loop workong on normal flat file so i assumed that the...

i am using the Connection String from the drop down then set it to the variable

as far as the variable goes (the one that contains the file name) I...

Hello

i jsut read the post above and have been trying to get the foreach loop working, but i am having the following issue and i hope you can point...

Thanks for the help so far,

i have not used variables before in the SSIS packages before, so this is what I have done (after going through a few other...

Hello

Thanks for the link, the controlflow can let me monitor the folder, and as far as I can tell returns the name of the file for later use, how...