SQL-SERVER 2000 Hello - I want to import data from a paradox table. In this pdx table I found 2 fields: one for Date defined as pdx Date datatype and one for Time defines as pdx Time datatype. I cannot change that. I built a DTS - which fails on the Time field (defined as SmallDateTime in the SQ...more >>

hi all, I want to use ini files to store server details, but feel that storing server username and password in ini file is not secure. Any suggestions? regards, kshitij...more >>

I have a package that executes just fine when i select 'execute' When i go to schedule it, the corresponding job is created. But when i run the job, it fails. It says: "Cannot connect to the Analysis server on computer 'ENG1SQLV1'. Connection to the server is lost Error source: DSO" ...more >>

I have to move tables of aproxximately 15 million and 1 million records, would either replication or DTS able to do this for me? What would be the best practise to move this amount of data across the internet using dts/replication? Thanks in anticipation. Ajay ...more >>

I've created a DTS that gets data from a foxpro source into a SQLServer destination. The DTS runs perfectly fine through the Enterprise manager, and infact works fine on the command line, but when I try to initiate it through a Stored Proc (I use : EXEC @result = master.dbo.xp_cmdshell 'dtsr...more >>

I have a DTS bulk insert task that is behaving oddly. It runs and indicates that it ran successfully; however, upon examination of the data in query analyzer, it is clear that the data loaded fine BUT only 1194 of the 504,000 rows loaded. No error message or other messages are received. The ...more >>

How can I move a package from one server to another?...more >>

When I use the DTS wizard to import data into a SQL table only 3 out of 2050 records are imported and I get no error messages. When I select the SQL table of the same name with a $ on the end I can preview the first 100 records and the import seems to succeed and show 2050 records are importe...more >>

I don't want to change anything in my DTS when moving from DEV to UAT to PROD. So, I have an activeX script (see below) at the start of my DTS that looks for a DTS.ini file in the same folder, gets the path & then sets the SourceIniFileFileName. - this works fine when the DTS is executed with...more >>

How do I set the datasouce to dynamically change to the server it resides on?...more >>

How can I run a DTS package from a network client computer? When running, will the error messages show as it does when running in the SQL server enterprise manager? *** Sent via Developersdex http://www.developersdex.com ***...more >>

I have created several scheduled jobs a few update some tables while the rest are the Backups, made with the DB Maint. Plan Wizard. The ones that updated the tables will not work while I am sitting at my computer but they will if I am working on the server. I am using remote desktop when worki...more >>

is there a procedure for recovery of dts packages of a crashed server? I have a colleague who was developping a dts package on a test server off course, the inevitable happened without a backup at hand where can I find the DTS packages and how can I get them back PS: it was a diskcrash with ...more >>

I am trying to get into SSIS I am not a developer but a complete newbie, I want and need to bring together data from different sources for reporting services, score carding and anaysis services ect for our company I am managing to move data from a to b ok however this does not cover all the task...more >>

Hi, I'm trying to create a DTS package using a Transform Data Task using the following query: "Select field1, ? from Table1 ". I want to pass a parameter inside my select query so I can populate the destination with the parameter that I'm passing. Is it possible to pass a parameter inside...more >>

I am writing a DTS package that gets executed remotely. The remote exectution passes a value that populates the global variable of the main DTS package, MainVar1. There are several other variables in the package that are dependent on MainVar1 variable. What I am trying to do is concatina...more >>

sql2k sp3a Dont know if "invert" is the right word, but the only one I could come up with. I have a flat file that displays data like: GEN_PROREGCTCTXT CRZCODE S_GENERATION 1 CB 1 1 CS 1 That top row is data, not column names FYI...more >>

I have a simple workflow that executes three tasks and in the final task I have a success branch and a failure branch. The final task is a sql statement to delete rows in the table. I intentionally misspelled the column name and saved the package. My thought was it would go to the failure step...more >>

I'm trying to run a very simple DTS package using DTSRun command line but keep getting a cryptic error that has stumped everybody in-house on three continents. The DTS pacakge (really just a test) simply inserts one record in a table. The paraphrased command line is this: DTSrun -s MySQLServ...more >>

I have a Source and a Destination with the exact same structures. The information in the Source Table for a given Key (example Customer) replaces all of the information in the Destination Table for the Key. Is it more effective to create a task to delete all the records for the customer in...more >>

I am modifying a DTS package that had an existing ActiveX script. When I try to execute the DTS package, I get the following error when the package tries to execute the ActiveX script: "ActiveX scripting was not able to initialize the script engine" Why would this happen? Thank you, ...more >>

While using the SQLServer DTS package. If I use Datapump to insert data from text file to table into a single column will be faster or into a multiple columns will be faster. If I insert data into single column, then I need to write a sql script or procedure, use string operations to split th...more >>

Hi all, We've created a VB.NET application which runs a couple of DTS packages on a SQL Server in a specific order using ADO.NET. When we runs this application on the same machine that SQL Server resides on it works fine. However when we run the application on another machine in the domain ...more >>

Our data center recently backed my SQL server to install new hard drives. Upon restore I noticed that all my DTS's and Job's are missing. When I brought this to the Datacenters attention , they stated that all data was successfully restored from tape. They are no asking be for the file na...more >>

I'm using a SQL 2000 SP3 client on XP against a SQL 7 database. I'm trying to output a table to a CSV using a SQL Connection to a Destination Text File. Any table in my database that has records longer than a certain length will not allow me to execute the columns to create a new text file - ...more >>

Hi I have a problem with a dts on sql7. The dts runs every x hours and it worked find for months. Suddenly i get the ffw error: "Unspecified error. Too many fields specified". The error is displayed when started from enterprise manager,local packages. If the package is run from jobs, the ffw...more >>

Hi, I want to know if there is any way by which I can use a global variable having data type other than string which can let me store more than 4000 characters ie more than allowed in a string. It seems like string data type has length limitation (limited to 4000 chars). I want to use a ...more >>

I need to create a flat file, with no delimiters between columns. I tried using DTS, made a connection and a destination text file. I see no options to create the file without column delimiters , it asks for the options: comma, tab,etc. The file has to be with no fixed column width. How can I d...more >>

I'm trying to load an Excel spreadsheet into a SQL table. The trouble with the spreadsheet is that it has links that prompt the user on whether to update them or not. I worked around opening the spreadsheet with the Excel Application object by turning off interactive prompts and passing 0 to...more >>

Any viable way of how to automatically re-execute the failed package. That is, to re-execute it three times then exit if failed again? what steps and what will the code look like??? Thanks -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-dts/200...more >>

hi all, I'm re-posting my question here. it's seems more reasonable then posting it on the general forum. we are running a dts that migrates data from an as400 to sql 2K. the string data is hebrew (code page 1252). for that, we have been using a hit odbc: ODBC OPTIMIZED (READ ONLY) 32 BIT ...more >>

Hi, I'm running DTSs from a Windows Service developed with VS2003 (.Net 1.1.). I need to update some Global Variables values (in the same way I do with parameter /A of DTSRun.exe). Those Variables are String Variables. Those variables are used from a DynamicProperty Task to update the Output fi...more >>

Hi all, (Note: I originally posted this in the microsoft.public.dotnet.framework.interop newgroup, but got no response. Thought I'd try here.) I've created a .NET app that executes a DTS package. Everything works great if I pass the appropriate parameters to the application; if I purpose...more >>

Hello, I'm rather new in sqlserver and dts. I have to archiv old data from our main database to an archivdatabase (data older then a year). I build a dts package which shoud run following: Copy the needed tables to from database to archiv (runs without an error just the first time, I know). O...more >>

Hi All, I have some excel report files to be imported into SQL Server. - Files are in a local directory. - Need to pick year and month info from the file name and add as additional columns on the SQL Server table (Ex: ABC2005_T06.xls -> "2005" goes to year column and "06" goes to Term col...more >>

Hello, Is it true that Data Transformation Services (DTS) uses the Microsoft Jet Database Engine? I have a DBA that has set up a daily job that parses, slices/dices raw data using Microsoft Access and then DTS' it into SQL Server. It works and has worked without incident, but I'm just curi...more >>

Hi, I am trying to import a spreadsheet into MS SQL 2000 via a DTS packaget using Microsoft JET database engine, but it gives me an error saying " Workgroup information file is missing or opened exclusively by another user" This error only exists if i use an MS SQL login with a password b...more >>

Hello, Im new to VBScript and need to learn how to use it in SQL DTS packages. Any of you know of some good starting websites? Thanks. ...more >>

Hi I have a DTS that send mails through a DTSSendMailTask, so I need to execute the Package as a Domain User. The same package, before sends the email, executes a series of steps that ussualy takes 4-5 hours to completion (the mail has the "job successfully completed" message) The server...more >>

I have an execute SQL task that is running a stored proc that returns either a 1 or a 0.......which I have declared as a char. Here is the code I have in my execute SQL task. declare @Result char(1) exec usp_CheckFreeSpace @Result OUTPUT, ? select @Result as StagingSpaceResult I have th...more >>

Cannot start Dts designer. Every time I try to create a new package I get this message: Error in dll with the caption DTS Designer Error: CoCreateInstance. I am running SQL 7.0 SP4 with post security rollup. (Version 7.00.1094) Running on Windows 2000 Server, SP4 and all additional updates t...more >>

I'm running two transformation tasks in my DTS package that are using table variables. Basically, I am using two table variables to pre-filter my data before the final query (which cuts the execution time by 2/3). This works fine from Query Analyzer. However, when I put this code in a transfor...more >>

After backing up a SQL installation (all databases) and restoring to another machine (all databases) we can not find our DTS packages. Please help many thanks Stephen...more >>

I've been given a series of text files where all the fields are delimted by a vertical bar, but each row takes up two rows in the text file. So if I use any delimter like CR or LF etc., it treats each row like two rows, since each row just finishes with a vertical bar and then a return. Is th...more >>

I want to know if there is any other way to run a dts, like using a query, if yes plese let me know the query or where can the information...more >>

Hello I have managed to import a file within a DTS package into a table in my SQL server, however as a noobi this isn't quite what I want and now I have NO idea how to progress. What I want is to pick up random files, all same extension, same format data, process them into my database and the...more >>

Hi, I have many DTS packages created on a Server. I am now planning to shift the SQL Server Database on a new higher capacity server.I want all the packages those are there on the current server to be available on the new server. How can I achieve this? Can I generate scripts for these packag...more >>

Hello... A customer will be sending me several files each day and I want to try and write a DTS Package to loop through the files and process each one. I have figured out how to read through the contents of a folder/directory and look at each file, but how do I get to the next step and pr...more >>

How can I reference a custom assembly in a script task? All I can reference is assemblies in a static list. I can not browse for assemblies. Any ideas? Is it possible? Andreas :-) Note: I use VS.NET 2005 Beta 2 with SQL Server 2005 CTP. ...more >>

I am trying to transfer one SQL Server database into a new one. The old one supported nulls on every colum, and the new one, well, doesn't. In order to use DTS, do I have to make every transformation a ActiveX script that checks for nulls and uses the default value for the column if it fi...more >>

Maybe I should ask this question in another group, but since I'm using it for DTS... I don't know... I'm copying data from DB2 and the existing packages use ODBC for DB2. Should I switch to OLE DB? Is the performance better? Thanks...more >>

http://www.sqldts.com/default.aspx?104 This URL was extremely helpful, however I am having difficulties with the example provided. The example loops through the steps within the DTS Package to return the result of the steps in the DTS package. I have a conditional branch in the DTS package ...more >>

I have started receiving the following error whenever I try to open an existing DTS package or create a new one: The system cannot find the file specified. I can continue to open the DTS package, but the Task pane is completely empty. Hence, I cannot add-to or create any packages. I am runnin...more >>

Hi, I think the major issue when I import data from Excel, Text, or Access into the database on SQL Server, if the error occurs, I really cannot tell what record(s) is causing the error of the package. Is there anyway I can find out the bad record(s) casuing the error??? I used to check o...more >>

I am trying to read all excel files in a directory, and the code that opens the files is pasted below. When i run the code some excel spreadsheets open while others give me the error: "open method of workbooks class failed" I have narrowed the problem down to the fact that when i manually op...more >>

Hello. Below is the setup of our environment to run the DTS job. This setup will work numerous SQL Server 2000 machines, 2 Developer Editions, and 2 other Enterprise Editions. The only one it cannot run on is a Enterprise Edition box (our Production, bummer). We have tested on other edit...more >>

Hi, I need to pull data from an application server. I am using Transform data task. I want the Source server to be passed as a parameter. I know it can be done using Dynamic SQL and use of procedure. My source of Transform data task is a sql querry, which uses OLTP database as source. I c...more >>