Data Transformation Services (DTS)

• Topics

  Started by

  Posts

  Last post

• Formatting Date (DTS ActiveX script)

  I am attempting to format the date to later include in the filename that the script creates. Howeve…

  TeraByteMe

  2 replies

  12 years, 10 months ago

  By: TeraByteMe

• Adding a column to a table at import (run) time.

  I have an SSIS package that I used to import excel data, I need to add a column to the table when I…

  DeanORenO

  1 replies

  12 years, 10 months ago

  By: Jack Corbett

• How to Convert from Varchar to Decimal

  I am asking to see what I am doing wrong. I am trying to Convert or Cast from Varchar to Decimal wh…

  Justin Doh

  7 replies

  12 years, 10 months ago

  By: UKGav

• Derived Column Transform using up to 6 OR Statements

  I have a derived column that I am trying transform based on a range. (lv <= "20") ? "1" : (lv &l…

  trinityr

  5 replies

  12 years, 11 months ago

  By: smecharrafie

• job failed while accessing dts package

  Hi, we have a job which runs on daily. the job had failed. Then we got the history details.. Could …

  balaji.ganga 68339

  4 replies

  12 years, 11 months ago

  By: smecharrafie

• View the DTS Package Logs on a SQL Server 2005 Instance

  I belive the answer is no but can I View the DTS Package Logs on a SQL Server 2005 Instance? Thank …

  Welsh Corgi

  2 replies

  13 years ago

  By: Welsh Corgi

• SQL server 7 repointing of destination

  Dear All, I am doing a repointing of the target table in SQL server to another ODBC destination. Th…

  someone83

  2 replies

  13 years ago

  By: SQLRNNR

• DTS Package fails when scheduled but runs when manually run

  Using SQL Server 2000 Data Transormation Services (DTS), I have created a package which imports dat…

  Chris Golla

  24 replies

  13 years, 1 month ago

  By: gangstead

• Importing multiple text files

  Hi I am fairly new to Sql server. I have a directory where i have all these text files D20080710.tx…

  ahmad-326642

  3 replies

  13 years, 2 months ago

  By: fox_0000_fox

• Import .DTS file into an SQL 2000 server

  I made changes to an Production DTS and need to import that dts file into prod system now with the …

  balasach82

  5 replies

  13 years, 2 months ago

  By: m9464546875

• Is it possible to get the package name,server name,username etc in dts package using tsql script

  Hi , We have around 450 dts packages. I need to findout what are all dts packages were connected in…

  balaji.ganga 68339

  1 replies

  13 years, 3 months ago

  By: Elliott Whitlow

• 2008 DTS question! stardds.dll File version: 2000.80.2151.0

  I'm unable to locate a copy of the stardds.dll File version: 2000.80.2151.0 so that I can edit DTS …

  mdduncan

  5 replies

  13 years, 3 months ago

  By: pcalabiao

• Problem in updating the global varibles through Activex script in DTS Package

  I have a dts package in Sql server 2000 which has three global variables in it. The script run as e…

  progzr

  1 replies

  13 years, 4 months ago

  By: progzr

• Urgent reply Preventing SSIS packages from running across servers when executed

  Hello, I am looking for a script or event handler that will prevent SSIS package I created from run…

  pespes009

  1 replies

  13 years, 4 months ago

  By: LutzM

• Accessing Dynamic Properties task Properties in Activex Script

  How can I get the values of Dynamic Properties task in a DTS package. I need to make decisions for …

  Pravin Nagarajan

  1 replies

  13 years, 4 months ago

  By: Leks