Data Transformation Services (DTS)

• Topics

  Started by

  Posts

  Last post

• Data cleansing and Data filtering

  What is data cleansing and Data filtering and how can we do the data cleansing and Data filtering f…

  kommagoni

  3 replies

  1 year ago

  By: Zidar

• master.dbo.spt_values means?????????

  Hello friends!! Can anybody tell me 'The meaning of this output' I saw 6 columns , anybody tell me …

  Papillon

  11 replies

  1 year, 12 months ago

  By: Jeff Moden

• C:\Program Files (x86)\Microsoft SQL Server\150\DTS\Tasks folder

  I have installed Visual Studio Community 2019 and I'm collaborating with another employee but I do …

  HildaJ

  1 replies

  2 years, 3 months ago

  By: HildaJ

• vbs failing

  This vbscript for Excel that opens a pipe delimited file  is failing srccsvfile = Wscript.Argument…

  Sailor

  2 replies

  4 years, 3 months ago

  By: Sailor

• Using SSMA for DB2 data

  It was recommended to me that I use SSMA to migrate data over to SQL.  I was going to write a .Net…

  Brad Allison

  1 replies

  4 years, 11 months ago

  By: Brad Allison

• Cannot delete filename. There has been a sharing violation.

  I get the following message after a file has been locked by a long running job (which fired a DTS p…

  StefanJ

  9 replies

  4 years, 11 months ago

  By: Frank Jones

• Error 0xc020901c: Data Flow Task: While Importing data from an Excel File into SQL Server 2005

  While importing data from Excel file into a table in SQL Server 2005, i am getting the following er…

  priyap

  17 replies

  5 years, 3 months ago

  By: AirJrDan23

• Package runs on dev, fails on server

  I'm kind of new at this, so please bear with me. If I haven't included enough information, I'll be …

  Pete

  10 replies

  5 years, 4 months ago

  By: Pete

• dtexec delay validation true

  I have a SSIS package that loads a flat file.  It runs fine on my laptop but on my virtual machine…

  texpic

  1 replies

  5 years, 6 months ago

  By: texpic

• How are packages are run?

  Hi, Suppose the following situation: Server A is a sort of management server (no databases!) with o…

  michielbijnen

  1 replies

  5 years, 8 months ago

  By: Michael L John

• DTS Package Failed Step Error code: 80042008

  Hi Team , I have a DTS package which has failed with the below reason Step Error Description:Column…

  pradeep

  2 replies

  5 years, 9 months ago

  By: frederico_fonseca

• DTS and Type Mismatch error

  Any solutions to the DTS and Type Mismatch error (MS KB ref: Q310473). Microsoft says that it is an…

  khana

  4 replies

  6 years ago

  By: CGZ

• Getting RMS VAX Data into SQL Server

  I have a series of flat files sent over from a VAX that I need to import into sqlserver. These are …

  mrfleck

  5 replies

  6 years, 8 months ago

  By: lightfoot.anthony

• SSIS Package Help with , Delimiter File.

  Hi Guys, Need Help in SSIS Package to Pull the data from .CSV and load into SQL DB. Here is sample…

  rocky_498

  4 replies

  6 years, 10 months ago

  By: frederico_fonseca

• Cannot Open Database "xxx" requested by login. Login failed

  I created a DTS package using remote desktop to the server.  I'm logged in as me and I'm an ad…

  CJ-234774

  9 replies

  6 years, 10 months ago

  By: Rick-153145