did you already configure a credential and proxy operator in SQL Agent?

Did you configure that step to use that proxy operator?

the account that runs the SSIS jobs \is often a...

both examples were extremely helpful, folks, thank you!

I did it both ways as my proof of concept; I was already leaning towards Phil's example of a script task, but I've...

the key is to generate all possible combinations first..

Basically, you have to select from Your Calendar/Dates table,and cross join all possible employees, and then finally left join it to attendance.

WHERE...

what you are looking for is a Cartesian Product;

also known as a cross join

the syntax is pretty simple:

SELECT * FROM #Table1

CROSS JOIN #Table2

in the future, if you want the...

dndaughtery (12/13/2016)

---

Hey guys, I'm using an execute process task to unzip a password protected zip file. I'm able to unzip and create the file in the target folder but it...

I think it's a column descriptor in master.sys.procedures;

I've confirmed that my proc, which sets specific trace flags, shows up in my results:

SELECT *

FROM master.sys.procedures

WHERE [procedures].[is_auto_executed]...

i believe it's suffering from the classic error: recovery mode is FULL recovery, someone took at least one full backup, and no one has ever run a log backup, nor...

pretty sure standard edition featureing multiple Basic Availability Group is supported, and if you have multiple databases, that kind of forces you into having to design one db per group.

...

I got my SQL2012/2014 MCSA in May 2016, which was probably a month before SQL2016 RTM came out.

The official books for the three new SQL 2016 MCSA come...

row_number featuring partition by will do what you are asking;

here's an old example, but you can see you get all the other values but it's logically grouped by the...

jbalbo (12/8/2016)

---

Thanks for the quick response and sorry for the lack of explanation on my part!!

I am using a Bulk insert via a txt file and...

yes, but you need a case statement to bulletproof the calculation for data shorter than your assumption.

CREATE TABLE EXAMPLE (

ExampleId int IDENTITY(1,1) NOT NULL PRIMARY KEY,

MyColumn varchar(30)

)

INSERT INTO EXAMPLE(MyColumn)

VALUES( ''),('1234567890')

ALTER...

komal145 (12/8/2016)

---

hi All,

I have a package , where i get the results from a storedprocedure and send it to a file.

meaning OLED source ( sql command) ---> Flatfile.

Pacakge runs...

wow, I've heard of petty turf wars like this happening.

You've got to bring it all out in the open, with your DCD and all related supervisors; this is not the...

CELKO (12/6/2016)

---

Correct minor typos:

CREATE TABLE Forest

(node_name VARCHAR(20) NOT NULL PRIMARY KEY,

lft INTEGER NOT NULL CHECK (lft > 0),

rgt INTEGER NOT NULL CHECK (rgt > 1),

CHECK(lft < rgt));

INSERT INTO Forest

VALUES

('Root',1,8),

('first child...