I have a package set up to export a single column in a table, this column is varchar(4096). The output from the package is a fixed width field of 4096. My goal is to export lines of various lengths (10, 200, 1500, 200). Is this possible? I have found many referenced to reading a variable leng...more >>

My process includes following processes for various clients. - loading excel file into a sql database - Processing loaded data in sql tables - Dumping excel reports I implemented these three stages by using set of physical temporary sql tables (not the memory ones with # and ##) for data tran...more >>

I have a db with a number of Foreign Keys (all with the Check Constraints UNCHECKED) When I run my DTS package it seems to be ignoring this and checking the constraints. How can I disable this when the FK is created from my DTS package ? -- Michael Tissington http://www.oaklodge.com ...more >>

Hi all, I am successfully executing a DTS package from a VB app on the development workstation, but having issues when trying to execute from another client workstation... The DTS connects to an .xls table, drops an existing SQLServer2000 table, creates a new (copy) SQL table, then fina...more >>

Hi, I have a DTS that checks to see if a file exists. The first ActiveX Script doe sthe initial check, and if not found reports failure. On failure of that task, I have a Execute SQL Task to wait 15 minutes, which then on completion runs a second ActiveX Script to set the first Script b...more >>

I am trying to use ActiveX to skip some steps if a file is not present. The code works fine in DTS Designer, but fails when I run it as a scheduled job. I get this error from the job history. DTSRun OnStart: DTSStep_DTSActiveScriptTask_3 DTSRun OnFinish: DTSStep_DTSActiveScriptTask_3 DT...more >>

Hi I need to execute DTS packages from a workstation within our LAN, and the prefered method is by using a cmd file that executes dtsrun.exe. How can I install the DTSrun.exe appllication on a workstation without installing all the client tools, such as Enterprise manager, Query Analyzer, ...more >>

Greetings, Environment: Sql Server 2005 June CTP / Win2003 Server Disclaimer: I'm VERY BEGINNER sql server & totally uninitiated / unwashed when it comes to DTS / SSIS Challenge: I have 18 delimited flat files that I want to import into 18 matching Sql Server 2005 tables on a nightly...more >>

Hi Here is my Problem definition: I need to have capability to - import excel file with dynamic number of columns to sql server table - export to excel file from a sql table with dynamic number of columns. Basically i need to dynamically read and write excel metadata. Looking for a vbsc...more >>

I have a DTS package which exports data from SQL(2000 sp4) to Access 2000 all toll their are 40 Transform Data Tasks (each representing a table). 39 of the 40 work perfectly the last one executes but does not send any data or give any errors. I am using a Global Variable (the same one for each...more >>

Hi I have a dts package that connects to an oracle database and an MSSQL database and moves some data from the MSSQL dbase to the Oracle dbase. I need to move the package to a different server that is not connected via a network. Just wondering if the dts package can be copied onto media (li...more >>

Im new to this and am having trouble with something that Im sure is simple. I am trying to Append data from one table in a Sql Server to anouther table in anouther Sql Server. I know how to export or Import a whole table but I just want to append some data to an existing table. Both Servers a...more >>

Buongiorno a tutti, ho un DTS che contiene tra le altre cose un "Execute SQL Task" che lancia una SP. All'interno della SP (abbastanza articolata) c'=E8 un cursore che ogni volta che fa un loop, per ragioni che non sto a spiegare, fa una select con un codice di processo. La procedure lanci...more >>

Hi NG We have a VB6 ActiveX DLL which we use from an ActiveX script in a DLL Set Obj = CreateObject("Library.Class") Obj.DoSomething Set Obj = Nothing We now have a new .Net Library that we would like to access in the same manner. Unfortunately we get an "ActiveX componen...more >>

Hi! I have written a SSIS data destination. There two extra columns "ErrorCode" and "ErrorColumn" are availible. I can get the description of the error using followig statement: String errorDesc = ComponentMetaData.GetErrorDescription(Convert.ToInt32(buffer[ci.bufferIndex])).Trim(); // w...more >>

Hi, I'm "playing" around with SSIS and try to solve the following problem. I've an import folder which is filled with CSV - files from a legacy app. There can be up to 50 files in this folder. e.g. customer file, vehicle file and the corresponding parameter files. That means the structure...more >>

I want to skip the last n records which could be last 3 or 4 records. How can I do this. Thanks Karen ...more >>

I have a loop that reads a text file and then archives it. I currently have it skip the first line of the text file because the first line contains summary information. But I would like the summary information to be included in each line that I pull from the rest of the text file. So I ...more >>

I have a tab delimited text file and I am trying to load that into a table with a real data type. Appears when it finds a value like 22,579.59 the load fails that cannot convert to real. Thanks Karen ...more >>

Hello- I am attempting to transfer stored procedures from a dev database to a production database. Using the DTS Import/Export Wizard, I select "Copy objects and data between SQL Server databases." On the select objects to copy dialog, I deselect copy data and copy all objects. Using t...more >>

Hi all, I am trying to run a DTS package from a Batcch file. I coded the batch file as follows: dtsrun /s sqlserver /e /n "currents_import" /U Acctname /P password pause The username and password are the same as the owner of the package. Does it matter the user is not logged onto her mac...more >>

Hi, I have a DTS package which I am using to upload around 10,000 rows (using a DTS Transfer Objects Task). Our Internet connection only provides upload speeds of around 10 kb/s so this process can take quite some time. This is not the problem, however, the problem is that our Intenet connect...more >>

I've got some big flat files that need to go into a relational database. Some heavy scrubbing needs to be done for removal of duplicates, generation of keys, transformation of data values. It looks like I will be able to process some of the data in parallel to speed things up a bit. I'm wonder...more >>

I am using DTS on SQL Server 2000 SP4 to get ~100K rows from an Oracle 9i db, it is slow. Anyone know of any articles with info on how to optimize Oracle to SQL DTS ? ...more >>

i am exporting a table from sql server to excel 2003, using dts package. I want excel sheet should take same field format as in table. But when i specify the excel file name its takes all fields as varchar. is there any way to it ...more >>

Hey.. Does anyone have a solution for the following running 2000: I have a DTS package (package 'A')that in some cases is calling another package (package 'B'). When package A is ready to call package B, all is well. Now I go ahead and modify package B to my liking, and resave it. Thus, as we ...more >>

Does anyone know how to stop a developer from creating a DTS package and/or a SQL Server Agent Job?...more >>

Hi ALL, When i am passing global parameters for sql query (subquery) in Transform Data Task getting error For Example : SELECT * FROM (SELECT * FROM Txn WHERE Dt_Changed_Date > ? AND Txn.ParentTxnID IS NULL ) as T Error Source : Microsoft OLEDB Provider for Sql Server ...more >>

I have the following keys in Consumption: - Plant - Material - Month - Year The above are the primary keys in the table and the following are non-key fields: - Quantity - Amount I have data stored in this table currently but many times I get feeds which are stored in the table: ...more >>

There is a server here running Windows 2000 and SQL Server 7.0 Now, someone accidentally installed SQL Server 2000 Developer tools onto that server and now no DTS packages can be viewed, created or run from that machine. This has been a problem that has left everyone here stumped for qui...more >>

Hi, I am trying to work out how to pass parameters from an execute process task to a vb .exe and then return a code so that the package knows if that step worked. Everything I have found so far is geared towards executing packages from within VB and we want to execute a vb app from the DTS ...more >>

I work in DTS Package and this DTS insert fileds from TXT file into any table. I need control with ON ERROR RESUME NEXT the error "Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object <table">. Because i can't. Somebody help me plissss! Thank's LML ...more >>

IN BCP, is there a way to send out email notices when errors occur? ...more >>

Seeking example of DTS script to consume a csv file, rename & copy it to an imported folder. TIA JeffP.... ...more >>

Hello I created a DTS Package in my machine it runs fine on my machine (local). bt when i set up a job (to run on server) i get an error message. also when i try to open the dts package on the server i also get an error. if i open the package and try to click on the transfrom data task between...more >>

Sorry if this is inappropriate in DTS ... this was the closest I could find for 2005 and SSIS. I'm trying to create a single, all-purpose SSIS package that would move data from a source database table to a matching target database table. The requirement is to create the package such that t...more >>

I have a table that has about 250 fields in it, many with text fields where the sum of bytes for all fields is about 6000. This table is in SQL Server. I have tried to use DTS to copy this table to Access, but it seem I lose some of the data in the last field. Is this possible, or is ther...more >>

Hello, I try to import the data below from a text file using the SQL Server 2005 import wizard with a "Flat File Source" and receive the error "SQL Server Import and Export Wizard / The preview sample contains embedded text qualifiers ("). The flat file parser does not support embedding tex...more >>

Hi All, I have a DTS package that 1) Goes to an FTP site, 2) Copied a file to a directory, 3) Loads the file into a sql database. 4) renames the file and saves it to a different directory.... Background : Each time the DTS package copies a 0 byte file, the load fails..OK no problem. But ...more >>

