I found online that powershell is built into Windows 2012 Server R2 so I don't understand why I'm getting this error

When I try to run the execute process task I get the following error:

The specified executable is not a valid application for this OS platform

Is there something I need to...

DOH!

Thanks Phil

The expression evaluates to

-ExecutionPolicy Unrestricted -File"\\MyServer\Folder1\Folder2\My_Scripts\Get-00094_ReSubFiles.ps1"

I am using a UNC directory in the ssis variable used in the expression

I don't have anything set in the process section.

I have an update statement that uses With NOLOCK. Its been working fine for months. We have some yearly reports that another team member is running. Is it possible that...

Or you could use a lookup task and using a select distinct title along with row_number() to create the id to get the lookup data and then join on title

Wait a sec, just reread your original post. You want the same id for common titles. Seems like you should have a lookup table. You could select distinct title into...

Set the column to be an Identity(1,1). Means that the first row will have id value of 1 and the next will be 2, and on and on.

Since the table already exists you'd need to create another table and add the id column then load it with the data from the old table, delete the old table,...

Thanks but I was trying to figure a way I wouldn't need to use an embedded query. Something like turning

MCRNUS.REVIEW_TYPE <> 'HCR'

...

That worked, thanks

Yeah, I have steps 1 through 3 complete. Just not sure how to go about setting up step 4

Should the access of myself and SQL Server matter if I'm supplying a username and password? I am able to use filezilla client to import the files.