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.
| Author |
Topic |
|
miltongonsalves
Starting Member
3 Posts |
 Posted - 2007-05-03 : 11:00:21
|
| I created a DTS by right clicking and exporting the data to a file and I also saved the DTS package. Where will the DTS Package be saved in SQL 2005 in case if I have to do any modifications later.Thanks ! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-03 : 11:58:41
|
| you can't modify DTS packages in 2005. you have to use SSIS = Integration services to convert them or rewrite them.you can run DTS in legacy mode but that's it._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-03 : 12:53:13
|
| For SSIS package, you can save it in msdb or as file. Similar to sql2k's dts package. |
|
|
|
Lamprey
Master Smack Fu Yak Hacker
4614 Posts |
Posted - 2007-05-08 : 18:49:17
|
| DTS Packages are saved under: <database>/Management/Legacy/Data Transformation Services/If you need to edit a DTS Package look at Installing Design-time Support for SQL Server 2000 DTS Packages:[url]http://www.microsoft.com/downloads/details.aspx?familyid=df0ba5aa-b4bd-4705-aa0a-b477ba72a9cb&displaylang=en[/url] |
|
|
|
|
|
|
Where is the DTS Saved in 2005?