you could use the FORMAT command in an expression on the field

FORMAT(Fields!DateField.Value, "dd-MMM-yy")

Thanks Phil, I will add a comment once I have done my morning checks.

Its a possibility but its extracted from SalesForce using ApexDataLoader and I have yet to find a way to change it from comma delimited to something else, but will keep...

Howard, the flat file source does have " as the text qualifier its just that one column which it wont remove the " from. Also thanks for the...

deebabat (4/20/2012)

---

MarkusB (4/20/2012)

---

deebabat (4/19/2012)

---

BEGIN CATCH

insert into tblDownload_Import

(Description) values ('error: ' + ERROR_Number() + ' msg: ' + ...

do you or the agent account have the correct Windows Server access rights to query WMI data

anthony.green (4/20/2012)

---

SkyBox (4/20/2012)

---

anthony.green (4/20/2012)

---

SkyBox (4/19/2012)

---

One of our systems (AX 2009) doesn't allow "included columns" on indexes, so with that in mind, I want be sure that those indexes aren't covering...

SkyBox (4/20/2012)

---

anthony.green (4/20/2012)

---

SkyBox (4/19/2012)

---

One of our systems (AX 2009) doesn't allow "included columns" on indexes, so with that in mind, I want be sure that those indexes aren't covering too...

from what I remember 0x80041003 is an insufficient permissions error, cant remember if its insufficient at the agent level to run the alert or to your account creating the alert.

one...

Thats...

one way would be to wrap the size in a case statement then group by the case statement again

select

.......,

case when size >=1 <=10 then 1

else when size >=11 <=20 then...

yes, you will need to add in a map report object for it to display the Geo data, unsure if any other report object can display Geo data as its...

try this link,also look at transfer login task in SSIS, manually scripting from the master database wrapped in with the create login commands you need.

unsure if this works on SQLExpress but you could start SQL in single user mode and as long as your an administrator of the actual workstation you will get SA...

not that I can tell as there is a DDL trigger which fires for all ddl events using the root DDL_EVENTS but unsure if restore /attach/detach come under the DDL_SERVER_LEVEL_EVENTS...