DTS on SQL 2005 ?

[Screaming Eagles 101]

Hi,

I used to make DTS packages on the 'older' SQL server and then add it as a
Job on the SQL Server Agent
to copy data from the mainframe computer to SQL on a daily basis.
I think I have understood that this ain't the way to do it anymore in SQL
2005,
that something should be written in Visual Studio.net ? Is that what I
heared ?
Can anyone point me to a manual or something on how to do this ?
'sql server 2005 rookie...'

[Russell Fields]

Filip,

Actually, you can continue using the DTS packages as long as you install the
legacy support for DTS on your SQL Server 2005 server.
http://msdn.microsoft.com/en-us/library/ms143755(SQL.90).aspx

However, SSIS (SQL Server Integration Services) is the new thing that
replaces DTS. Microsoft has some video tutorials on using SSIS which can be
found here. These are listed under SQL Server 2008, but I do not know of any
significant changes from SQL Server 2005. (But check on that.)
http://msdn.microsoft.com/en-us/library/dd299421.aspx

A couple of useful sites are:
For DTS: http://www.sqldts.com/
For SSIS: http://www.sqlis.com/

RLF

Post by Screaming Eagles 101
Hi,
I used to make DTS packages on the 'older' SQL server and then add it as a
Job on the SQL Server Agent
to copy data from the mainframe computer to SQL on a daily basis.
I think I have understood that this ain't the way to do it anymore in SQL
2005,
that something should be written in Visual Studio.net ? Is that what I
heared ?
Can anyone point me to a manual or something on how to do this ?
'sql server 2005 rookie...'
--
Filip
http://www.ww2airborne.net/
Official Site of the 101st Airborne - 463rd PFA
skype: airborne463pfa-fiwi
[It's nice to be important, but it's more important to be nice!]
----------------------------------------------------------------

[Screaming Eagles 101]

THANKS, I use the packages still today but indeed I'll love to go "SSIS"...
:-)
--
Filip
http://www.ww2airborne.net/
Official Site of the 101st Airborne - 463rd PFA
skype: airborne463pfa-fiwi
[It's nice to be important, but it's more important to be nice!]
----------------------------------------------------------------

Post by Russell Fields
Filip,
Actually, you can continue using the DTS packages as long as you install
the legacy support for DTS on your SQL Server 2005 server.
http://msdn.microsoft.com/en-us/library/ms143755(SQL.90).aspx
However, SSIS (SQL Server Integration Services) is the new thing that
replaces DTS. Microsoft has some video tutorials on using SSIS which can
be found here. These are listed under SQL Server 2008, but I do not know
of any significant changes from SQL Server 2005. (But check on that.)
http://msdn.microsoft.com/en-us/library/dd299421.aspx
For DTS: http://www.sqldts.com/
For SSIS: http://www.sqlis.com/
RLF

Post by Screaming Eagles 101
Hi,
I used to make DTS packages on the 'older' SQL server and then add it as
a Job on the SQL Server Agent
to copy data from the mainframe computer to SQL on a daily basis.
I think I have understood that this ain't the way to do it anymore in SQL
2005,
that something should be written in Visual Studio.net ? Is that what I
heared ?
Can anyone point me to a manual or something on how to do this ?
'sql server 2005 rookie...'
--
Filip
http://www.ww2airborne.net/
Official Site of the 101st Airborne - 463rd PFA
skype: airborne463pfa-fiwi
[It's nice to be important, but it's more important to be nice!]
----------------------------------------------------------------