Insert records into temp table (#MyTable) like an Ole DB Destination
-
HI all,
I create a TEMP table like #foo in control flow SQL task....and all is fine.
-------------------------------------------
CREATE TABLE #foo(bar int)
GO
INSERT #foo
VALUES (1)
-------------------------------------------
It's possible INSERT recont from a flow and not directly from SQL...'cause I got a data flow from TXT file...that want update into my TEMP table (#foo) ... something like OLE DB destination...but into my Temp Table.
Is possible?
Thanks Alen, Italy
-
Yes, it is possible. Check following blog post how to do it.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
-
Tnks...but I know that post...
"...My imaginary scenario is one where I want to create a temporary table using an Execute SQL Task and then consume it using an OLE DB Source component in a data-flow task. Here's what you have to do:.."
I don't want consume it using an OLE DB Source...but I want insert data into like an OLE DB DEstination
-
If you checked the post carefully you will see this scenario is possible. You have make sure you use the same connection object in the Execute SQL Task and the data flow and use DelayValidation option for the OLE DB Destination component. This information is included in the post I have sent you.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/ -
You could always create a static table in TempDB as well....i.e.
create table tempdb..blah
(
id int not null,
somecolumn char(10)
)
Then drop the table when you are finished with it. As already pointed out in an earlier post you will need to enable the DelayValidation option.
Tommy
Follow @sqlscribe -
OK I think this best way...thanks...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply