October 29, 2009 at 1:26 pm
Can you put Recordset Destination in the table?
October 29, 2009 at 1:31 pm
Do you Recordset from a T-SQL Statement?
If thats what you need, then
INSERT INTO TABLE ( COL1, COL2 , COL3 )
SELECT COL1, COL2 , COL3 FROM YOUR QUERY
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
October 29, 2009 at 1:56 pm
No, thru from another data flow destination
October 29, 2009 at 2:04 pm
Explain further, please, what you are trying to accomplish. Your question does not make much sense.
October 29, 2009 at 2:05 pm
No, thru from another data flow destination
It must be another Dataflow Source, and your Table where you want to insert data is your Destination.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
October 29, 2009 at 2:12 pm
I need the _recordId from Recordset Destination, is there a way that I can put these_recordId in a table, is that possible?
October 29, 2009 at 2:29 pm
CooLDBA (10/29/2009)
I need the _recordId from Recordset Destination, is there a way that I can put these_recordId in a table, is that possible?
Couldn't Understand what is _recordId? and that too from the destination? would you like to get from a source or destination?
More help can be available only if you explain with what you want and what is the table structure you have.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
October 29, 2009 at 3:02 pm
CooLDBA (10/29/2009)
I need the _recordId from Recordset Destination, is there a way that I can put these_recordId in a table, is that possible?
Sure you can. RecordID would be another piece of data and thus could work nicely in a table of data inside of a database.
The question is, where are you trying to get this RecordID from?
What have you tried so far to make it work?
Do you have sample data?
Do you have sample table structures?
Do you have sample code?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 30, 2009 at 7:05 am
CooLDBA (10/29/2009)
I need the _recordId from Recordset Destination, is there a way that I can put these_recordId in a table, is that possible?
Yes, it's possible.
Is that a column in your destination table? Or do you want it in a different table than the destination table? I can't tell from your question.
- 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
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply