Brandie did an article which included searching the dtsx files not too long ago using PoSh: http://www.sqlservercentral.com/articles/database+dependencies/153072/?utm_source=SSC&utm_medium=pubemail

What is your question exactly?

Selecting data from a table without an ORDER By clause will never guarantee the order the data returns in. if you add a TOP into the mix, the data you...

If you want to keep a point in time back up, then doing Full and transaction log back ups is probably going to be your best choice. Doing a full...

Also, that query you have at the start is... well, honestly, awful :). I doubt you really need to actually do what I've done above and could easily achieve this...

How about this:
--Create Sample Table
CREATE TABLE #Sample
  (Patent varchar(3),
  Novelty int,
  Landscape int,
  Clearance int,
  Searching int);

That would suggest you aren't a sysadmin, if you're getting write permissions. What does the below return:
SELECT sysadmin
FROM master.sys.syslogins
where name = SYSTEM_USER;

A CTE and ROW_NUMBER should do the trick for you:
CREATE TABLE #SAMPLE
  (Cust BIGINT,
  [Date] date,
  [Status] varchar(150),
  Category varchar(50));

The correct SQL for something like this would be:
--Start at master, as we will creating a LOGIN
USE master;
GO
--Create the LOGIN first
CREATE LOGIN SSCSample

As Steve said, the problem here is that you may have to "guess" where to split the name. The reason being, is that the last "word" of the name might...

Have you installed the latest version of the ACE drivers? You can find them here: https://www.microsoft.com/en-gb/download/details.aspx?id=13255

Downloaded the file, remotely, on my home Raspberry Pi (the expendable one), and the zip file does include 3 xlsx file and a txt file (which contains SQL), so it...