Yes, I'm using an SSRS subscription to export the excel file.  The problem is that SSRS exports it badly for some reason and the only way I can get it...

I have both Excel and SQL Server installed on the server.  I am working directly on the server. 

On the server, I can run the SSIS package directly...

I have spent HOURS searching for an answer on Google or I wouldn't be asking here.   All I can find are really complicated scripts that import or export data.  That...

Yes, of course Excel is installed or I wouldn't be able to open the file manually and save it as I mentioned.  That isn't the issue.

Hi! Thank you so much for responding!

I may not have been clear about a couple of things.

The company I'm doing this work for will not allow SSIS to be...

Thank you!!! These are perfect for what I needed. Thanks so much.

If someone can provide a sample script task that will download that file, that would be terrific! Yes, the spreadsheet is complex. I can deal with the layout....

Thank you. That would probably work, but I don't know how to automate downloading this particular file. If you could give me some guidance in that regard, that...

I have exactly the same problem! I hope someone responds!!!

One more small thing that should get you fired as a DBA: Letting the disk drives on your server get so full that your backups fail!!!  I've seen it happen!! 

Karen

Hi!

Thank you for trying!  But This isn't truly a comma delimited file (like a CSV).  The number of commas varies for each row and there's that slash mark in there...