it depends on the details, but regardless, you have to generate the list of commands from some place; the msdb backup history from production, or the folder full of files,...

because this looks a bit like homework, let me throw out suggestions and not the solution.

the key here is that you need to test consecutive values. to do that, you...

GilaMonster (11/23/2015)

---

Then you'll need to disable the cores in the server's BIOS, If the cores are visible to Windows, they have to be licensed. Ask the sysadmins to do the...

ok, if it's dynamic, it a pain, but doable. so much of it depends on the page that is presented with the listof files, because you have to extract them...

If you know the file name(s),there's quite a few articles on how to do this either via the SSIS component or a script task; i saw a lot in the...

Could you be raising an error but left off the rollback tran command?

the core error is that xml is case sensitive, but you capitalized some of the values.

SELECT

@edate=GETDATE(),

...

reformatted for readability, still looking at the code....

offhand, because of the OR statements turnign this into a catch all query, i think this should be multiple queries that insert into...

caojunhe24 (11/20/2015)

---

And I saw some people had same issue with job agent and they solved problem by making folder as shared folder. But the point is my folder is in...

caojunhe24 (11/19/2015)

---

everyone has access permission on that folder and if I create a job then will use my account credential to run that job anyway I guess. And like I...

the error is fairly straightforward, tempdb ran out of space.

Typically this is because tempdb auto expanded until it literally fill up the disk is is on.

That assumes you have one...

sounds like every user is in the db_owner role, so that's most likely the issue.

remove all permissions assigned to an existing user, and start fresh.

something like this is what you...

if the script task is counting files on some file share like \\servername\sharename, does the account[MEDASSURANT\BPA_UAT_DS] have access to that share? is that a domain account?

when you run it locally,...

caojunhe24 (11/19/2015)

---

I have a script task in my SSIS package and count file numbers in the folder but always return mecount = 1 even if there is no file placed...

doesn't a modificiation featuring these three constraints satisfy the requirement?

i read "but VhID and PrID can be the same in one row so long as ExtID is different" as unique...