Lutz, Jamie, Gah thanks for the info you provided. I did look into a pivot solution but it doesnt solve the problem.

Below is a better example definition and what...

Thanks a million.

- cos_ta393

Thanks for all your help but I figure out there issue and it had to do with IIS. Im back in business after resetting IIS.

Thanks

thetodaisies,

Thanks for your response however this is on a local dev machine and the machine name hasnt changed. Also I've try connecting with the IP address and localhost but same...

Applied Microsoft SQL Server 2008 Reporting Services was a very useful book for me and you can get more info at the link below.

http://www.prologika.com/Books/0976635313/Book.aspx

Teo Lachev, the author, is an...

I figured it out.

Thanks for pointing me in the right direction.

cos_ta

Lutz,

How do I get to the 2000 forum and how do I get the site admin to move my thread?

Thanks

bitbucket -

Thanks a million for these links they are really helpful. I however figured out what my issue was. I found out from the DBA that my excel file is...

I am using Excel 2003.

Thanks Lynn that did the trick.

Excellent post Ol'SureHand!!!

The DTS transform data task sql query connection option allows joins from heterogeneous sources but I agree that you may need to post additional information about what...

Greg,

Thanks a million. The info from the thread helped me resolve my issue. It was the USE command in had in my scripts.

Francis

A good place to start is with the BOL tutorial. The following links below should also help you out.

http://msdn.microsoft.com/en-us/library/ms169917.aspx

http://www.microsoft.com/sqlserver/2005/en/us/integration-services.aspx

- Costa

Do you have the "CheckpointUsage" property set? From your example you will need to set "CheckpointUsage" to "IfExists", which causes the package to run from the beginning if the CheckpointFile...

Parallel execution obviously improves performance on multiple processors but I am not sure what the required number of tasks to processor is, if any. However if you are designing a...