LOL I'm an idiot.  Square brackets!

       public void Main()
        {
    MessageBox.Show(Dts.Variables["User::src_inbox_folder"].Value.ToString());
    Dts.Variables["User::is_new_file"].Value = System.IO.File.Exists(Dts.Variables["User::src_inbox_folder"].Value.ToString());

            Dts.TaskResult = (int)ScriptResults.Success;
        }

There is a property in the package that will allow you to save sensitive with password. Use that. Or better yet, use SSIS configs in a table. ...

https://www.youtube.com/watch?v=GiGHkQi2SAk

He gets around to it at 7:15. Config type is Parent package variable.

I got partial answers from @sqldba and @SQLfool on #SQLhelp. Can hack my way from there. So NM.

--BSC is one of the largest and most exciting centers for higher education in the commonwealth. Here in our idyllic setting, you'll find an institution steeped in history, ready for...

Should anyone wish to know the solution...

I had to sign this public key with my secret key in order to execute the command in batch mode.

I have a script task in an SSIS package that I wrote to PGP encrypt files using a public key from client A. Among other things, it writes a...

For anyone following... the solution was to disable and re-enable replication on both servers.

Jeff Moden (7/16/2010)

Yep... make sure they didn't change the domain name or the server name of the target server and make sure they didn't change the login name or password.

As...

Screw the proc. I put the script in line. Works.

EXEC sp_MSforeachdb 'USE [?]; print DB_NAME();

DECLARE @TableName VARCHAR(100) --For storing values in the cursor

--Cursor to...

noeld (6/25/2010)

ZenDada (6/25/2010)

As usual, Pinal Dave has the...

Thanks! That did the trick!

As usual, Pinal Dave has the 411!

http://blog.sqlauthority.com/2007/03/25/sql-server-identity-vs-scope_identity-vs-ident_current-retrieve-last-inserted-identity-of-record/

I assume that id is an autonumber so let's not depend on that to be a perfect sequence, but rather to define the order ok?

Then, self-join and account for null...