🙂 glad I could help

No problem, thanks for posting back.

I tried this in Excel 2010 and, whether the date is a 'proper' date or just a date entered as text, it...

Great. A connection in SSIS can be defined at either the package level (which you know about) or the project level.

All packages within an SSIS...

You need to remove the GO after 'use MSDB'.

PSB (1/19/2016)

---

Hi,

I am trying to run a SSIS package as a job which copies data from sql view into a csv file using Execute process Task to a location...

Something like this?

select name, CaseDate, ct = count(1)

from tbl

group by name, CaseDate

I cannot...

--Create the role

create role myApp authorization dbo;

go

--Create users in the db

--Add members to the role

alter role myApp

add member [domain\user];

--etc

--Grant permissions to the role

grant exec on schema::mySchema to myApp

--etc etc

qbrt (1/19/2016)

---

Phil Parkin (1/19/2016)

---

qbrt (1/19/2016)

---

Phil Parkin (1/18/2016)

---

Merge can be idempotent. I would recommend doing the UPDATE part of the MERGE only if an update is required. I do this via...

alex.sqldba (1/19/2016)

---

Afternoon All,

I am just trying to get in line a great many SSIS packages that either might be used, might not be used, are duplicated in terms of purpose,...

qbrt (1/19/2016)

---

Phil Parkin (1/18/2016)

---

Merge can be idempotent. I would recommend doing the UPDATE part of the MERGE only if an update is required. I do this via the

WHERE NOT EXISTS...

Merge can be idempotent. I would recommend doing the UPDATE part of the MERGE only if an update is required. I do this via the

WHERE NOT EXISTS (SELECT source INTERSECT...

I cannot understand this.

Please post your...

ffarouqi (1/18/2016)

---

Lolz...that is already there at the top of this post. Yes, the id is different, as I was using my friend's account to post it, but now I am...