I would like to query the destination table for the MAX(datetime) and MAX(time) values and use those results in the SQL statement for the datapump so that I only import the records since the last DTS package was run. I am a relative novice to SQL Server but have some programming background - how ...more >>

Hi How do you move DTS packages from one server to another? Thanks Ginny...more >>

Subject says it all. I'm trying to schedule a daily DTS job, but I don't want it to run Saturday or Sunday. Any way I can tweak it in Management:Jobs in Enterprise Manager? Or can I write a batch file to run on Monday - Friday? Any suggestions would be most helpful. Thanks!...more >>

Hi, I'm doing a data import to SQL from Excel using named ranges in Excel. Using the DTS Import Wizard, I can't see all of the named ranges I have set up in Excel. There are several I have named in Excel, but they don't show up in the Select Source Tables part of the wizard. I need to have all...more >>

Is there any DTS package somewhere that I can use as a sample/reference source. I don't think MS-SQL server comes with anything like this? It would be something equivalent to the Model database but a DTS instead. ...more >>

I'm getting problems running a DTS package on a server. The package runs fine if I run it from a machine with DTSRUNUI on it - even if talking to a remote server, so there's not a package error. The code also seems to be passing in the correct parameters. The package has been copied from the...more >>

Hey All, Sorry if this group gets a million of these, but I'm trying to figure this out and I thought I'd ask the experts. Last weekend, our network guys made "some changes" to the network, but I'm not sure what and they're not here now. I do know they were trying to configure the firewall...more >>

I am using DTS to open an Application. The DTS package runs but when I create a stored procedure it hangs. I simplified my code excluding most of the code created a DTS and the stored procedure runs no proplem. Any idea as to what I could try. ...more >>

hi, I want to delete the source text file from the dts package after the data is dumped to the table. Please help....more >>

Hello, I have a very large text file that is not deliminated - it's fixed width. I want to know a couple of things: 1) Most importantly, I want to know if I can/how I can specify certain column positions from within a text file and associate them with specific destination table fields. For examp...more >>

Could anybody tell me how I can send a DTS package from sql server to a new access database? I want to create a new access database using a filename I enter as a variable when I call the package. I can do it with an existing access database, but can't seem to create a new one. Is this possible?...more >>

Hi all, How can I insert and update data on the same time on DTS?? Regard, Tommy ...more >>

