I ahve created a DTS package & was able to execute it from backend but while trying to execute DTS Package created in local Packages in sql client gets error. Error Number 2147287038T Error Description :The system cannot find the file specified. package Name :FSPETLISASUpload_DevSer...more >>

Can anyone help with handling nulls or blank data being imported from foxpro ..dbf files into a normalized sql database? The data insert tasks are failing because the normalization in sql server requires a value in the incoming data, where this data was optional. Thanks in advance... Frango ...more >>

We have a big DTS package that runs nightly via SQLAgent and uses several global variables. The programmer changes them via script throughout the process and assumed that the changes would be retained the next time the package was executed. Of course the programmer has now left the firm. In in...more >>

When I attempt to use a user defined stored procedure for the source of a Transform Data Task or DDQ task I get an error message that states that no rowset in returned from the stored procedure. I need to use a declared table to remove invalid rows before processing. here's how I created the s...more >>

Newby (power user) at the controls here. I am trying to set up a job that will import data from an IBM AS400 system using DTS & Sql Agent. Our DBA cannot seem to find the problem or will not figure it out. I work on a remote workstation. Not directly on the server. I can schedule and...more >>

hi, I get errors while executing BulkExport via store procedure , xp_cmdshell. Below are some error messages, DTSRun OnError: BulkExport_P_Step, Error = 440 (1B8) Error string: Automation error I also execute the same package in DOS command, and it works. I have BulkExport executed on m...more >>

Iam a newbie...i'll really appreciate if somebody can provide a solution with code examples... I have a situation like this... I get my data in a text files (tab delimited) an then using DTS I need to populate a SQL server 2000 database. The question is: How can I split a source row of data a...more >>

Hi, I have just upgraded my SQL to service pack 3, a bit behind schedule but i seem to remember that there was a reason for it... I now remember. After upgrading when i try to change or create a new CSV destination file in DTS it bombs out when i get to "define columns " for the destinati...more >>

Attempting to import from an ascii file I'm receiving the following error Too many columns found in the current row; non-whitespace The problem is that I examined seeveral of the lines reported as bad and there is nothing wrong with them. The original ascii file size is 77mb and 163169 r...more >>

Folks, I have a piece of code that looks something like: On Error Resume Next ' Instantiate objects for the text and sql connections set objPkg = DTSGlobalVariables.Parent set objtxtConn = objPkg.Connections("txtConn") If Err.Number <> 0 then ... The code works fine. I just want...more >>

I'm rather new to DTS and have the following questions: 1) i need to develop (a) DTS packages that transfers data from an Oracle (8.1) database to SQL Server 2000 db. However the user should have the possibility to select the tables in the Oracle db that he wants to transfer/trasform to the...more >>

Is it possible to do an INNER JOIN using OPENDATASOURCE as a "table"? ...more >>

Is there a way to maintain table structure via DTS? ...more >>

Is there an ODBC or OLEDB driver for System 36? I want to import some data from an IBM System 36 data source into SQL Server. Thanks. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

Hi, I have an excel workbook that uses DTS via VBA Script and Referencing. It executes an external process and then does some datapumping from a text file to an access table and thats about it The code runs fine on a machine with SQL Server 2000 installed (happens to be Win 2000 Pro SP 2)...more >>

Howdy, First of all thanks in advance, I'm runnig SQL 2000 from my desktop I've created a table that I use for reporting purposes sysfact_temp. This table is created via a series of SQL statements. Once created, there are around 15000 rows and 20 fields. The second ].[dbo].[CXMSShip_Fact Vi...more >>

Hi Folks, I am trying to use FTP task in DTS, when I try to select the internet site for source and provide an ftp site on my local system and try to move to next tab I get the following error message: "unable to connect to internet! please check the source site information, your username ...more >>

Hello, I have been asked to produce a regular extract from an SQL Server and that the extract contain a Header Record and a Trailer Record, consisting of several fields. Does anyone know of a way to do this in SQL Server (DTS)? Thanks in advance. Brent...more >>

Hi, I’m using DTS to transfer data between 2 sql server 2000 databases. In one of the old tables there is a Boolean field (blnContactable) which stores true or false values. The new table equivalent has an integer field (intContactable) which stores values between 1 and 5. How do I ma...more >>

I am in a situation where I have to copy an entire database(not only data but alos storedprocedures etc like restoring a database) from one server to another server from time to time. I could archive by creating a backup file from one server, copy that to the another server and then restore a da...more >>

My objective is to copy sprocs created on my desktop to a remote database. Both servers are registered in DTS. I have created a DTS package. When run it displays the message "successfully completed execution of package". However, none of the stored procedures are actually copied to the remote...more >>

On a remote server we have to instances of MSSQL Server 2000, one of them being the default (local) the other has the name SN/EL4E, where SN is the name of the server. In Enterprise Manager on my desktop I have a Server Registration for (local) having as name the IP address of the remote server....more >>

Hello, Is it possible to create a DTS package through simple SQL source in Query Analyzer? We create a new project every month and I run an .sql file I create in Query Analyzer which creates stored procedures, views and imports tables in to the new database from the previous month. I set up...more >>

Situation: Development uses MSSQL for the application. The demo application CD uses MSDE and needs to ship with data that came from the developments MSSQL server. What I've tried: I can just copy and mount the MDF and LDF files, and mount them on the MSDE system. However the only one that ...more >>

I created a simple transform using SQL Query with (very roughly sampled) the query below. Basically I use a temp table, and am outputting the results to a text file - not too difficult. However, I need to make an amendment to the SQL Query but now when I click on the "Transformations" tabl...more >>

Hello, I do not know much about DTS global variables and I cannot use global variables references ("?") in some DTS exec sql tasks : For example : DECLARE @var INT SET @var = ? [...] (quite long script) does not work: I guess "SET ... = ?" is not allowed but what is the workaroun...more >>

Hi, I have 3 cubes based of data from a web site. Of the data, there is "Contact" and "Customer" info [end other :)]. If a new "Contact" is added, I'd be able to get all NEW records by checking on the creation date of the entry. But If a "Contact" was modified, how would I transfer t...more >>

