I was looking at doing this. But the best way I could come up with was using fn_get_audit_file to get the file expressed as a table. I would...

You could capure a failure of the filesystem task by adding an Exec SQL Task and connecting it to the filesystem task and changing the precedence to failure.

The only problem...

Thanks. Let me know how it works out for you..

CEWII

Ok, I have a better idea..

Every script task is effectively its own "class" there shouldn't be any issue with each having its own ScriptMain..

So I don't think that is your...

I don't really understand what you have asked.. Sorry..

I have another question. Is the source data and destination location on the same server?

See the image to see what...

Since it is in a data-flow component the answser is yes. what happens is the data-source fills the pipeline in the order specified by F3. And that pipeline is...

I can't think of a way for that component to do that. If the file extension is wrong it will generate zero files, this could also happen if there...

Hmm..

Maybe stop and restart the agent?

Because the steps you showed sound right..

CEWII

It is stored in msdb..

CEWII

Joseph,

I'm sorry, I'm having trouble visualizing what you are describing. Could you post a screen print of the package? I think that will be enough..

CEWII

Thanks Phil.

CEWII

You are welcome. And I will keep that in mind. I didn't think I was trying to shut anyone down.

I think what you want to do can be...

I'm sorry if that came off as criticism, it was not intended as such. That is what BOL says and the code provided is probably 95% of what you...

Profiles are login specific.

I'm willing to bet that the profile was not created while logged into the box AS the user that the SQL Server AND SQL Agent use.

Also, if...

Open SQL Configuration Manager

Choose SQL Server Services

Right-Click on the SQL Server and click on Properties.

Go to the FILESTREAM tab..

Set your options, click ok..

Probably have to restart SQL for them to...