Is it getting backed up, i.e are you doing transaction log and DB backups?

Is Q: on another server. It looks like the agent may not have access. I always run the Agent service (and the SQL service) as a Windows domain account that...

Is the insert from a select? If so it could be the select data being in memory.

I would create a weeks table containing all the weeks you want to report on then use that with a LEFT OUTER JOIN onto your results where there are NULL...

Hi Mark,

To get started open a new project in BIDS.

Add a data flow component to the package.

Double click the component and the data flow page opens.

Add an OLEDB data...

Thanks Vishal - I shall.

Well thanks!

Interesting views here and interestingly not a clear consensus. I had imagined I would just get 'go with plan A' , 'agree plan A', 'definitely plan A but watch...

Doh!

Thanks Max

Thanks Steve. The XML Workshop series look like a nice gentle way in.

Let me think on it, it's not a straight no.

Hi (pritesh I think) thanks very much - worked a treat.

Thanks PD - I'm not up to the chapter on Configurations yet...

Yes _some_ properties seem to allow direct setting from a variable.

E.G on the Send Mail Task the MessageSource property can come from

Variable, Direct Input or File Connection depending on...

Hi PD,

Thanks for your help. I think I now understand that _some_ properties can come directly from a variable. But that all properties for a task can come from an...

Doh. I dont think it can be done. I think only some properties can come from variables.

Anybody know of a workaround? Possibly using the DTS object??

Allen