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.
| Author |
Topic |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2008-11-30 : 01:55:40
|
| if i have some tables and i want to make query to be in a view,instead create view in managment studio,i want to do it by ssis,how i can do it?for example :CREATE VIEW SampleVSELECT T1.a,T2,bFROM T1 Join T2 On T1.a=T2.aThanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-30 : 02:20:40
|
| create view from ssis? why do you want to do that? so you drop it each time after run? else it will cause error for sunsequent running of ssis |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2008-11-30 : 02:59:32
|
| i want to create a query,but do not save it in a table.and it a basis for report in Reporting service. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-30 : 03:03:47
|
quote:
Originally posted by inbs
i want to create a query,but do not save it in a table.and it a basis for report in Reporting service.
then why use ssis? cant you just use query in data tab of reporting services to create dataset. |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2008-11-30 : 04:02:59
|
| i do not know RS,but i need to create this query.the simple is to create the view.but i thought that i have another alternative for VIEW in ssis. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-30 : 06:45:41
|
quote:
Originally posted by inbs
i do not know RS,but i need to create this query.the simple is to create the view.but i thought that i have another alternative for VIEW in ssis.
ok even in that case why choose ssis for that? you can strainghtaway create view using CREATE VIEW t-sql statement and use it in reporting services dataset. |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2008-11-30 : 08:07:14
|
| as i say, i do it in t-sql statement .i think that have another option to do that.thanks anyway. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-30 : 11:53:36
|
| ok thats fine |
|
|
|
|
|
|
view in ssis?