Viewing 15 posts - 3,391 through 3,405 (of 14,953 total)
No, I've had multiple data flows in one data flow task.
What error are you getting?
- 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
September 8, 2011 at 11:54 am
Generally, the higher column IDs are the ones added last, but that can be wrong if you're using the table designer GUI and tables are being rebuilt instead of altered.
I'm...
- 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
September 8, 2011 at 11:52 am
In the workflow, after you import the first file, add an Execute SQL Task, with a full recordset. Store that in a local object variable, and create a For...
- 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
September 8, 2011 at 11:22 am
Are you creating the package in BIDS or some other interface? Multiple data flow tasks in BIDS is dead easy, just drag and drop them onto the workflow.
- 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
September 8, 2011 at 11:20 am
rmechaber (9/8/2011)
GSquared (9/8/2011)
And from my religious perspective, I'd assert your "body" is the whole physical universe, from a certain perspective.
Now that's just downright creepy: what are you doing...
- 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
September 8, 2011 at 9:26 am
ChrisM@Work (9/8/2011)
GSquared (9/8/2011)
rmechaber (9/8/2011)
ChrisM@Work (9/7/2011)
[<snip>Aha - they did. Your friend's statement was absolutely false! 😉
Chris, thanks for posting that: this is a fascinating article and real food for thought. ...
- 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
September 8, 2011 at 9:24 am
I don't understand what you're trying to update. I can't see how your starting data relates to your ending data.
Updating XML in T-SQL is through the "modify" method. ...
- 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
September 8, 2011 at 9:10 am
On the original topic (instead of the much-deserved Celko-bashing), you can force separate ordering within Union (All) queries by adding a "Sequencer" column.
For example:
select 1 as Seq, MyColumnA, MyColumnB
from MyFirstTable
union...
- 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
September 8, 2011 at 7:41 am
rmechaber (9/8/2011)
ChrisM@Work (9/7/2011)
[<snip>Aha - they did. Your friend's statement was absolutely false! 😉
Chris, thanks for posting that: this is a fascinating article and real food for thought. I'm not...
- 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
September 8, 2011 at 7:27 am
rmechaber (9/8/2011)
GSquared (6/2/2011)
However, most DBAs would assume that null = no assigned value, not null = 0 (linguistic equality as well...
- 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
September 8, 2011 at 7:24 am
ChrisM@Work (9/8/2011)
GSquared (9/8/2011)
ChrisM@Work (9/7/2011)
GSquared (6/3/2011)
- 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
September 8, 2011 at 7:12 am
IceDread (9/6/2011)
GSquared (9/6/2011)
- 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
September 8, 2011 at 6:33 am
ChrisM@Work (9/7/2011)
GSquared (6/3/2011)
- 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
September 8, 2011 at 6:30 am
Tom.Thomson (9/6/2011)
GSquared (9/6/2011)
- 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
September 8, 2011 at 6:25 am
SwayneBell (9/7/2011)
Grant Fritchey (9/7/2011)
Oh no, really? I thought she was only writing to me. Our relationship was built on a lie <sob>.
I was disappointed too Grant, what with my movie...
- 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
September 8, 2011 at 6:19 am
Viewing 15 posts - 3,391 through 3,405 (of 14,953 total)