That's a typo. I started writing this, put aside for a couple of months, then made a few screen shots and finished it up. I didn't review it well enough....

I am not sure of what you are asking, but an Excel file with 1000 lines is not a big file. Exporting it to CSV would be trivial.

Do you know...

Reading Excel files is not trivial. You can export them to CSV files out of Excel. CSV files will work fine.

You would have to convert them manually one-at-a-time, unless you...

This is a great idea, but in my particular case our sysadmin will not allow the dot net framework to be installed on his SQL Servers because of perceived security...

Could you make a copy of the file and email that?

"What is the advantage of doing this versus firing a subscription for the report?"

You can email a report snapshot to interested parties as soon as new data has been added...

I have been wanting to be able to do this for years. Thanks a lot!

XML attributes are a legacy from other markup languages. Attributes work well in transformation languages such as HTML or XSL because their tags are actually more akin to commands. Nesting...

Very bottom of the article, very last item named "Resources" click on "xml_demo_files.zip."

Here is another

http://www.youtube.com/watch?v=xQZ3mhV7DL8

I think this will help you.

http://blogs.msdn.com/b/mattm/archive/2007/12/11/using-xml-source.aspx

I think this is better than the way I was going to do it.

(I posted this once but it didn't show up, so...

I think this will help you.

http://blogs.msdn.com/b/mattm/archive/2007/12/11/using-xml-source.aspx

I think this is better than the way I was going to do it.

It is the same XML file that was created in Part 4

http://www.sqlservercentral.com/articles/XML/87963/

In the next article out next Wednesday I create an SSIS package that emails/ftps invoices to individual customers. That's why I wrote it for one customer at a time.

Thanks. A good one to know.