Solved

SQL 2005 - What has replaced DTS.

Posted on 2009-03-31
2
402 Views
Last Modified: 2012-05-06
Hi
I have a requirement to import files from an FTP site into SQL Server 2005. In the past I would have written something in Data Transformation Services. Can you please advise me on how to achieve something similar in SQL 2005?
What is the DTS replacement?
0
Comment
Question by:dfincham28
2 Comments
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 250 total points
ID: 24027332
in SQL 2005, it's calls SSIS (sql server integreation services).
0
 
LVL 29

Assisted Solution

by:QPR
QPR earned 250 total points
ID: 24027345
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
OPENDATASOURCE 8 36
Review MS SQL cluster diagram 9 81
How to run sql statements from SQLCMD or command line 2 55
SQL Restore Script - Syntax Error 8 92
Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

28 Experts available now in Live!

Get 1:1 Help Now