Here are my thoughts after going from many years SQL Server to an extended project in Oracle:

I certainly found a lot of things in Oracle quite 'alien' to me and...

... but its trivial enough to view an environment variable, or anything in the registry for that matter.

If you are considering having your own special database to hold all package...

Some other things you might want to keep in mind:

1. You cannot disable windows authentication into a SQL Server database. So clients would have to specifically not want to add...

I guess the thing is that each customer environment is different. For example there are two authentication modes in SQL: A. Windows only and B. SQL + Windows. A SQL...

If you really really want to continue using SQL Server authentication, you can also use

"Encrypt Sensitive With Password" protection level

You then need to provide a password at design time (when...

A. Why won't you consider using Windows authentication rather than SQL authentication - this gets around the entire issue as no passwords are saved. There are also many other benefits

B....

How does your package login to the database to get the config info?

Does it use SQL Server authentication?

If so then that password won't be saved either and you won't be...

Let me reiterate

The error "Error authenticating proxy SYSTEMS\ADM-N7557784, system error: ConnGetProxyPassword" has nothing to do with package encryption levels.

There is a lot of misunderstanding and misinformation about package encryption levels...

Let me clarify: the error "Error authenticating proxy SYSTEMS\ADM-N7557784, system error: ConnGetProxyPassword" has nothing to do with package security level.

There certainly are numerous other errors to do with using...

I read this page here in detail (rather than speed reading it like usual)

http://msdn.microsoft.com/en-us/library/ms189522.aspx

It implies that when you create your credential, if it is a windows credential, you...

Put simply: No IIS is not required. Just a SMTP server of some description is required.

Your network team should be able to sovle your issue, its just a matter of...

I'm pretty sure that the variable value is reset once the package finishes running. So unless you are doing something with the variable during runtime to validate it (like showing...

Perhaps the declare is confusing it. How about this instead:

insert into dbo.test_delete_yes (col1)

values (?)

failing that, try this:

insert into dbo.test_delete_yes (col1)

values (@MyValue)

.. as different drivers use different placeholders for parameters. See...

In the end, the order the data is loaded into a table is usually irrelevant unless a clustered index already exists on the table and you want to take advantage...

... not to argue with Steve Jimmo's point. In answer to 'how do I make sure that the data in the table is ordered as it is loaded', Steve is...