estimate - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

estimate

Author

Topic

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2008-04-30 : 12:59:02

how long does it take to convert a DTS package to ssis package?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-04-30 : 13:17:42

quote:
Originally posted by funketekun

how long does it take to convert a DTS package to ssis package?

Depends on all these
1. Complexity of DTS package
2. Whether its using tasks that are easily migratable to SSIS
3. The expertise of person in DTS/SSIS who is doing this convertion.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-04-30 : 13:22:00

This can not be estimated without seeing the package.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-04-30 : 15:08:32

I would estimate a probability of 2.2342342 minutes.

E 12°55'05.25"
N 56°04'39.16"

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2008-04-30 : 15:42:24

quote:
Originally posted by Peso

I would estimate a probability of 2.2342342 minutes.

E 12°55'05.25"
N 56°04'39.16"

That isn't that helpful unless you include a confidence interval.

CODO ERGO SUM

rgombina
Constraint Violating Yak Guru

319 Posts

Posted - 2008-04-30 : 15:50:14

I'd say "Forget it boss, it's not going to happen. It's too much work! Just leave DTS alone. It ain't broken."

X002548
Not Just a Number

15586 Posts

Posted - 2008-04-30 : 16:31:02

quote:
Originally posted by rgombina

I'd say "Forget it boss, it's not going to happen. It's too much work! Just leave DTS alone. It ain't broken."

Sorry, there is no DTS in 2k5

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-04-30 : 16:32:52

Actually you can run DTS packages in SQL Server 2005, you just can't modify them.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2008-04-30 : 16:54:21

I believe that there is a DTS to SSIS conversion built into the SQL Server Business Intelligence Development Studio.

I think there are some interesting gotchas involved, but I am sure you will bea able to deal with those.

CODO ERGO SUM

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-04-30 : 19:06:24

If you install the Compatibility pack, you can even edit and save DTS packages in SQL Server 2005.

E 12°55'05.25"
N 56°04'39.16"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources