In SSMS?

Right-click on the folder you want to save the package in and choose "import".

You can verify if it is a kerberos issue by connecting to ServerA via rdp or using it's console. If you are able to run the report from a...

Because it is 32 bit, it can only address the first 4gb of memory. Since the OS uses a portion of this memory, it is further restricted. I...

My first draft was far less politically correct.

The access denied error is because you do not have the appropriate permissions on the shared directory.

The SQL Server service account will need full permisssions to the directory the backups...

Create an SSIS package to run the query and write the file and use the SQL Agent to schedule the package.

A MERGE JOIN cannot update anything, so I will assume you have two source components (probably OLEDB), two SORT components, a MERGE JOIN, a CONDITIONAL SPLIT, an OLEDB Update, and...

That's not much to go on, but you should check to make sure your SMTP server is running and able to relay messages.

holy cow:

http://www.sqlservercentral.com/Forums/Topic608194-148-1.aspx?Update=1

Ok, you seem to have left out a few key details that will be important in helping you. Please look carefully at your post and try to think of...

Are you sure Integration Services is installed and running on this server? You need to verify that the service is running.

"Now I trying to find software tool."

There is no software tool that will do what you want. What the previous posts have been trying to explain is that there...

I have attached a screen print of one of my month dimensions. The "KeyColumn" is a numeric value and the "NameColumn" is a string ("January 2008"). The "OrderBy"...

That would work, but are you sure you need per-processor licenses? Do you need the enterprise edition of SQL for all of these servers?

If you want a second opinion, Lynn is correct.