Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to import multiple DTS packages?

Status
Not open for further replies.
Palooka

Palooka

Programmer
May 22, 2001
73
NO
I am currently upgrading a system from SQL Server 2000 to 2005. At this time migrating from DTS to SSIS is not an option.

Thanks to Nigel Rivett and his excellent Save-all-DTS-packages-to-files-script I now have all my 63 DTS packages saved as .DTS-files.

Now I am looking for an easy way to import them into SQL Server 2005. So far I have only been able to import them "manually" one at a time.

Does anyone know of a way to import them all at once, in one batch, or in some kind of automated process? Maybe through a script, or stored procedure?
 
Status
Not open for further replies.

Similar threads

SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
893
SashaBuilder3
SashaBuilder3
dgillz
  • Locked
  • Question
How to convert varchar to time? 2
Replies
1
Views
1K
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
Consolidate multiple rows into single row 1
Replies
4
Views
1K
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
2K
Chris Miller
Chris Miller
Cpreston
  • Locked
  • Question
How to add a Letter to datepart
Replies
5
Views
794
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top