KoldCoffee (7/6/2014)

---

The last task following all execute process tasks is a Send Mail task. So, back to matter I'm requesting assistance on (NOT the SSIS package).

Is there a...

Quick thought on this, set the Connection string property of the destination connection manager in an expression. Preferably store the entire string in a variable and only alter the database...

Jeff Moden (7/6/2014)

---

ykonline (7/5/2014)

---

Please find the details below

Date CAD CZK EUR

1/1/20101.052018.34750.6977

1/2/20101.053218.39850.6957

1/3/20101.051718.33600.6982

1/4/20101.037718.16240.6935

1/5/20101.037118.25410.6943

Sometimes we may receive additional(new)...

Not certain what is going on here, the attachment has a schema limitation of varbinary(max) and is consistently handled as such all the way through the process. You could try...

Quick question, what is the result of the following query in msdb?

😎

select *,

CAST(paramvalue AS FLOAT) / POWER(2.0,20) AS MX_IN_MB

FROM msdb.dbo.sysmail_configuration

where paramname = 'MaxFileSize'

A good place to start the white paper of Kimberly Tripp and her posts on partitioning[/url].

😎

Ah! now I get it, you mean the nice quiet days in the office:w00t:

😎

TheSQLGuru (7/5/2014)

---

Eirikur Eiriksson (7/5/2014)

---

I've come across this problem few times in the recent past and found that Implicit conversion from CHAR/VARCHAR to NCHAR/NVARCHAR and vice versa, will cause Index Scans...

If each partition holds 4 hours worth you will need 48 partitions (+1) to cover the eight days, maybe a days worth could be fine? All depends on the environment,...

First thing that comes to mind is to partition the tables, have you looked into that?

😎

sqldriver (7/5/2014)

---

Hi Eirikur,

You were half right, but it was right enough to get things working. The versions and paths both matched, but for some reason SSMS would run directly from...

I've come across this problem few times in the recent past and found that Implicit conversion from CHAR/VARCHAR to NCHAR/NVARCHAR and vice versa, will cause Index Scans which can lead...

Quick question, how are you invoking the SSMS, by clicking a menu item or short-cut?

If so, right click on the menu item/short-cut, select Properties and Open File Location. Then right...

Quick question, can you provide some sample data?

😎

Only one thing, if the date value of the null v entry is either the earliest or the latest within the partition, it will not be ignored. Setting it to...