Viewing 15 posts - 1 through 15 (of 23 total)
Thanks guys. All makes sense.
January 24, 2020 at 7:07 pm
Mhlewis - this looks like it has potential. Going to give it a go. Thanks!
April 23, 2012 at 11:00 am
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...
April 23, 2012 at 10:59 am
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...
April 19, 2011 at 10:20 am
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.
April 19, 2011 at 10:13 am
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...
April 18, 2011 at 2:16 pm
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...
October 28, 2010 at 10:05 am
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...
February 10, 2009 at 8:23 am
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...
February 9, 2009 at 8:48 am
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...
August 25, 2008 at 12:42 pm
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...
August 25, 2008 at 10:44 am
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...
August 25, 2008 at 9:32 am
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....
August 25, 2008 at 7:28 am
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,...
July 28, 2008 at 2:28 pm
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...
July 22, 2008 at 7:25 am