SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 estimate		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

funketekun
Constraint Violating Yak Guru

Australia
491 Posts
Posted - 04/30/2008 :  12:59:02  Show Profile  Visit funketekun's Homepage  Reply with Quote
how long does it take to convert a DTS package to ssis package?

visakh16
Very Important crosS Applying yaK Herder

India
48076 Posts
Posted - 04/30/2008 :  13:17:42  Show Profile  Reply with Quote
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.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35017 Posts
Posted - 04/30/2008 :  13:22:00  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29156 Posts
Posted - 04/30/2008 :  15:08:32  Show Profile  Visit SwePeso's Homepage  Reply with Quote
I would estimate a probability of 2.2342342 minutes.


E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7007 Posts
Posted - 04/30/2008 :  15:42:24  Show Profile  Reply with Quote
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
Go to Top of Page

rgombina
Constraint Violating Yak Guru

319 Posts
Posted - 04/30/2008 :  15:50:14  Show Profile  Reply with Quote
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."
Go to Top of Page

X002548
Not Just a Number

15586 Posts
Posted - 04/30/2008 :  16:31:02  Show Profile  Reply with Quote
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
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
35017 Posts
Posted - 04/30/2008 :  16:32:52  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7007 Posts
Posted - 04/30/2008 :  16:54:21  Show Profile  Reply with Quote
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
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
29156 Posts
Posted - 04/30/2008 :  19:06:24  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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"
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000