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!]
----------------------------------------------------------------

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/libr...5(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

" Screaming Eagles 101" <see_my_site (AT) online (DOT) please> wrote

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!]
----------------------------------------------------------------
news:ObAdwUAAKHA.4336 (AT) TK2MSFTNGP04 (DOT) phx.gbl...