OpenQuery will allow you to do this.

This is a common issue that a lot of people have posted about. Search the site a bit. SSRS has trouble with these because the temp table does...

I take back my response. I am no fan of cross-posting.

Thanks Matt.

If you are going to log this manually, I would use a SQL Command component and put it into the appropriate Event Handlers of the package.

However, rather than creating your...

That should work. Are you getting messages about the application of the config file (or an error about it) in the feedback window when you open the package?

And I don't, but every once in awhile I put a comment about an Editorial - then after a week I am still getting emails about it and it is...

You can run SSIS 2005 and SSRS 2005 with a 2008 database engine - all on the same server. In fact, you can run the database engines in two...

Using bulking insert from a .csv file. No commas in data.

umm...

csv = comma separated values

you must have commas.

Open the file in Notepad rather than Excel to...

SSIS does not save ODBC passwords because they would have to be saved as plain text. You need to use package configurations. Interestingly, if you create a package...

It will really depend on what you plan on doing with them. In a basic installation, all of them reside on a single server. Keep in mind that...

No, I don't - sorry. I assume you are using a custom front-end because Report Manager only gives you the option of having it build the "IN" clause for...

To do the kind of test you are trying to do, you need all other variables equal. So, if you really want to do this, I would suggest you...

Yes. It is possible. You will not be able to configure it with the log shipping tools included with SQL Server, but it can be done. I...

Check the Regional and Language settings on the server in the control panel.

You are looking at a warning about the decryption of passwords in a package that has it's package security set to excrypt sensitive with user key. This is the...