Getting excel into a sharepoint list

Symptom:

When you try to import an Excel spreadsheet into a Sharepoint list using the "Import Spreadsheet" option, the following message appears.

The website declined to show this webpage HTTP 403

Most likely causes:

This website requires you to log in.

What you can try:

Go back to the previous page.

More information

This error (HTTP 403 Forbidden) means that Internet Explorer was able to connect to the website, but it does not have permission to view the webpage.

For more information about HTTP errors, see Help.

Cause and Resolution:

Some have suggested reinstalling Office components on the server or formatting your spreadsheet in table format. Dunno, haven't tried.

Workaround:

Push from Excel as follows:

1. Data: List: Create List
2. Choose your list range and click OK
3. Data: List: Publish List
4. Enter url and name, and click Finish. All done!

SSIS can't find environment variables

Scenario: Deploying SSIS packages that use environment variables and setting up a SQL Server scheduled task to kick them off.

Symptom: Can run packages manually, but the scheduled task fails.

Cause: Environment variables. You have probably logged off and on to the server a few times while attempting to run the packages manually, which means your login has the latest environment variables. However the SQL Server Agent may not have "logged in" recently and will be unaware of the new environment variables.

Resolution: Restart the SQL Server Agent (which is the equivalent of logging it back on to pick up the latest environment variables).

SSIS package location selection criteria

Kirk Haselden's SSIS blog posts circa 2005-2006 are no more, so I am saving what little I have managed to copy or scrounge.

Advantages of Saving to Files:

• Easier to do shared source control
• Ultra secure when using the Encrypt with User Key encryption option
• Not subject to network downtime problems (saved locally)
• May escrow deployment bundles including miscellaneous files
• Less steps to load into the designer
• Easier direct access for viewing
• May store packages hierarchically in file system
• Projects in Visual Studio are disk based and require the package to be in the file system
• Generally, a better experience during development
  

Advantages of Saving to SQL Server:

• Easier access by multiple individuals
• Benefits of database security, DTS roles and Agent interaction
• Packages get backed up with normal DB backup processes
• Able to filter packages via queries
• May store packages hierarchically via new package folders
• Generally, a better in-production experience