Thanks guys.  All makes sense.

Mhlewis - this looks like it has potential. Going to give it a go. Thanks!

Thanks Jason. I have used that to upload PDFs, which then become handsomely viewable by the users, but what I looking for is a way to automate getting the...

King Cobra, you should be able to add a new datasource and site your .xls(x) as the source of the data.

Regarding the original post, I'm wondering if anyone knows of...

Thanks all, I went ahead an installed an instance of 2008 to solve this one as it turned out to be the most painless option.

D

Thanks for the reply Gail.

I need to check into whether replication is an option with this vendor. What type would you recommend based on my previous description of our...

Thanks for the reply, but more specifically I am looking to add other file types (that aren't necessarily created by an rdl) directly to SSRS, making them available for viewage...

Thanks for the reply.

I have, but as soon as I change retainsameconnection to true, the first time I try to connect to the data source in the package (in an...

Seemed like no matter how I exported the text file via SSIS components, it always had an "extra" blank line at the end of the file after the last cr...

1. Loop container

2. No idea, this is from a vendor. I'm guessing they want to keep us from bogging down their server (data is available to many...

Here is the lowdown:

I am trying to connect to an outside datasource (via data reader source - only way I can go) that only allows me to pull 2000 records...

It worked both when i changed to to varchar(4000) and when I left it as varchar(max) and changed the result to object.

Now I am trying to determin what...

My goal is to put the comma delimited single row result into a variable and then use that variable in an sql statement in a subsequent component in my package....

Thanks for the reply Tom.

I tried your suggestion, but was unable to process it without getting errors. I wasn't sure whether I needed to do an xslt, xpath, diff,...

Thanks Michael!

I set the SQLCommand to my variable in the expression. It evaluated fine. However when I leave the expressions window, the sqlcommand property of the data flow...