I figure it out.

using below expression:

=iif((fields!db_owner.Value) =1 and fields!db_owner.Value = sum(fields!db_owner.Value),"Pink","White")

hmm.. the point is I don't see any hyperlink in your post can you send it again? thanks

try what?

@Phil Parkin

I am using M:\Products & Services\Business Planning & Analysis\ProjectOzRawDataFile_DoNotDelete_Atif\RawData\SAPARawData_PatBell in my package not UNC path I guess so if I have to use UNC path I have to provide...

And I saw some people had same issue with job agent and they solved problem by making folder as shared folder. But the point is my folder is in the...

in my command line : /SQL "\"\Driver\"" /SERVER 1k53rw1 /X86 /CHECKPOINTING OFF /REPORTING E

everyone has access permission on that folder and if I create a job then will use my account credential to run that job anyway I guess. And like I said...

I already fix the problem thank you for your help.

1 more question here.

I'm trying to schedule my SSIS package and already deployed my as package deployment model into SQL.

after I...

I have a script task in my SSIS package and count file numbers in the folder but always return mecount = 1 even if there is no file placed and...

if we can not delete this file then Im gonna write a script to get the excel filename only start with "INV"

I using this code based on your suggestion. But always give me file is open error.

public void Main()

{

...

thanks for your apply!

Can you provide the code for IsFileLocked functioin ?

I have one script task at top of the package to check if there are any excel file exist in two different folders . If no file exist i will...

I using below code to check if the excel file is opened or not

public void Main()

{

Boolean mFileLocked = true;

while (mFileLocked)

...

Thank you Alvin.

Create one job with 3 schedules, one for each day -Complete

For error handling I know it's regarding SSIS package not sql job agent.

I appreciate If you can provide...