October 27, 2010 at 9:58 am
WayneS (10/27/2010)
GSquared (10/27/2010)
WayneS (10/26/2010)
Gus,Since you seem to know SSIS pretty well, I have a question for you. Is there a way to have a query that generates dynamic columns exported to an excel spreadsheet? The problem that I've run into is that in the Data Flow, you have to have the source and destination columns pre-defined... is there a way around this?
I've read about having a script that essentially generates a SSIS package on the fly... this is way too much complicated.
Thanks!
How dynamic?
I've built something that had four or five different formats, and I just used different connection strings to different sources for that. But truly dynamic isn't something I've done. I'd have to try it out.
In the source, the #/type of columns remains same; column names change (depending on what year package is being run for). The changing column names need to be reflected in the Excel spreadsheet destination.
Edit: I can move this to a proper thread if desired...
Good idea on setting up a proper thread. Hate to get technical in here.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
October 27, 2010 at 10:18 am
GilaMonster (10/26/2010)
Trey Staker (10/26/2010)
@Gail, how's that difficult contract going?Difficultly.
Officially going to prod on Friday.
And how long after Friday do you think it will take for everything to be working right?
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
October 27, 2010 at 10:25 am
WayneS (10/27/2010)
GilaMonster (10/26/2010)
Trey Staker (10/26/2010)
@Gail, how's that difficult contract going?Difficultly.
Officially going to prod on Friday.
And how long after Friday do you think it will take for everything to be working right?
Um.... I already have change 'requests' that I'm refusing to do now. It's 18h30, I'm doing other work tomorrow, and I'm still implementing constraints.
It'll work - no errors, all specified functionality present - on Monday (1st day live). Whether it'll do what the user wants or not is another matter.
Edit: One of the three systems that I'm supposed to be interfacing with is expected to give me a schema doc within the next two weeks.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2010 at 10:32 am
GSquared (10/27/2010)
WayneS (10/27/2010)
GSquared (10/27/2010)
WayneS (10/26/2010)
Gus,Since you seem to know SSIS pretty well, I have a question for you. Is there a way to have a query that generates dynamic columns exported to an excel spreadsheet? The problem that I've run into is that in the Data Flow, you have to have the source and destination columns pre-defined... is there a way around this?
I've read about having a script that essentially generates a SSIS package on the fly... this is way too much complicated.
Thanks!
How dynamic?
I've built something that had four or five different formats, and I just used different connection strings to different sources for that. But truly dynamic isn't something I've done. I'd have to try it out.
In the source, the #/type of columns remains same; column names change (depending on what year package is being run for). The changing column names need to be reflected in the Excel spreadsheet destination.
Edit: I can move this to a proper thread if desired...
Good idea on setting up a proper thread. Hate to get technical in here.
Wayne
Microsoft Certified Master: SQL Server 2008
Author - SQL Server T-SQL Recipes
October 27, 2010 at 10:39 am
Whew, for a second I thought I was going to learn something on The Thread.
October 27, 2010 at 10:40 am
Steve Jones - SSC Editor (10/27/2010)
Whew, for a second I thought I was going to learn something on The Thread.
Heaven forbid. That would be a disaster.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 27, 2010 at 10:40 am
BTW, speaking of technical stuff....
I wonder if any of you would be interested in writing to fill holes? I keep finding posts here, and elsewhere that someone answers a question about and we don't have an article on. Like our joyous person today that thinks there is some magical tool to audit the last time a table was accessed.
If you see something like that, and don't have an SSC reference, I'd love a 1 pager that solves the problem for future reference.
October 27, 2010 at 10:42 am
Steve Jones - SSC Editor (10/27/2010)
Whew, for a second I thought I was going to learn something on The Thread.
I'm assuming you meant learn something technical, becuase I'm sure you've already learned a few things in here. If nothing else, you learned a few things to avoid. 😀
Hey, and you should have learned a few good jokes too. 😛
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 27, 2010 at 10:45 am
Steve Jones - SSC Editor (10/27/2010)
BTW, speaking of technical stuff....I wonder if any of you would be interested in writing to fill holes? I keep finding posts here, and elsewhere that someone answers a question about and we don't have an article on. Like our joyous person today that thinks there is some magical tool to audit the last time a table was accessed.
If you see something like that, and don't have an SSC reference, I'd love a 1 pager that solves the problem for future reference.
I have something ready on that topic.
It should not be an issue setting up an article in anger (with a little help for my English).
-- Gianluca Sartori
October 27, 2010 at 10:46 am
Steve Jones - SSC Editor (10/27/2010)
BTW, speaking of technical stuff....I wonder if any of you would be interested in writing to fill holes? I keep finding posts here, and elsewhere that someone answers a question about and we don't have an article on. Like our joyous person today that thinks there is some magical tool to audit the last time a table was accessed.
If you see something like that, and don't have an SSC reference, I'd love a 1 pager that solves the problem for future reference.
I'm planning to start something like that next week for solving simple SSIS issues; essentially a bunch of 1 page examples. If I have someone nagging me for results I might get it done. 🙂
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 27, 2010 at 10:48 am
Steve Jones - SSC Editor (10/27/2010)
BTW, speaking of technical stuff....I wonder if any of you would be interested in writing to fill holes? I keep finding posts here, and elsewhere that someone answers a question about and we don't have an article on. Like our joyous person today that thinks there is some magical tool to audit the last time a table was accessed.
If you see something like that, and don't have an SSC reference, I'd love a 1 pager that solves the problem for future reference.
Put me down for that. Worst problem I have it trying to think up stuff to write about.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 27, 2010 at 10:54 am
Grant Fritchey (10/27/2010)
To the Threadizens/Threadites/Threadoids/Threadopians:Please, make sure, if you're going to the Summit, you track me down and introduce yourself in person. Some of you I know already, Dixie,Jeff,etc., but some of you I've never met. I'm going to be all over the place, but I really want to meet you people for the first time, or again. If nothing else, I'll be working as a Amabassador for the keynote on Tuesday. Look for the tall bald guy in a red vest.
You mean we won't all be meeting at the SSC party on Monday Night?:-D
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
October 27, 2010 at 10:56 am
Excellent. If you want to write on something, might post a note here so we don't have collisions. Good to get a 1-2 pager on common stuff that can be used to answer questions.
October 27, 2010 at 10:56 am
Grant Fritchey (10/27/2010)
Steve Jones - SSC Editor (10/27/2010)
BTW, speaking of technical stuff....I wonder if any of you would be interested in writing to fill holes? I keep finding posts here, and elsewhere that someone answers a question about and we don't have an article on. Like our joyous person today that thinks there is some magical tool to audit the last time a table was accessed.
If you see something like that, and don't have an SSC reference, I'd love a 1 pager that solves the problem for future reference.
Put me down for that. Worst problem I have it trying to think up stuff to write about.
It won't be too hard for me to come up with something to write about. There's numerous forum questions that I wanted to answer but the response was going to take more writing than I had time for. A number of these were closely related to question that had been asked before but never properly answered. If I had had a good reference to point them to I would have used it.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
October 27, 2010 at 11:04 am
Steve Jones - SSC Editor (10/27/2010)
Excellent. If you want to write on something, might post a note here so we don't have collisions. Good to get a 1-2 pager on common stuff that can be used to answer questions.
But is someone going to point out the topics that need it? Like you bringing back the auditing topic we'd need a mechanism (the Thread, clearly) to bring this stuff up so that the thicker headed amongst us (me) know what to do.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 15 posts - 20,866 through 20,880 (of 66,815 total)
You must be logged in to reply to this topic. Login to reply