May 11, 2012 at 10:46 am
Ok... I'm not asking about connecting Excel to Sql sErver, I'm looking about the other way. I have a list of "objects" that I'm going to be provided. I want to compare to those objects which will hae unique identifiers, to another list of objects. I don't want to build a table for this list, otherwise I'd just import it with SSIS like normal...
I want to connect to the spreadsheet, compare it to the table, and be done. easy... boom, simple, right?
May 11, 2012 at 11:20 am
Honestly I'm not sure this is possible.
Even if it were I have to say I don't think its a good idea. Just create a table in the tempdb and SSIS it in.. Then drop the table when you are done.
CEWII
May 11, 2012 at 11:23 am
I do not condone it, but in some cases it can be useful. I only know it's possible because it came up recently and I did a quick POC for the other poster.
http://www.sqlservercentral.com/Forums/Topic1293266-392-1.aspx#bm1296072
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 11, 2012 at 12:36 pm
I'm not surprised its possible.. But I absolutely wouldn't do it and wouldn't let any of my developers do it.
CEWII
May 11, 2012 at 12:36 pm
Elliott Whitlow (5/11/2012)
Honestly I'm not sure this is possible.Even if it were I have to say I don't think its a good idea. Just create a table in the tempdb and SSIS it in.. Then drop the table when you are done.
CEWII
I guess I'm not allowed to be lazy.....
May 11, 2012 at 12:55 pm
CptCrusty1 (5/11/2012)
Elliott Whitlow (5/11/2012)
Honestly I'm not sure this is possible.Even if it were I have to say I don't think its a good idea. Just create a table in the tempdb and SSIS it in.. Then drop the table when you are done.
CEWII
I guess I'm not allowed to be lazy.....
I try to preach good or best practices. And dissuade practices on the opposite end.
You are certainly free to do what you want, but I wouldn't recommend this path.
You would have a better argument if this was a one shot and never going into production but as I said in another post I wouldn't do and I wouldn't allow one of my developers to do it.
As a further point, I'm willing to bet we've spent more time discussing it than was ever going to be saved by being lazy.
You are certainly free to disagree and I'm ok with that.
CEWII
May 11, 2012 at 12:55 pm
CptCrusty1 (5/11/2012)
Elliott Whitlow (5/11/2012)
Honestly I'm not sure this is possible.Even if it were I have to say I don't think its a good idea. Just create a table in the tempdb and SSIS it in.. Then drop the table when you are done.
CEWII
I guess I'm not allowed to be lazy.....
You are allowed to be lazy. Just be judicious in your use of Linked Servers and know what you're signing up for.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 11, 2012 at 1:04 pm
Ok everyone.. I have been duly chastised for even THINKING of such a horrible a wasteful idea. I will refrane from such silliness in the future and instead ask about something more acceptable like how to get my money tree to sprout $100's instead just a bushel of $20's... 😀
Point... Set... and Match.
LOL....
May 11, 2012 at 1:08 pm
Wow, lazy, sarcastic and ungrateful. Nice combo Cap'n 😛
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 11, 2012 at 1:09 pm
I try... I try... yet, it is a skill I have....
May 11, 2012 at 1:10 pm
CptCrusty1 (5/11/2012)
I try... I try... yet, it is a skill I have....
---Although, don't think I'm ungrateful... I'm always grateful to those with more knowledge, experience, or both as they can further impart their knowledge unto me and thusly and am enriched.
May 11, 2012 at 1:12 pm
CptCrusty1 (5/11/2012)
CptCrusty1 (5/11/2012)
I try... I try... yet, it is a skill I have....---Although, don't think I'm ungrateful... I'm always grateful to those with more knowledge, experience, or both as they can further impart their knowledge unto me and thusly and am enriched.
I guess I'll take that as a thank you. Thanks is not the reason why I donate my time to help others, but it is never turned away 😎
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
May 11, 2012 at 1:16 pm
Yes... That was a thank you... just a goofy one which is normal for me... 😉
May 11, 2012 at 1:19 pm
-Removed snarky comment due to what was posted while I was typing it-
CEWII
May 11, 2012 at 1:21 pm
CptCrusty1 (5/11/2012)
Yes... That was a thank you... just a goofy one which is normal for me... 😉
Welcome to SSC!
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 15 posts - 1 through 15 (of 20 total)
You must be logged in to reply to this topic. Login to reply