Data Transformation Services (DTS)

• Topics

  Started by

  Posts

  Last post

• DTS Scheduling (from Oracle)

  I created a DTS package which get a data from Oracle database (on other server which not is in doma…

  zbyszek

  5 replies

  22 years ago

  By: philcart

• Importing from Access Error

  I am getting the following error when importing from Access Memo field 'Remarks' to SQL Field varch…

  StefanJ

  2 replies

  22 years ago

  By: StefanJ

• How do I get rid of unused connections

  How can I remove connections which I am no longer using. I have deleted them but they still appear …

  StefanJ

  4 replies

  22 years ago

  By: StefanJ

• Parameters in DTS - Urgent

  I have a package, in which I have a SQL task that queries an Oracle dB for two values it needs and …

  MegaDBA

  3 replies

  22 years ago

  By: MegaDBA

• DTS Scheduling

  Hi, I created a DTS package without using the wizard. The package imports data from the database to…

  abaig

  3 replies

  22 years ago

  By: philcart

• Where Is DTS Package Names Stored?

  In which DB and table can I find the package names? Master or MSDB Thanks

  mightyjoemad

  2 replies

  22 years ago

  By: Allen Cui-55137

• setting connections dynamically

  How do I change the database referred to in SQL Server connections for all called DTS packages In B…

  StefanJ

  3 replies

  22 years ago

  By: StefanJ

• Changing owner of DTS packages

  One of my clients wishes to take ownership of the packages I've developed for them. So I used Googl…

  Henrik Staun Poulsen

  5 replies

  22 years ago

  By: Henrik Staun Poulsen

• Temporary table in DTS

  Is it possible to create, then use, then delete a temporary table in DTS. How do I do this?

  StefanJ

  5 replies

  22 years ago

  By: philcart

• Stored Procedure.

  I have my stored Procedures written in SQL-Server. How can I convert all Stored Procedures to Oracl…

  d_hemdev

  1 replies

  22 years ago

  By: philcart

• problem in importing database

  I have been trying to import database from SQL 7 to SQL 2000 but when I tried it gives an error mes…

  dgurung

  2 replies

  22 years ago

  By: dgurung

• Create, Modify, Exec DTS

  Is there a way I can give my developers a way to create, edit and exec DTS pkg's w/out giving them …

  MegaDBA

  2 replies

  22 years ago

  By: MegaDBA

• Execute package task problem

  Hi all, I really hope someone can help me with this problem, anyway here goes: I've created several…

  Khaos

  4 replies

  22 years ago

  By: philcart

• Connection Types SQL7

  I've just created a dts class in vb to automate a lot of my flat file importing. I just used the s…

  Mike2265

  1 replies

  22 years ago

  By: Mike2265

• SQL Script output

  I have a pretty complex sql command (Script) in a DTS package. It has various prints in it. How c…

  Sailor

  2 replies

  22 years ago

  By: philcart