Is it possible to create a DTS package using Microsoft Sql server management studio

Is it possible to create a DTS package using microsoft sql server management studio. if yes? How can i do it.

Any help is appreciated.

Regards,

Karen

I'm not sure if it is possible to create a DTS package in SSMS but it is possible to edit and maintain existing DTS packages. The SQL Server 2000 DTS Designer Components are part of the 2005 Feature Pack.

http://www.microsoft.com/downloads/details.aspx?familyid=50b97994-8453-4998-8226-fa42ec403d17&displaylang=en

I would highly recommend using SSIS for any new development.

|||

Thanks a lot for your answer,

Cause i have couple of spread sheets which i need to import to database from a web based application, and i not sure as how can i import the values from the excel spread sheet to the database..

regards,

Karen

sql

Is it possible to call a DTS package in a stored procedure

Hi,

I wanted to know if i can a DTS package using a stored procedure and if yes how should i do it.

Regards,

Karen

You should be able to use XP_cmdshell or DTS run for this, Look at this link

http://www.databasejournal.com/features/mssql/article.php/1459181

Thanks

Raj

Is it any functions similar to "START WITH" and "CONNECT BY" in MS SQL?

Hi all,
I am looking for some functions which are used as "Start with" and "Connect
By" in Oracle. Please help! Thx a lot.
Regards,
ThomasHello, Thomas
If you are interested in recursive queries for processing a tree-like
data structure, you should take a look at CTE-s (Common Table
Expressions) and Recursive CTE-s in Books Online and other MSDN
articles:
http://msdn2.microsoft.com/en-us/library/ms175972.aspx
http://msdn.microsoft.com/msdnmag/issues/04/02/TSQLinYukon/#S7
Razvan|||Hi,
There is no equivalent of start with and connect by of oracle in sql
server,
got thorugh this links,
credit - vyaskn
http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm
Handling hierarchical data in Sql Server =>
http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm
Thanks,
Sree
Razvan Socol wrote:
> Hello, Thomas
> If you are interested in recursive queries for processing a tree-like
> data structure, you should take a look at CTE-s (Common Table
> Expressions) and Recursive CTE-s in Books Online and other MSDN
> articles:
> http://msdn2.microsoft.com/en-us/library/ms175972.aspx
> http://msdn.microsoft.com/msdnmag/issues/04/02/TSQLinYukon/#S7
> Razvan|||> There is no equivalent of start with and connect by of oracle in sql
> server,
> got thorugh this links,
This information has not been updated for SQL 2005. Did you not follow the
links Razvan posted? It is certainly possible to accomplish this using
CTEs.
--
Hope this helps.
Dan Guzman
SQL Server MVP
<gsreejith@.gmail.com> wrote in message
news:1138965840.226876.87400@.g49g2000cwa.googlegroups.com...
> Hi,
> There is no equivalent of start with and connect by of oracle in sql
> server,
> got thorugh this links,
> credit - vyaskn
> http://vyaskn.tripod.com/oracle_sql_server_differences_equivalents.htm
> Handling hierarchical data in Sql Server =>
> http://vyaskn.tripod.com/hierarchies_in_sql_server_databases.htm
> Thanks,
> Sree
>
> Razvan Socol wrote:
>> Hello, Thomas
>> If you are interested in recursive queries for processing a tree-like
>> data structure, you should take a look at CTE-s (Common Table
>> Expressions) and Recursive CTE-s in Books Online and other MSDN
>> articles:
>> http://msdn2.microsoft.com/en-us/library/ms175972.aspx
>> http://msdn.microsoft.com/msdnmag/issues/04/02/TSQLinYukon/#S7
>> Razvan
>|||So, Should explicitly say for Sql Server 2000... :)
I have not tried CTE yet
Anyway thanks for correcting.
Thanks,
Sree