First I am trying to use DTS for purging data. The first thing I want to do is export the data to be purged to a csv file. I am using parameters to hold variables such as dates. The export routines work using transform data task using the following query: select sub.* from proddta.f3102 ...more >>

I need to locate all date fields in all tables ... could that be done using some of this - or something else...? http://www.windowsitpro.com/Article/ArticleID/22265/22265.html ...more >>

Ei, i'm new using DTS is there someone who could provide me VB Script tutorial? I don't have any skill in VB script and i would like to get some.. Thanks in advance. ...more >>

I need to create a text file from data in sql server, then ftp the file to a UNIX server on the same network. Creating the text file is no problem, but when it comes to the FTP I'm stuck. Does anyone know if it's even possible to ftp to UNIX via DTS? thanks, Rebecca...more >>

One of our former DBA's made some jobs with DTS-packages but I can't find the source for the packages. When I open the jobs I see DTS Run /~Z and a bunch of numbers and letters. But where can I find the actual source of the DTS-packages so I can edit them? Regards...more >>

I was just wondering of a good method of releasing a DTS from a test server to Production. Are there any tried & tested methodologies for doing this? Bearing in mind that the connection properties will need to be amended in some cases, and any File related issues (e.g. file existing on users...more >>

hi ! i have this VERY weird DTS problem with csv. everything works fine until a certain record was entered in the data. for example, the new member was C and C have records c1,c2,c3,c4,c5 together with all the records of B (b1,b2,b3) and A(a1,a2,a3). c5 having the last row in the csv ...more >>

hi : How to set up password for existing DTS? thx nick ...more >>