I have not worked with Sharepoint 2003, but I have extensively worked with Sharepoint 2007.

What I did is I used OLE DB source with some properties change in it which...

I am not sure if the Excel source will work fine for Excel 2007. It surely worked well with Excel 2003, but when I tried using it with Excel 2007....

Error in the progress tab is:

Error: Error 0xC0012050 while loading package file "C:\Path\Package1.dtsx". Package failed validation from the ExecutePackage task. The package cannot run. .

I am trying to use 3 Execute Package Tasks independently in a new master package, but I am getting an error in two tasks.

When I run those packages individually,...

Thank you Greg. I am trying to implement your suggestion. Sounds good to me.

Thanks once again.

This is just to let you know that we are now able to get rid of that error message.

We changed the share point path of the files that were not...

Hello,

Thank you for your replies. I will check and let you know if it works.

- notes4we

Thank you Prachi. It worked fine.

Hi,

I found out the problem.

We need to leave the To and From field blank, but set the DelayValidation to True, not False.

When I set it to True, then I was...

Hi,

Thank you for your reply. I kept the To and From blank and the DelayValidation is already set to false, but I am still getting an error that No...

Mukti,

Thanks a lot for your reply. I like this way, but if there are 4 errors, then I am getting 4 error emails.

Can you please help me find a way...

Thank you. I found syntax little more simpler:

CONVERT(varchar(5), dbo.Table1.Column1,8) AS HoursUpdation

Thank you once again for your response too.

Thank you Jerry. I am using SQL Server 2005 and I uesd this:

SELECT CONVERT(varchar(8),CreationTime,108)

FROM Table1

It is working fine.

Thank you.

I do not know what the actual problem was, but now I am getting error messages also.

So, if the package fails, I get an email stating that it has failed.

Hello Frank,

Thank you for your detailed explanation.

I am planning to use VBA for achieving this.

I would like to use a method where I do not have to move to...