Data Transformation Services (DTS)

• Topics

  Started by

  Posts

  Last post

• Question about flat file source connection in DTS packages

  Hello all, So I've been tasked with doing a total conversion of the main bulk of dts packages that …

  Resender

  1 replies

  11 years, 2 months ago

  By: Koen Verbeeck

• Can Some One tell me,How One Can Use Expressions IN FTP TASK?

  How One can use expressions in an FTP TASK. Is FTP TASK connection can be created via expression ?

  harsimranjeetsinghwasson

  4 replies

  11 years, 2 months ago

  By: Koen Verbeeck

• using single DFT can we load multiple excel files into table.

  Hi All, My Name is vivek,i have few doubts below any one know to how to resolve please let me know.…

  viveksvkola

  1 replies

  11 years, 5 months ago

  By: Koen Verbeeck

• Compact an Access Database from DTS

  Does anyone have any ideas on how to Compact & repair an Access datbase within a DTS package?? …

  Peter Williams

  7 replies

  11 years, 7 months ago

  By: SQL Terminator

• Error Importing from Oracle

  I'm trying to use SSIS to import tables from an Oracle DB. The Import Wizard can connect to the Or…

  Mark Harley

  4 replies

  11 years, 8 months ago

  By: Mark Harley

• How do I preserve legacy DTS packages in sql 2005 after uninstall/install

  Hi I have to uninstall sql server 2005 enterprise edition and then install sql server 2005 standard…

  jdbrown239

  2 replies

  11 years, 11 months ago

  By: jdbrown239

• Automate DTS Column Mapping during import

  I created a DTS package that imports a flat file with 10 columns.... on occasion some of the other …

  AVB

  2 replies

  11 years, 11 months ago

  By: AVB

• Getting the name of a file in a location when the file name changes using DTS

  To all, Using SQL 2000 DTS. I have an Excel connection named "FileToProcess". I have a global varia…

  GF

  1 replies

  11 years, 11 months ago

  By: AVB

• trying to insert several csv files into a db table using a ssis package

  I have several .csv files and i'm trying to insert them into a database table. all my files are sav…

  mrichardson 57577

  7 replies

  12 years, 1 month ago

  By: Ant-Green

• Open source SSIS decompiler - work in progress

  Hi all, A while back I started an experimental project to see if I could analyze the DTSX file form…

  theodorespence

  1 replies

  12 years, 1 month ago

  By: theodorespence

• DTS Package fails with error - Invalid OLEVERB structure

  Dear All,   I have a DTS Package that transfers SQL database objects (Tables & Constraints…

  suresh_yaram

  9 replies

  12 years, 1 month ago

  By: Gary Nease

• OnTaskEvent Handler System variable - ExecutionValue not working in Execute task expression

  Hi I am using the custom logging with the use of Execute SQL Tasks (through SQL Source property and…

  superstar6778324

  2 replies

  12 years, 2 months ago

  By: superstar6778324

• DTS package executing for Long time in SQL server 2005

  Hi All, i'm working in SQL server Management Studio 2005 as a application support member, which hol…

  taroboyy

  1 replies

  12 years, 2 months ago

  By: herladygeekedness

• Crystal Report run through DTS

  Hi, I just run crystal report daily without any parameter and after run, save the file in c:\temp d…

  petersobeco

  11 replies

  12 years, 2 months ago

  By: remo 57808

• SSIS 2008 possible truncation/loss of data???

  My column is of type bit in a sql server 2008 database. My sql query has a case statement which rea…

  MissyDaisy

  1 replies

  12 years, 4 months ago

  By: MissyDaisy