Help with sql 2005 integration services.

Hi,
I want to be able to do a simple import from an excel spreadsheet i.e.
DTS, within SQL Server Management Studio. I have added two registered
servers, but I cannot register them to the integration services, so
that I can then do an import. is this correct or am I doing somethign
wrong? I have used SQL Server Business Intelligence Development
Studio, but surely there is a way to do it simply withing SSMS.
Appreciate any help on this.
Damon.You can do it pretty much the same way as with SQL 2000. Try right clicking
on the database name in SSMS, select Tasks, Import Data and go from there...
"nomad" <d.bedgood@.ntlworld.com> wrote in message
news:1171456545.592838.73050@.a75g2000cwd.googlegroups.com...
> Hi,
> I want to be able to do a simple import from an excel spreadsheet i.e.
> DTS, within SQL Server Management Studio. I have added two registered
> servers, but I cannot register them to the integration services, so
> that I can then do an import. is this correct or am I doing somethign
> wrong? I have used SQL Server Business Intelligence Development
> Studio, but surely there is a way to do it simply withing SSMS.
> Appreciate any help on this.
> Damon.
>|||There are a number of different ways to start the SSIS Import / Export
wizard. You can start it a couple of ways using the SQL Server Business
Intelligence Development Studio. Or you can start
it using the SQL Server Management Studio. Lastly, you can start it using an
executable.
Take a look into the below URL on using Improt/Export wizard in SQL 2005:-
http://www.databasejournal.com/feat...cle.php/3580216
Thanks
Hari
"nomad" <d.bedgood@.ntlworld.com> wrote in message
news:1171456545.592838.73050@.a75g2000cwd.googlegroups.com...
> Hi,
> I want to be able to do a simple import from an excel spreadsheet i.e.
> DTS, within SQL Server Management Studio. I have added two registered
> servers, but I cannot register them to the integration services, so
> that I can then do an import. is this correct or am I doing somethign
> wrong? I have used SQL Server Business Intelligence Development
> Studio, but surely there is a way to do it simply withing SSMS.
> Appreciate any help on this.
> Damon.
>|||On 14 Feb, 13:11, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:[vbcol=seagreen]
> There are a number of different ways to start the SSIS Import / Export
> wizard. You can start it a couple of ways using the SQL Server Business
> Intelligence Development Studio. Or you can start
> it using the SQL Server Management Studio. Lastly, you can start it using
an
> executable.
> Take a look into the below URL on using Improt/Export wizard in SQL 2005:-
> http://www.databasejournal.com/feat...cle.php/3580216
> Thanks
> Hari
> "nomad" <d.bedg...@.ntlworld.com> wrote in message
> news:1171456545.592838.73050@.a75g2000cwd.googlegroups.com...
>
>
>
>
Excellent, thanks very much. Fair play though, I should have checked
there.
Thanks again.
Damon

Help with sql 2005 integration services.

Hi,
I want to be able to do a simple import from an excel spreadsheet i.e.
DTS, within SQL Server Management Studio. I have added two registered
servers, but I cannot register them to the integration services, so
that I can then do an import. is this correct or am I doing somethign
wrong? I have used SQL Server Business Intelligence Development
Studio, but surely there is a way to do it simply withing SSMS.
Appreciate any help on this.
Damon.You can do it pretty much the same way as with SQL 2000. Try right clicking
on the database name in SSMS, select Tasks, Import Data and go from there...
"nomad" <d.bedgood@.ntlworld.com> wrote in message
news:1171456545.592838.73050@.a75g2000cwd.googlegroups.com...
> Hi,
> I want to be able to do a simple import from an excel spreadsheet i.e.
> DTS, within SQL Server Management Studio. I have added two registered
> servers, but I cannot register them to the integration services, so
> that I can then do an import. is this correct or am I doing somethign
> wrong? I have used SQL Server Business Intelligence Development
> Studio, but surely there is a way to do it simply withing SSMS.
> Appreciate any help on this.
> Damon.
>|||There are a number of different ways to start the SSIS Import / Export
wizard. You can start it a couple of ways using the SQL Server Business
Intelligence Development Studio. Or you can start
it using the SQL Server Management Studio. Lastly, you can start it using an
executable.
Take a look into the below URL on using Improt/Export wizard in SQL 2005:-
http://www.databasejournal.com/features/mssql/article.php/3580216
Thanks
Hari
"nomad" <d.bedgood@.ntlworld.com> wrote in message
news:1171456545.592838.73050@.a75g2000cwd.googlegroups.com...
> Hi,
> I want to be able to do a simple import from an excel spreadsheet i.e.
> DTS, within SQL Server Management Studio. I have added two registered
> servers, but I cannot register them to the integration services, so
> that I can then do an import. is this correct or am I doing somethign
> wrong? I have used SQL Server Business Intelligence Development
> Studio, but surely there is a way to do it simply withing SSMS.
> Appreciate any help on this.
> Damon.
>|||On 14 Feb, 13:11, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:
> There are a number of different ways to start the SSIS Import / Export
> wizard. You can start it a couple of ways using the SQL Server Business
> Intelligence Development Studio. Or you can start
> it using the SQL Server Management Studio. Lastly, you can start it using an
> executable.
> Take a look into the below URL on using Improt/Export wizard in SQL 2005:-
> http://www.databasejournal.com/features/mssql/article.php/3580216
> Thanks
> Hari
> "nomad" <d.bedg...@.ntlworld.com> wrote in message
> news:1171456545.592838.73050@.a75g2000cwd.googlegroups.com...
> > Hi,
> > I want to be able to do a simple import from an excel spreadsheet i.e.
> > DTS, within SQL Server Management Studio. I have added two registered
> > servers, but I cannot register them to the integration services, so
> > that I can then do an import. is this correct or am I doing somethign
> > wrong? I have used SQL Server Business Intelligence Development
> > Studio, but surely there is a way to do it simply withing SSMS.
> > Appreciate any help on this.
> > Damon.
Excellent, thanks very much. Fair play though, I should have checked
there.
Thanks again.
Damon