Hi All I am running out in a problem laid before me.... In of the modules of my web Application, I have the requirment of sending email via DTS Consuming the data thru webservices rather direct Stored Proc... Steps: 1.Write A DTS SQL server job 2.Invoke a stored proc thru webservices .......more >>

Hi All, I currently have a DTS package that imports records from a text file into a table. However, occasionally the text file has duplicate records in it. When this occurs, the DTS package will fail and due to primary key constraints on the table. To solve the problem, I need to go into the...more >>

Hi, I have specific request here: I need to copy large database from one server to another. It has 700GB. Most of it are indexes (500GB). Because of time restrictions, I plan to use DTS export to copy ONLY TABLES from this database (I will create indexes on destination server afterwards)....more >>

I would like to create ASCII format text file in DST. Is there a way to do that? What I want is to select some records from my table then create text file (.txt) and save that file to Shared Network Drive. Is that possible? Thanks ...more >>

Hello, I have problems with XP Sp2: After Windows XP Sp2 was installed, no tested database can successfully be transformed. If I deinstall SP2, the databases can be transformed. The tables are transformed with "Copy Columns" from a database into another empty atabase on the same server. W...more >>

Hi is there an easy way to getNo of rows transformed by datapump into a DTS Global variable (ie giRowstransformed) I think this workaround is rather inefficient What Im doing at the moment is using an Execute SQL task after the datapump task has finished Execute SQL task : On success workflow...more >>

I have a simple DTS Package that truncates a table and then imports records from an Access database into the table. I am connectiong to the Access db using the Admin user. The package works when manually run. But when I schedule it as a Job, I get an error stating that the Jet Db Engine can...more >>

Hi, All. Is there a way to un-encrypt a command that was generated when a DTS package was scheduled and now is stored in a job? I am simply trying to figure out what packages all jobs are runnning... Is there a way to turn off the encryption for DTS package scheduling (not from dtsrunui). ...more >>

We're going to get back a file with row-types stored in the first 3 characters of each row. That will determine the data layout for each row. The rows vary in length. Will the "Read File" transform allow me to import the data row by row into SQL so I can then work on the various sets of data...more >>

I'm trying to set up a DTS package between SQL 2000 (sp3a) and MySQL v. 4.0.20a. I've installed both MyOLEDB3 and MyODBC on the SQL 2000 server and can make a connection to MySQL just fine using both. The problem is whenever I try to execute a SQL Task, I recieve the error "Provider does not ...more >>

I don't see the Data Transformation Services node in the Management Studio Object Explorer. Has it been removed? I can play with DTS in the BI studio. Bill...more >>

I'm attempting to import a table from Access to Sql Server using the Data Transform Task, however i'm unsure how to first clear the destination table of data. I'd rather not use a Execute Sql Task because of the number of tables involved. Is it possible to use some feature of the Data Transfor...more >>

Running MS SQL Server Personal. In the properties for the local server group, Database Settings, I have D:\MS SQL Server\Data\ set for the data and log files. If I create new db in EM, the files go to the above directory. If I do a create db in QA, the files go to the above directory. However, if...more >>

Hi there.. I've already installed SQL 2000 on my Win 2003 Server.. Is it possible to add the DTS Option later on? Or are there any other ways to install the dts-runtime? thx...more >>

Hi, I have a DTS that is run once a day, however recently it was accidentally run twice at the same time. Is there a way to stop a DTS from being executed simultaneously by two different people? Thanks ...more >>