<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Vinod Kumar
»
Introduction to DTS in SQL Server 2005
21 posts, Page 2 of 3
««
1
2
3
»»
Introduction to DTS in SQL Server 2005
Rate Topic
Display Mode
Topic Options
Author
Message
Greg Charles
Greg Charles
Posted Friday, February 01, 2008 10:41 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Today @ 9:28 AM
Points: 4,007,
Visits: 4,854
Heh, don't tell anyone, ;) but you can create a new DTS package in SSMS by opening an existing legacy DTS package and saving it with a new name. Then, open the new package and replace what's in it with whatever you want in the new package.
Greg
Post #450643
mtassin
mtassin
Posted Friday, February 01, 2008 10:45 AM
Hall of Fame
Group: General Forum Members
Last Login: Today @ 11:34 AM
Points: 3,229,
Visits: 64,267
Works great when you have one to open... some of us have made job transitions to SQL 2k5 only shops... :/
--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #450644
Tom Garth
Tom Garth
Posted Friday, February 01, 2008 1:43 PM
SSC Eights!
Group: General Forum Members
Last Login: Friday, February 04, 2011 7:20 AM
Points: 977,
Visits: 1,499
Maybe for a programmer SSIS is a big improvement over DTS, but for a normal user who just wants to dump the data from a table, it's overly complicated.
I am a Programmer, and have worked with VS for many years. My impression is no different than yours. 'Overly complicated' is a polite way of describing it. I'll keep using DTS for as long as it's supported.
Tom Garth
Tom Garth
Vertical Solutions
"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
Post #450754
Greg Charles
Greg Charles
Posted Monday, February 04, 2008 9:06 AM
SSCarpal Tunnel
Group: General Forum Members
Last Login: Today @ 9:28 AM
Points: 4,007,
Visits: 4,854
mtassin (2/1/2008)
Works great when you have one to open... some of us have made job transitions to SQL 2k5 only shops... :/
but I would like to occasionally make new DTS packages and not just edit old ones.
It sounded like you had old DTS packages.
Greg
Post #451199
Tom Garth
Tom Garth
Posted Monday, February 04, 2008 9:38 AM
SSC Eights!
Group: General Forum Members
Last Login: Friday, February 04, 2011 7:20 AM
Points: 977,
Visits: 1,499
mtassin (2/1/2008)
Works great when you have one to open... some of us have made job transitions to SQL 2k5 only shops... :/
Do you mean that you don't have access to a single SQL 2k instance? Then why don't you install one, complete with sample DBs, and create a couple of templates to work with?
Tom Garth
Tom Garth
Vertical Solutions
"There are three kinds of men. The one that learns by reading. The few who learn by observation. The rest of them have to pee on the electric fence for themselves." -- Will Rogers
Post #451223
Sreejithsql
Sreejithsql
Posted Monday, February 04, 2008 4:21 PM
Right there with Babe
Group: General Forum Members
Last Login: Saturday, August 25, 2012 9:48 PM
Points: 777,
Visits: 134
hi vinodh,
its really appreciatable work u done.nice presenatation.i like ur work well. like this any articles means pls present.
thx
sreejith
MCAD
Post #451389
Mayur-370463
Mayur-370463
Posted Thursday, February 07, 2008 10:57 PM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, June 15, 2010 9:15 AM
Points: 5,
Visits: 24
hi vinodh,
its really appreciatable work u done
Post #453072
SQLNewbie-610691
SQLNewbie-610691
Posted Saturday, March 01, 2008 11:36 AM
Forum Newbie
Group: General Forum Members
Last Login: Tuesday, October 26, 2010 11:27 AM
Points: 2,
Visits: 51
Hi Greg,
I read your comment and I would like to try it...
" create a new DTS package in SSMS by opening an existing legacy DTS package and saving it with a new name. Then, open the new package and replace what's in it with whatever you want in the new package."
We have an existing DTS package in SQLPRODUCTION , I would like copy and modify it to SQLTEST using SQL Server Management Studio. I downloaded Design-time Support for SQL Server 2000 DTS Packages.
I'm new in SQL Server 2005, can you tell me the steps on how to do this?
Thanks,
M
Post #462841
nico van niekerk
nico van niekerk
Posted Wednesday, September 10, 2008 4:13 PM
SSC Rookie
Group: General Forum Members
Last Login: Thursday, February 21, 2013 12:31 PM
Points: 31,
Visits: 98
Pity it was poorly written, had wrong references, skipped steps, and assumed that the reader knows all the missing steps.
Post #567351
StefanJ
StefanJ
Posted Tuesday, September 15, 2009 6:31 AM
Old Hand
Group: General Forum Members
Last Login: Wednesday, January 26, 2011 7:44 AM
Points: 339,
Visits: 11
First time I have used 2005. Trying to follow the article but am stuck at the first hurdle.
'Data Transformation Services' does not appear in my list of templates. See screen print.
Post Attachments
screen.JPG
(
1 view,
51.48 KB
)
Post #788092
« Prev Topic
|
Next Topic »
21 posts, Page 2 of 3
««
1
2
3
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