Help with Outer Joins

Hi. I'm using Microsoft Query to create a query for Excel 2003. I'm
attempting to create 3 Left Outer Joins, but upon doing so I receive the
error message "Query Can Have Only One Outer Join" as described here...
http://support.microsoft.com/defaul...14027#appliesto
After reading this article, I am under the impression that multiple Outer
Joins CAN indeed be created, only you must write the SQL code directly in
order to create them. That's were I'm lost. I'm not sure how to write the
necessary SQL code in order to join the 3 tables. Could someone please
assist me with the necessary code?
My tables are: tblOrder, Customer, tblSQFTByStation, and tblOrderDetail
tblOrder should be joined to the other 3 tables as follows...
FROM {oj `H:\Application_be`.tblOrder tblOrder LEFT OUTER JOIN
`H:\Application_be`.tblSQFTByStation tblSQFTByStation ON tblOrder.OrderID =
tblSQFTByStation.OrderID}
FROM {oj `H:\Application_be`.tblOrder tblOrder LEFT OUTER JOIN
`H:\Application_be`.Customer Customer ON tblOrder.CustomerID =
Customer.CustomerID}
FROM {oj `H:\Application_be`.tblOrder tblOrder LEFT OUTER JOIN
`H:\Application_be`.tblOrderDetail tblOrderDetail ON tblOrder.OrderID =
tblOrderDetail.OrderID}What you might be missing is that each join is not from 1 source to another,
it is from what you have so far to anothersource...
So (THis is probably wrong syntactically cause I don't know Exce
lsyntax...)tr this structure.
FROM oj `H:\Application_be`.tblOrder tblOrder
LEFT OUTER JOIN `H:\Application_be`.tblSQFTByStation tblSQFTByStation
ON tblOrder.OrderID = tblSQFTByStation.OrderID
LEFT OUTER JOIN `H:\Application_be`.Customer Customer
ON tblOrder.CustomerID = Customer.CustomerID
LEFT OUTER JOIN `H:\Application_be`.tblOrderDetail tblOrderDetail
ON tblOrder.OrderID = tblOrderDetail.OrderID
"MrMike" wrote:

> Hi. I'm using Microsoft Query to create a query for Excel 2003. I'm
> attempting to create 3 Left Outer Joins, but upon doing so I receive the
> error message "Query Can Have Only One Outer Join" as described here...
> http://support.microsoft.com/defaul...14027#appliesto
> After reading this article, I am under the impression that multiple Outer
> Joins CAN indeed be created, only you must write the SQL code directly in
> order to create them. That's were I'm lost. I'm not sure how to write th
e
> necessary SQL code in order to join the 3 tables. Could someone please
> assist me with the necessary code?
> My tables are: tblOrder, Customer, tblSQFTByStation, and tblOrderDetail
> tblOrder should be joined to the other 3 tables as follows...
> FROM {oj `H:\Application_be`.tblOrder tblOrder LEFT OUTER JOIN
> `H:\Application_be`.tblSQFTByStation tblSQFTByStation ON tblOrder.OrderID
=
> tblSQFTByStation.OrderID}
> FROM {oj `H:\Application_be`.tblOrder tblOrder LEFT OUTER JOIN
> `H:\Application_be`.Customer Customer ON tblOrder.CustomerID =
> Customer.CustomerID}
> FROM {oj `H:\Application_be`.tblOrder tblOrder LEFT OUTER JOIN
> `H:\Application_be`.tblOrderDetail tblOrderDetail ON tblOrder.OrderID =
> tblOrderDetail.OrderID}
>|||Thanks!
"CBretana" wrote:
> What you might be missing is that each join is not from 1 source to anothe
r,
> it is from what you have so far to anothersource...
> So (THis is probably wrong syntactically cause I don't know Exce
> lsyntax...)tr this structure.
> FROM oj `H:\Application_be`.tblOrder tblOrder
> LEFT OUTER JOIN `H:\Application_be`.tblSQFTByStation tblSQFTByStation
> ON tblOrder.OrderID = tblSQFTByStation.OrderID
> LEFT OUTER JOIN `H:\Application_be`.Customer Customer
> ON tblOrder.CustomerID = Customer.CustomerID
> LEFT OUTER JOIN `H:\Application_be`.tblOrderDetail tblOrderDetail
> ON tblOrder.OrderID = tblOrderDetail.OrderID
>
> "MrMike" wrote:
>