There are a lot of ways to do encryption, one is in the database which means that the DB will usually handle encryption and decryption, and the ENCRYPTBYPASSPHRASE is fine...

Lowell,

COLUMNPROPERTY('IsIdNotForRepl') should return 0/1/NULL

I'd look over COLUMNPROPERTY, it has a bunch of useful information..

CEWII

In the execute SQL Task you will replace where you want to use it with "?", ie WHERE Field1 = ?

Then you will use the parameter mapping tab to say...

The only thing that comes to mind is building the package programaticually from .net and then executing it.. I haven't done this but it seems interesting..

CEWII

What is the problem with Agent? You certainly can use Windows Scheduler but I would only as a last resort. Agent is designed to hande this..

CEWII

I'm willing to bet that the SSIS problem with @@SERVERNAME is that it is complaining about the column name, which there isn't one of.. Replace @@SERVERNAME with ServerName =...

Both machines in the same domain?

You are logging in to the initiating machine as a windows user?

Just to see if it works at all why don't you key in a...

On the security tab of the linked sever, how do you have the security configured?

What radio button is selected?

CEWII

No, you could copy the view to another object but not freeze it..

CEWII

The minimum granularity of datetime is 3ms. Basically as long as you are using datetime that is as good as it gets. You could store it as a...

Well to gauge how much pain will be involved..

Do you use Dynamic Properties tasks?

Do you use ActiveX Scripting?

Do you use UDL files?

If you do then it is more painful.

http://pragmaticworks.com/Products/Business-Intelligence/DTSxChange/

Has some...

Agreed..

CEWII

If he has access, he has access..

I don't know what kind of authority you have but if it is sufficient you say that those tools are not to be used....

You are making an assumption about rights that is problematic. You have rights on the LOCAL machine, does your user (or the one used to make the connection to...

Does the proxy user have access to the path. Does it have sufficent rights in the File system to do what you want?

Try to run the SSIS package on...