When you build the SSIS package for deployment, you create a set of files in a deployment directory for the project, usually bin/deployment. In this directory is a manifest...

Just to be sure, when deploying your package to the production servr, did you run the Package Installation wizard by double clicking on the manifest file?

How did you accomplish the deployment to your production system?  Did you go through the build process in VS 2005?

😎

Actually, Matt, I was agreeing with you on your comment.

Just giving to OP what was requested.  I'd prefer this for the percentage column:

cast((Total/GrandTotal) * 100 as decimal(5,2)) as Percent

😎

Try this:

;with TotalAmt (

    GrandTotal

) as (

select

    sum(Total)

from

    dbo.yourView

)

select

    RegionDesc,

    MATotal,

    PartsTotal,

    DemandTotal,

    Total,

    cast(( GrandTotal/ Total) as decimal(5,2)) as Percent

from

    dbo.yourView

    cross join TotalAmt

😎

Could you be more specific?  Please show us how this calculation should be done using the data you provided in your original post.

😎

Is the servername correct in your example using an UNC?  I just tried it on one of my servers and it works fine going down several directories.

Without seeing the code for the stored procedure, it is a guess.  It could be parameter sniffing at work.  Are you using the variables declared in the header of the...

Is the schedule still enabled?  it almost sounds like the schedule had an end date set so that it would not run after a specified date.

😎

Try this:

SELECT

    t.schoolc as School_Code,

    RTRIM(k.schname) as School,

    s.ident as Ident,

    RTRIM(s.lastname) + ', ' + RTRIM(s.firstname) AS Student,

    ss.graden as [Current Grade],

    left(sb.descript,20) as Subject,

    max(sc.testscore) as Score

FROM...

I use a Script Task to format the date for creating an archive subdirectory using a datestamp.  You can use the same mechanism to format the datetime stamp for...

Perhaps you'd like to explain the lack of large pices in the crash of flight 585 (hope I have the right flight number) that crashed in park less than 2...

As I said, go on believing what you want, based on everything I have seen and read, I don't believe anything that you have espoused is true.

Johan,

Go on believing what you want.  I have seen and read enough to know what you are espousing is untrue.