I am sorry ssis learner..But, I didn't understand how Ican achieve this by sort transformation

The only solution I have found till now is this

I am sending this data to a temp table instead of sending it to a Destination table and then I have...

Thanks Baskar. It worked.

Thanks for ur reply mostinteresting man(dos equis)....:-)

what do you mean by manually setting the "remove agent history" if it is a relatime update( u r rite it is for...

THANKS........

I have tried with 100000 total rows and 10000 rows for each job and selected the keep history option and changed to 52 weeks. But, once I click Ok and...

I dont have a 2005 sql server for developing. Is there any other way to solve this problem

I have modified the pckconf file by changing the values of variables for example by changing sales.csv to sales1.csv. And I renamed the file as diffpckconf.dtsconfig

I have created another...

I searched a little and there is an option in steps tab of job scheduling that overrides the design values of variables...IS that the solution?

please help me out with this problem..

I have tried that Dave with string in package variable and parameter mapping and as varchar in sql statement.

But I get the same error..I wonder what went wrong..

I am not using any result set here. That option is set to none for my execute sql task. And I am just assigning a value to a variable in...

I am facing with the same problem...And I think we cannot do this dynamically...Can someone please confiem this..

thanks steve....