Here's a great article on how to format dates in SSRS:

Formatting Dates[/url]

jplankenhorn (8/28/2013)

---

Koen Verbeeck (8/28/2013)

---

Why ADO.NET for a SQL Server Destination? I normally use OLE DB Destination with Fast Load option.

Is the destination database in simple recovery model?

Are the database files...

JLMayes (8/28/2013)

---

You know who...

What's the error?

At first sight nothing is wrong with the expression.

http://www.sql-server-performance.com/forum/threads/how-to-get-startup-parameter.12680/

Why ADO.NET for a SQL Server Destination? I normally use OLE DB Destination with Fast Load option.

Is the destination database in simple recovery model?

Are the database files correctly sized?

Any transformations...

craig.schlieve (8/28/2013)

---

Ahh then I see my morning caffeine kick hadn't kicked in and I misread. I apologize in that case. My statement that this needs to be an...

craig.schlieve (8/28/2013)

---

Steve,

I am incredibly disappointed in you. This article is disgusting. You are advocating that groups form that will cause fractures in the community to do the...

Can you try with a proxy (just to make sure)?

Another cause might be if the user you created in the SSISConfigs DB is not correctly mapped to the domain account.

I know which woman the editorial is talking about, and the sad/stunning part is she probably knows SQL Server 100 times better than the UG leader.

As the old Belgian song...

Can you post the entire error?

Easy one, thanks.

Here's a quite lengthy article:

Your First OLAP Report[/url]

Somewhere at the end, it is explained how you can realize your request.

Do you use a proxy in the SQL job to specify the user MyDomain\SSISAccount?

Another options is to prompt the user to enter credentials when the report is ran.