you are the very best !!! thank you...

I was doing the same with 2 tables but using multiple updates for either full 60 minutes or partial minutes (the end time...

Installing .NET 3.5 and restarting SQL service worked ...

Also, this might be helpful in the future or for different issue
http://dbatasks.blogspot.com/2012/11/troubleshooting-database-mail-part-ii.html

Not sure what the SSIS is doing inside, But many times people forget that if there are other OLEDB conenctions and and you are accessing other server and databasese then...

Rakhi,

I don't know exactly ur issue and even fix it. But In my case it worked, but then after doing actual test, this was really slow compared to other what...

first don't leave the value empty. becoz pkg will fail to validate if u leave empty. put anyvalue, becoz this value is changed during the execution.

Second why string? if...

Try as I said above. yeha I alwsys found issue with this.

SO what I do is always alias the column name .....Now Upper and lower case also makes difference...

Here do...

Thanks Guys.....

@john-2, I cannot do in one shot. I know where u coming from. But its just too much logic to handle and lots of data. I am...

John is right. Bring the @enddate as column in pipeline and use it on column mappings of OLEDB command and map it to parameter and use JOHN command in ur...

Don't worry Lynn.....i don't think I will ever work for u ....................Anyway it was nice knowing that there could be several reasons that building SSIS packgaes at local machine might...

Yes.....you are right, if he already have installed SQL 2008, then there is no need for new liscense for SSIS. SSIS comes with SQL.

I think the main concern for him...

CriquedeSQL... I think you missunderstood the question above. I think he is saying that he installed SQL 2008 and SSIS on one server (let it be a DEV box). Then...

thanks COzyRoc...yeha I got the message. ..It was a one time thing for me, since they have not saved any datafile from previous load before I came to this project....

CozyRoc.........

Is there any example SSIS that uses this DataFlow Task Plus........I am finding little hard to configure this task. .......

Thanks....I downloaded it.......

I will let you know once I use it on my SSIS or if there is more info i need on it..........

Cozy...How do you I download this task - Data Floe Task Plus?..

Here is waht I am trying to do..

We have 108 Sql history tables where data were stored for each...