I have realized that when creating a new connection within the package, there is an option "New Connection from Data Source", however when creating a package configuration and telling it...

I get prompted for a password when I open the package even with EncryptSensitiveWithPassword.

Worked like a charm!!!

Thank you!

p.s. Do you think it's OK to store a FTP password in a variable? No compliance issues here?

I think I got an answer to a similar question.

Thanks for your help anyway.

I did not create a config for it.

All the variables I have have the scope of the package that runs it.

All I am asking is how to make the Package read the directory on a server and not my local machine when being executed. I don't know what configuration I...

🙂

NEVER!!!

I know I know, that's what I said.

All they want is just to send a...

That's the thing.

If these requests went further than that by taking the new value and saving it, and keep the old value for history; then it would be no brainer.

This...

Single table was my initial thought as well. Have a EmployeeID foreign key in the DirectDeposits table to join to Employees table.

But at the same time I thought about...

Should I also decide based on the size of the company?

If a company is relatively small (100-120 people), would it make a difference on the amount of work required?

Allocation errors probably will require to run hardware diagnostics and check disk space.

Consistency errors I am not sure but my first thought would be to run a repair.

Obviously I will...

I don't think you are discouraging me. I think you all bring up very solid points and allowing me to step back and evaluate my capabilities and look at the...

Let's see if I pass my first test if the database is corrupt. 🙂

I would probably run dbcc checkdb ('mydatabase') with All_ErrorMsgs

You bring up very valid points. I am definitely going to take Alvin's advice and ask all those questions from them.

Regarding my current professional situation, I am not happy with...

CirquedeSQLeil,

Why do you say that? Please explain.