Viewing 15 posts - 11,026 through 11,040 (of 13,872 total)
In the absence of a question in your post, it seems that the import/export (or should that be export/import) method is the one to use.
November 18, 2011 at 5:03 am
I think Excel can handle only 256 columns.
True for 2003. 2007 onwards allow 16,384 columns, requiring a truly microscopic font in SSRS 😛
November 18, 2011 at 3:35 am
Good answer, but note that you have answered a question which is more than a year old 🙂
November 17, 2011 at 3:23 am
What do you mean by 'remote'? Outside of your LAN?
November 16, 2011 at 1:32 pm
What about FROM, JOIN & TRAN? [BigGrin]
And, especially around the middle of the afternoon, or when you accidentally pressed F5 while connected to production, DUMP.
November 16, 2011 at 9:05 am
I'm still a little puzzled.
I create a new Excel Workbook from scratch.
I import the Pivot Tables into 7 different sheets and the size grows to 116MB even though I deleted...
November 15, 2011 at 7:47 am
Welsh Corgi (11/7/2011)
The macro listed below will reset the used cell ranges and should reduce the File Size.
I can't...
November 15, 2011 at 6:59 am
Perhaps this thread is of interest.
November 15, 2011 at 3:16 am
Script component is what you mean, I think.
Well done on taking the time to find a solution to your problem.
I still have concerns over the potential performance of your...
November 15, 2011 at 2:06 am
Don't think so. But you can use a combination of SUBSTRING and RIGHT to achieve the same thing - something like this (untested):
UPPER(SUBSTRING(@FileName,1,11))=="NEWPRODUCTS" && UPPER(RIGHT(@FileName,3))=="TXT"
November 14, 2011 at 2:05 pm
I can't see any reason why this would help in this case, but I have generally had more success using UNC paths rather than mapped drives for jobs like this.
November 14, 2011 at 11:39 am
Thanks Phil, well now I am beginning to know enough about SSIS to be a danger to myself and anyone around me.
No problem!
November 14, 2011 at 8:14 am
Hehe.
Here's how it's done in SSIS.
1) Add a data flow task.
2) Add an OLEDB source connection to the DF.
3) In the connection manager settings for the OLEDB source, select 'SQL...
November 14, 2011 at 7:56 am
Thanks for the extra detail - makes more sense now.
If you want to avoid loops, you'll need to use the power of the database - and as the data is...
November 13, 2011 at 2:05 pm
I'll start off by saying that I am almost certain that no WHILE loop will be required here.
But in order to get to a solution, I'll need to ask a...
November 13, 2011 at 12:59 pm
Viewing 15 posts - 11,026 through 11,040 (of 13,872 total)