It does not matter what privileges you have when you are logged onto the server. That is not the account used during the restore process. The account running...

There are many places in SSIS that are case sensitive - I notice that we are showing

@[User:: and @[user::

I believe the capitalized version is correct. That may be...

Hmmm - I wonder if it has to do with the LDB lock file. I haven't tried setting up a linked server to MS Access 97. But we...

Excellent article. Although this is not a situation I have encountered yet in SSIS, it is a good workaround to be aware of.

Now that I have used SSIS for...

If I wanted to do this kind of thing server-side I too would look at a server grade component like SA Excelwriter.

With MS Excel, I think if you would...

I have done this using a script component as Tim referred to above. Since you are new to SSIS, however, just be aware that you will be taking a...

The login account running the SQL Server service will need access to the network share you are using. If your server is using the Local System account to run...

Thanks - this will get me started down the right path.

You would need to change the Data Source of the report. I haven't done this, but it looks like there are a couple of ways it can be done....

Do you mean that each user will supply a different report parameter that would cause their respective reports to differ?

If they shouldn't receive the identical report, what would cause the...

I also want to point out that you can run SQL 2000 DTS packages in the SQL 2005 environment without converting them to SSIS. This may be an interim...

This probably isn't applicable for your situation since your box is likely to be a pure SQL server; but I'll throw it out there anyway.....

We got our first 64-bit 2005...

I configured a Linked Server using the "iSeries Access ODBC Driver" supplied by the IBM iSeries Access for Windows software. We do a daily data extract from our AS400...

My final code ended up as something of a hybrid of the code all of you supplied. The execution time went from an hour to under 10 seconds!

Another testament...

I see... sort of a FLOOR function for quarter hour rounding.

In my case I'll just record the ugly unrounded decimal because

we'll be aggregating the labor-hour values in later...