Has anyone seen this error when trying to open a DTS package? [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. This message is coming up when trying to open a DTS package on a server that was working beautifully before a reboot last week. I can stil...more >>

I need to restrict access to the DTS Designer, so that users cannot use the gui to create packages and then execute. I have stopped them saving the packages by revoking access to sp's. but they can still create the packages and run them. Thanks...more >>

Hi, I'm new to DTS and would like to find out where to download the necessary DLL and the sample code for C#? Thanks. Harry...more >>

I have a text file from which I need to load the data in multiple tables. Data in a text file can be differentiated from first two characters in a row. For example, row starting with aa should go to one table and row starting with bb should go to another and etc. File has different row len...more >>

how cold we import data from access 2000 to sql server using sql code?...more >>

Hi people, I have a script which loads a dts package from a datastore and then executes the package. I want to detect if the package fails or successeds. I thought I could do this simply by: var failure = packahe.Execute(); if (failure==1) return false; else return true; However this se...more >>

Hi people, I have a script which loads a dts package from a datastore and then executes the package. I want to detect if the package fails or successeds. I thought I could do this simply by: var failure = packahe.Execute(); if (failure==1) return false; else return true; However this se...more >>

Hi I am trying to use DTS to transfer a Win File to a Unix OS9 file. 1. Is it possible 2. What do I need to do. Thanks ...more >>

Hi! I have a lot of packages that I would like to export to another server in the future. I am using udl-files as connections to make this more convenient. But one problem that remains, is that when I have exported the packages I still must open every package to change the text string who is keepin...more >>

The Requirement: A SQL server job need to be run on some specific work days of our own calendar. We have a scheduler software to schedule jobs based on our working calendar. We NEED to configure SQL server job in this scheduler. To determine success/failure of a job the scheduler expec...more >>

Hi A scheduled DTS job is consistantly failing with the error: Violation of PRIMARY KEY constraint 'PK_MIS_ClassWeights'. Cannot insert duplicate key in object 'MIS_ClassWeights'. [SQLSTATE 23000] (Error 2627) The statement has been terminated. [SQLSTATE 01000] (Error 3621). The step ...more >>

Hi, Can anyone teach me how do i call a bcp command file from a VBA? Regards, Adrian...more >>

Hi there, Can I export data to a specific column in an Excelsheet? I've looked at several sites and articles on this subject, could not find an answer to this question. Tnx, Hans Brouwer *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get...more >>

Using BCP to import a text file can you selectively pick fields. Say my text file has 8 fields can I say based upon a certain record type I only want fields 1,2,5,6,7 to be loaded ? to my SQL table. I need a way to take records from a text file and based upon the record type only lo...more >>

I've created a simple DTS package which picks up a text file and imports it to a table. However, the name of the source file will change daily; the directory will not. How can I indicate to DTS to just pickup whatever file is in this directory and import it to a table? Thanks in advance, ...more >>

Hi, I have a problem with DTS Population data from a DBF file with 3 Gb of size to MSSQL 2000 database. I have like data source a dbase V connection object that is pointing to the DBF file in the same sever, the destination is a Microsoft OLE DB Provider for SQL Server connection object t...more >>

Hello! Who can tell me the property name of source and target of a DTS-Datapumptask? Like that: exec sp_OAGetProperty @pkg, 'Tasks("DTSTask_DTSDataPumpTask_1")',@tsk OUT exec sp_OAGetProperty @tsk, '<name of property>', @tskdest OUT, where is <name of property> the source (or target) n...more >>

Here is what I would like to do... I am sure there is a way or at least I do hope so because it would make my work so much easier. In Dynamic Properties Task I would like to set some of my global variables. That data is stored in the DB and based on one param that I would pass in, I woul...more >>

Maybe you can help me from this error: DTSRun: Loading... Error: -2147008507 (80074005); Provider Error: 0 (0) Error string: Unspecified error Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 713 ...more >>

Hi All, I need to port data from HP Aix & Access databases into a consolidated SQL Server 8.0 database. Other than, DTS, do we have any tool for migration/data porting? I'm looking for some tools like oracle migration workbentch. What are the types of conversions possible in this case. Plea...more >>

I can run my DTS package manually just fine, but I can't run it from a schedule. This worked fine until a server reboot this morning. Any ideas? My job history looks ok until I get down towards the end and it indicates: DTSRun OnStart: DTSStep_DTSExecuteSQLTask_6 DTSRun OnFinish: DTSStep...more >>

Hi, I'm trying to create a transformable SQL server subscription. The goal is to have one publication which is filtered horizontally by the database name of the subscriber. I've created the publication and associated DTS package through the wizards, and modified the transformation script as d...more >>

I have created DTS packages on the server from my local machine. I am attempting to set them up as jobs on the server to run nightly. Its main funtionality is to transfer data from a SQL Server 7 Database, and transfering the information to a SQL Server 2000 database with our hosting compa...more >>

I'd like to use a SendMail task to send an Excel spreadsheet as an email attachment, but am getting "MAPI call failed" errors. This task has 2 precedence constraints: 1. A DataPump task that populates the spreadsheet, and 2. An ActiveX task that dynamically sets all of the SendMail task...more >>

What is .dts file exactly , and how can i make it and use it? Thanks...more >>

Hi there, Is it possible to export data via DTS to a specified column in Excel ? I have read atricle 319951 and several other sources, sofar I have not found a confirmation or denial that this is possible. Anyone? If possible, where could I find a description? Tnx, Hans Brouwer *** Se...more >>

Hello: I am trying to just copy a table from sql server 8.0 to UDB. The table is simple, 3 columns, as listed here: [Field1] [decimal](4, 0) NOT NULL , [Field2] [int] NOT NULL , [Field3] [decimal](3, 0) NULL The table in UDB is identical. The transformation is just a straight Copy...more >>

I have a DTS package that reads a file and uploads the data to our archived database, however, that file is not always present in the target directory causing it to fail. What I need to know is, if I'm going to add a step to ftp the file from a directory to the target directory when this happens, h...more >>

Is it possible to set up a security role that will allow me to give permissions to schedule and run DTS jobs via the SQL Agent without giving full sysadmin rights to the job owner? It looks like SQL Agent requires the DTS job owner to be in the sysadmin role or it will fail to run the job...more >>

How can i send a parameter to DTS packege? For Example, I want to transfer data from SQL Server to text file, But the name of text file is variable.and i want to send it's name by parameter, how can i do that? Thanks Elham...more >>

Hi, i have a huge problem, i have a DTS that calls a store procedure (SP). This SP should return a value but it doesn´t. If i run it in the SQL query analyser it works fine and returns the proper value. If i modify the SP, redrowing only the insert line but keeping the select it returns...more >>

Hi everyone, I'm trying to run a scheduled task on an SQL7 server from Access97. I can run the task by raising a custom error from Access97 which runs the scheduled task. However, I don't see when the job ends or if it ends in an error. Does anybody know how to do this? TIA, Ray ...more >>

I need to move roles and logins from on database to another. I used the Copy Objects Item and it says it complete successfully but the new roles are not in the target databases. Im dbo on both databases. What am I doing wrong? Kevin ...more >>

Hi, Forgive my newbieness to DTS, but I have written some DTS packages on my SQLServer at home and now want to copy them off there to use at work. Is there a simple way to do this? I notice that I can save them to .DTS (structured files) but once I do that how do I import them into SQLServ...more >>

DTS can not insert into created Paradox table ?? SQL->Paradox not primary key in Paradox table What can I do? ...more >>

SQL Server 2000, SP4 We have a DB2 table where we want to extract data for only those fields that equal 'N'. What is the optimal way to set up DTS to move the data from a DB2 table to an Oracle table, where date fields get transformed from DB2 date type to Oracle date type, null date fie...more >>

Hi All, I'm a programmer and I will uses DTS for our project, but I has a basic knowledge on DTS only, have anyone can help me that how to compare the data on DTS?? THX Regard, Tommy ...more >>

I recently loaded SP4 for SQL 7 and MDAC 2.7.1. Since that point, the scheduled DTS packages on that SQL server will not run. I can run the jobs from a command line using DTSRUN and the owners on all the jobs have the proper security. The error I receive is: DTSRun: Cannot create COM Se...more >>

....at the same time. I want to use xp_cmdshell to copy the same physical file from one location to three different locations at the same time. I can do this by opening three QA windows and executing the command three times, but I want to do this as part of a job step (which I asume would cal...more >>

Hi, does anybody knows if is it possible to import objects (tables WITH its relationships, primary keys, foreign keys) using only Query Analyzer? And if it is possible, how can i do this transaction? Any example would be very welcome! Thanks! *** Sent via Developersdex http://www.developers...more >>

I am wondering if there is a way to automate the transformation task so that the source table is mapped correctly to the destination Excel. The reason for this is that I am changing the tables dynamically and deleting and re-creating the excel every time but the data pump task fails because the...more >>

Hi, I'm using a DTS to read an excel file and convert it into a SQL table. I can do that but I need to pass the name of the file as a parameter read from a VB screen. Can anybody help me, please Thanks in advance Sonia ...more >>

Is it possible to kick off a DTS package automatically trigged by the existence of the source flat files? I know I can write an activeXscript to check for the existence of these file but I would still have to set up the job to run the activeXscript to look for these files. Correct?! So, I...more >>

Can data be streamed to SQL. We are a hospital. A patient is admitted to the hospital. That admit goes to an interface engine as a record. The interface then sends the record to other systems in an format called HL7. I want this record to be sent to an SQL server. This interface engine conn...more >>

I've inherited a large number of DTS packages, and I need to figure out a way to do the following. 1) script some way of looking at all dts packages to determine the following: -- how the connections are set up (to be specific who is the default user? -- what types of sql statements...more >>

Hi Darren, I have been trying since two days to look at your reply for my question. But due to some reason, it says the message is unavailable. Can you please post it once again. Thanks, >-----Original Message----- >Message unavailable...more >>

I use the following code (used in a lot of discussions), into a windows form (and DTSRun, Enterprise Manager...) without any problems But when I try it in the code behind of an asp.net web form (I try asp also) I have an error in the log of my DTS Regarding the first task in the DTS, it can ...more >>

I need to make a generic connection to the server where the DYS package is. eg. If the package is on server ABC, then the connection should be to server ABC. How can I do this ? Thank you in advance *** Sent via Developersdex http://www.developersdex.com *** Don't just participate ...more >>

Hi Any easy way to make a format file based on a text file using excel. I have heard references to this but have been unable to do it...more >>

Can someone point me in the right direction to figure out what's wrong here? I'm trying to copy a very simple DB between two servers using the SQL 2000 Enterprise Manager DB Copy Wizard. All steps looks good up to detaching the source DB, but then the actual copy of the share database mdf fil...more >>

Hi there, Does anyone have an exemple of how could I make an Import and/or an Export process in SQL Server using T-SQL and Query Analyzer to do it? Right now, I'm trying to export to and import from Excel files. But any exemple would be more than welcome. Thanks in advance Dani...more >>

hope someone can help ! I have a web app that has been using SQL Transaction services and everything was good. then my SQL Server died and I had to replace. Now I can not initiated a transaction via ASP. Sounds like a simple setup/config issue, but I have never had any trouble initiating...more >>

What is the limit? TIA Quentin ...more >>

Hi, I am new to news groups and was told I might get an answer to my question here... I have a process that gathers information from our mainframe and then sends this information via FTP to a SQL server in a CSV file. I then have several DTS packages that load the CSV files and update my SQL...more >>

Hi Allan, I've tried this : Data Source : Driver do Microsoft dbase(*.dbf) The error I got : Hresult of 0x80004005(-2147467259) returned Unexpected error occurred. An error result was returned without an error message. and I've tried the one you adviced and got an error too....more >>

Hi,=20 I have a visual basic app which reads email files from a outlook 2000 = account I setup for the database server. It then exports these files to = text files which I import into sql server.=20 I created a dts package which first runs the vb app, and then imports = the text files. This...more >>

Hello! I must send a mail using Send Mail Task, the attachments are set by a Dynamic Properties, with a Query. The problem is that I have to put two attachments, and I cannot separate the files by ";". If I used only one attached file, it would work. Thanks for the attention, Eduardo ...more >>

I would like to have many DTSs that use exactly the same VBScript and if my VBScript changes I don't want to have to update every DTS file. I create my DTSs via Designer. Any ideas? Thanks, Branka...more >>

Hi All, I need to import data from .dbf files via DTS, could someone advice me how ? Thanks in advance , Ray....more >>

Hi, I am investigating the possibility of doing a nightly copy of a couple of tables from SQL Server 2000 to DB2 using DTS. I know that it is possible to do this, the question is what do I need to make this export to DB2 work in terms of software? I think Windows has its own built in DB2 driv...more >>

SQL Server 2000, SP4 I've set up a DTS package that copies records from a DB2 table if one column field equals "N". I was able to set up a transformation for DateString since I'm moving data from DB2 to Oracle. However, where there are blank date fields, those rows don't get copied. How...more >>

Hey All, I am a developer and I was put on a project to do some data transfers, so I am new to the SQL Server thing. Here is my situation: I have an application that will run independently on 2 different boxes. Each box will have a copy of my application and a full version of SQL Server on ...more >>

SQL Server 2000, DTS I am working on moving data from AS/400 to Oracle table, with a one to one column copy. I built a DTS package that uses a *.udl file for the connection, then runs a SQL script to pull only fields on the DB2 table set to 'N'. I then went into DTS Designer and added s...more >>

How can I have the database name in this sp to look into a metadata table so I don't need to change the database name each time I move this script to a different db. Thanks is advance for your help. Daizy exec master.dbo.xp_cmdshell 'dtsrun /Smy_server /Umy_login /Pmyp assword /Nmy_dts_p...more >>

Hi everyone, I need to import via DTS some .dbf files. Can someone advice me any steps to make it. Thanks in advance, Ray....more >>

Using DTS Wizard there is an option wich allows me to select the objects i desire to import but when i click that button ("select objects") i got a message error from Dr.Watson ("dtswiz.exe"). I'm using Windows 2000(BR)Pro SP4, and SQL Server v7.00.623 Thanks!...more >>

Hi, i have a problem, i have a DTS that calls a store=20 procedure (SP). This SP should return a value but it=20 doesn=B4t. If i run it in the SQL query analyser it works=20 fine and returns the proper value.=20 If i modify the SP, redrowing only the insert line but=20 keeping the select it re...more >>

Hi everyone, I'm trying to schedule a DTS package to import data from Timberline into an SQL Server database. Here's the setup: i) The DTS package is set up as a local package on the machine running SQL Server. Timberline runs on a different server and there is an ODBC connection between...more >>

Is it possible to change the maintainence plan once I have create it using the wizard? If yes, then I am permitted to use the wizard again, right? -- Posted via http://dbforums.com...more >>

Hi. I'm having a BIG problem calling a stored procedure with an insert-select. If I call the same stored procedure from the SQL Query Analyser it works fine and returns a variable (select rowcount). However, if I run the DTS directly the variable is not correctly updated with the select rowcount. ...more >>

Hi, I am trying to execute a package from ASP and have been successful in doing so. But the problem is that the package is very big and takes a long time. The ASP page is getting timed out as the package is taking long time to complete. Is there any way where i can just initialize the e...more >>

I need to execute a stored procedure from an activeXscript and I'm not sure about the syntax. Thanks in advance for your help. Here is my code - Function Main() Dim objFSO, strFullNm Set objFSO = CreateObject ("Scripting.FileSystemObject") strFullNm = DTSGlobalVariables("gvFilePathRoot...more >>

My development group has an install program that allows the user to change the default db name to anything they want. I need to migrate some Access Data (.mdf file) from the user's hard drive to the installed database (always a SQL 2000 db) as the destination database for my DTS package. ...more >>

i have about 30 tables with some of them having about 2 million records. all them them are scheduled to run at 11.00 PM night. some of the huge tables takes forever to run. please help...more >>

Hi. Running a batch job via DTS that calls an .exe. When I start it manually within DTS it works, when its called from a job it gives the following error: Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description:CreateProcessTask 'DTSTask_...more >>

I have to write a flexible export system. I want to create a temp table on the fly via dynamic sql (the structure can be very different each time) and use DTS to be able to export to ascii files, excel files or even to another sql server table that the structure can be different on. Will dts b...more >>

Hello everyone! I have a DTS package that uses and ODBC DSN to tranfer data from my SQL DB table to an AS400 table. When I run the package from within Enterprise Manger (EM) or from the DOS command prompt (from a client or the SQL server) the job executes fine. If I try to execute the pack...more >>

this error started happening out of nowhere. i have no idea why. below is the description of the DTS error, any clues? Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump Step Error Description:The number of failing rows exceeds the maximum specified. (Microsoft OLE DB P...more >>

I am developing a Data Process Package where I would process data into a table using a stored procedure then export it using DTS. Could I execute the DTS package from a Stored Procedure? This way I would simplify the process for the operators. I needed to process tha data in a stored pr...more >>

I've created a DTS package and I want to use the Send Mail task but I don't see the SQL Mail profile that I've configured on the server. The only way I see the SQL Mail profile is if I open up Enterprise Manager as the SQL service account that owns the SQL Mail profile. How can I get the SQL Mail...more >>

Hi All, I have a package that insert data into a temporary table to ignore duplicate keys. On running this step the next fails because the step reported an error. How do I change the property of the step to success so that the next step can run successfully either using activeX script or ...more >>

Hello: I created and scheduled a DTS pkg., which basically copies data from selected tables of one database to another. The first time this job ran, it took more than three hours to complete. However, every subsequent runs, completes in approximately 11-12 minutes. Is this normal? I w...more >>

Sub : Execute a DTS package from VB - Error in Dynamically Changing Text file path ------------------------------------------------------------------------ ---------- 'Executing a DTS package from Visual Basic code.Works fine but if i am trying to change textfile path then its giving error "Con...more >>

Hello all, I have a bunch of DTS packages on a database that collect data from different data sources, message the data and outputs to an Access database. I brought this machine into the Active directory domain and something Wierd is happening. A) When I execute the packages manually, ever...more >>