Hi

Could it be that the destination task is aggregating your records?

I noticed today that my data flow contained a flag column that along with other columns made the record unique.

I...

Hi Fal

Thanks for the advice.

I exported to a workbook with all cells set to text and all the dates displayed as text.

I also exported the the results to csv and...

the sql references a table with years that are to be collected, for pre 2008 i used less than 2008 and whatever was in the table. So if year in...

Thanks for your help Alvin, I've made some changes to the sql to accommodate this.

i disabled it when i was trying to figure out what was going wrong. The problem seems to be when it gets to the task with 2 precedence constraints coming...

Hi Alvin

Thanks for the reply.It appears that is the case. What's the best way to steer the control flow to do one of 2 tasks based on a variable value?

Can anybody else come up with some ideas that might help?

I have attached a screen shot of it

Yes, the package works fine without the constraint and expression

Hi

I have just opened up the list of assemblies in the assembly cache for .net 2 and it is listed as type GAC.

Yes, this is where it does not appear in the list although the DLL is in the same directory as all the other data flow items.

Thanks for the advice Tom, I'll give it a shot in the next couple of days.

Yes i get a message saying that the machine has successfully authenticated

Thanks, i found a solution that works well:

C:\WINDOWS\system32\rundll32.exe keymgr.dll, KRShowKeyMgr

Then you can add a new server to the cached credentials - e.g. click Add then

Server box: name of server e.g....

Thanks for the reply

I'll have them set up the table i think as anything outside of the norm will send IT into a spin.