I assume you know how to do it in T-SQL...... Month(DateField) and Year(DateField). You can use the same functions in Excel, Month and Year. Lookup functions in Excel and you...

There are 2 ways I would go about this:

1) Import the spreadsheet into a SQL table (possibly using the Import/Export Wizard), THEN do your comparison. You also wouldn't need to...

Here's more info. I created the package on the server that will be running the job. The SSIS package is in the MSDB database. After I create the SSIS package,...

Okey dokey, it's Monday and guess what?.......... The job failed because of the same error. I'm quite perplexed. I also cannot run the SSIS package manually because of the same...

Jeff, your answer was funny. I knew it was a joke. On a more serious note, if they CAN use the Developer version, they might see a few things they...

If you're using Excel, remember, you have a limit of 65K records per sheet. You said 10K products, so does that mean 10K records or does each product have more...

OK, talked to my network guy and he suggested backing down from IE7 to IE6. I did that and that seems to have worked. I had to re-created the SSIS...

OK, so all I had to do was put the url of the SMTP server in that field for "SMTP Server"? Wow, that was TOO easy. I feel like I've...

I agree with SQLZ. I always try to do as much work as possible in my stored procedure, then display it on the report. At that point all you have...

OK, never mind. I found the error. I modified the file according to the MS Community article. I had to stop and start the SSIS service.

I ran into the same problem with SSRS2005. I had an sp that took only 10 seconds to retrieve the data, but SSRS2005 took about 3 minutes to run. The...

I have always wondered the value of putting the drill-down into the Report. Shouldn't a webpage be used to drill-down into the detail and just use the report for the...

Make sure that your stored procedure has fully qualified tables & database names, i.e. not just Sales but Production.dbo.Sales in the FROM clause. Then in the source for your report,...

I also like Matt's solution. I do this all the time. The only problem with that is that I use an ODBC connection/dsn and you have to set that up...

I believe they are both on the same security.