how to build it right? - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

how to build it right?

Author

Topic

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-02-19 : 07:30:58

i have 3 tables: TABLE1,TABLE2,TABLE3 (in Database that name is Staging.)

i want to build the the Fact:

First way: is to create Execute SQL Task and write the query

INSERT INTO FACT
SELECT .....
FROM TABLE1 Join TABLE2 JOIN TABLE3

Second way is to create Data Flow Task and in ole db source to write the query:
SELECT ....
FROM TABLE1 Join TABLE2 JOIN TABLE3

in ole db destination i choose the fact

hat is the recommended way(sorry,but i cant succedd to add here a image)?

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-02-19 : 07:46:18

2 more questions:

how i make INSERT and DELETE and Update Statment in SSIS?

by Execute SQL Task or other component?

sakets_2000
Master Smack Fu Yak Hacker

1472 Posts

Posted - 2009-02-19 : 07:49:22

if its just a simple insert, use execute sql task. A data flow task is when you need to run extraction,transformations,loads etc.
And yes, Insert and Delete can be run using execute sql task.

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-02-19 : 08:00:09

1. it is not simple insert , i have join complicated with nested
query.
2.i asked about INSERT\DELETE\UPDATE etc' , if i have special
component for it ?
or the only way to use it,with Execute SQL Task

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-02-19 : 10:14:11

quote:
Originally posted by inbs

1. it is not simple insert , i have join complicated with nested
query.
2.i asked about INSERT\DELETE\UPDATE etc' , if i have special
component for it ?
or the only way to use it,with Execute SQL Task

you can use queries inside OLEDB command task or in execute sql task

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-02-20 : 09:31:29

i know that i can use it in inside OLEDB command task or in execute sql task.

my question is :have a special components for INSERT\DELETE\UPDATE in ssis?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-02-20 : 10:21:42

nope. no special components. didnt understand the purpose of asking this. can you please explain what problem you're facing with use of inserts,updates,..?

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-02-21 : 11:50:03

i havent a apecific problem, i just want to build it right.

until today i use INSERT in Execute SQL Task ,but i changed it and write in OLE DB Source(query).

i just want to know where use with UPDATE/DELETE .

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-02-21 : 12:24:36

What is your requirement? If you can explain clearly you can get answer fast and save your time as well.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-02-22 : 01:13:45

quote:
Originally posted by inbs

i havent a apecific problem, i just want to build it right.

until today i use INSERT in Execute SQL Task ,but i changed it and write in OLE DB Source(query).

i just want to know where use with UPDATE/DELETE .

you're still not clear with the problem. can you please explain the problem that you're facing?

inbs
Aged Yak Warrior

860 Posts

Posted - 2009-02-22 : 12:35:07

sorry ,but i really do not have any problem.
never mind
how can i add here a image?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources