When try to update partitioned view, I get error: The view cannot be updated because its disallowed construct. Why this happen? How to fix it? Thanks for reply. -Mike Torry...more >>

I am trying to import the performance monitor file (TSV) into a SQL Server table. The performance monitor file is in the TSV format. When I try to import the data into the table listed below I received the following error: The number of failing rows exceeds the maximum specified tran...more >>

I have a simple dts task. I need to update tables from a source_server to a target_server. Task: Drop table from target_server then copy table from source_server to target_server. Problem: I want to be able to pass in the source_server and target_server names as arguments. How can I d...more >>

I have a single table called customer, which has new records added daily and also existing records being modified daily. I'd like to bring the table over once a day after midnight, however I'm running into a problem since there are two things I'd like to do, insert records and update records....more >>

Hi All, I finally got the DTS run to work with my new package thanks to Allan Mitchell.... Now my question is this: How do I pass the Dtsrun command line a variable? EXEC xp_cmdshell 'dtsrun /Ssomesql /Usa /Ppass /NTEST /AMyVar:8=Mydata' The above line works great as long as I hard c...more >>

I am using SQL Server 2000 and I am writing a DTS package that loops through a recordset and calls another package which does some work based upon passed values. It works and loops great unless the called package fails (which it can since it is connecting to an external server). What I want to do is...more >>

I'm relatively new to DTS and am having what seems like a very basic problem. I have simplified what I am trying to do down to the following: I create a global variable called gvRosterID as an int with a default value of 10. Then I create a connection and then and an associated ExecuteS...more >>

I need install DTS package prpgammatically, without using Enterprise Manager. Is it possible to generate script for an existing DTS package and install it on another server using this script? If not, is there any utility that will allow me to do it? Just like dtsrun? I know I can use dtsrun...more >>

1. Is it possible to generate the install script for a DTS package and install it on another server by running the scripts generated, just like creating tables, stored procedures? 2. I know I can use "dtsrun" to execute a DTS package saved as a COM-structured storage file. Is there any similar...more >>

SQL Server 2000 on Windows XP. I try to copy data from an Excel file to a table using a DTS Transformation Task. The PK of the table is CompanyID, declared int and identity. In Transform Data Task Properties | Options, "Enable identity insert" is checked. However, the transformation fails wi...more >>

Salute, Consider this scenario : I have a master/detail database, and another database with the same schema but different data. Now, how can I ADD the master/detail data from the second DB to the first one ? how can I resolve the identity conflict ? If I...more >>

Hi All and tia for your help. I need to create a DTS package that can accept a parameter... The package will be exicuted from stored proc or T-SQL statement. I am thinking dtsrun. My question is how would I create a package that expects a parameter, then how would I call it? The para...more >>

Hi, I have an active x script in a DTS package. It has access 2 to global variables in the package. sql = "UPDATE tblplanlines SET tblplanlines.description = mastermap.dbo.tblstppdesc from tblplanlines INNER JOIN " & _ "mastermap.dbo.tblstppdesc ON tblPlanlines.PPLAN = mastermap.dbo....more >>

I'm extracting data into SQL Server 2000 from Progress 9.1. Doing it serially is too slow. I tried to multithreading the extract process but ended up with less data without any error message. Is there a possible way of speeding up my extraction without losing data? *** Sent via Devdex htt...more >>

Hey All, I am trying to figure out how to Import a specific Excel sheet in an ActiveX Script set conTextFile = pkg.Connections("Microsoft Excel 97-2000") conTextFile.DataSource = DTSGlobalVariables("gv_FileFullName").Value DTSGlobalVariables("gv_sheet").Value = GetSheet() But i don't kno...more >>

I am trying to import a text file to a table in SQL Server. It looks normal at the beginning. After I chose "Fixed Field" - File type: ANSI, Row Delimiter: {CR} {LF}, then click Next, it became misAligned. I could not continue import. I tried different Row Delimiter, none of them workin...more >>

I want to create an excel file through a DTS and stored procedure and the file name should be named as todays date. Anyone have any idea where do i put it or methods to do it. Thanks in advance ...more >>

Hi, I have a database with a number of temporary tables. The data in these temporary tables need to be transferred into tables in the same database. There are 5 transformations in all. I need to use transactions in the DTS job becasue if one transform task fails then I need to rollback all inserts...more >>

Hi all, I have SQL2000 and i try to load data from text file with bcp. Everything works fine, but triggers didn' t fire. I don;t knouw why. When i try to insert data from query analyzer, trigger fired. So, does anybody know , where can be problem? Thanks...more >>

I need to be able to Open an MSAccess 2000 database then run a macro at a scheduled time. I think the best way to do this is through a scheduled DTS package using an ActiveX script but I'm a novice with VB and I just cannot work out the code required. Is there someone out there who can h...more >>

hi, I have a sql server 2000 DTS package, that selecting yesterday's data from one of our vendors database (Advantage platform) into our sql server 2000 db, daily process. my select query is like this: SELECT * FROM vendor_table WHERE (DATE = { fn CURDATE() } - 1) Advantage don...more >>

I have SQL Server 2000 Enterprise Edition with SP3A. I have set up a DTS job to import Windows 2000 Advanced Server performance monitor output values from a text file. Connection1 is a text file: E:\Server_dd_yyyymmdd.txt Connection2 is a OLE DB Provider Connection for SQL Server: Pe...more >>

Hi All, I want to transfer data from SqlServer2000 tables into Oracle 9i. I use Transform Data Task, when I specify the destination table, table does not exist yet, and it dts offers to 'Create Destination Table', when I press Create, the script is : CREATE TABLE "Product_Temp" ( "KDPROD" CH...more >>

I designed a partition scheme which will partition one extremely large table into many partitions (> 256). I want to build a same name view on the top of all these partions so that I don't need change any code in the current system. The queries against the original table can still query against ...more >>

I'm looking for a solution for my Intranet users (ASP website) to execute jobs on my SQL Server As I don't know all the possibilities of SQL Server, I had thought I could do a DTS package, save it as VB source code, compile it in a .exe application which my ASP page would execute. I've already...more >>

I set up a package with a SQL task that may or may not fail (I do a raiserror if it fails). There's a notfication task dependent on the SQL task step that will only fire on a failure in the SQL Task. If the failure path is taken and the notification step works, I consider this a "success." H...more >>

Does anybody know what to do with this one: Unable to determine if the owner (xxx) of job xxx has server access reason. Could not obtain information about Windows NT group/user xxx. SQLSTATE 42000. Error 8198. The owner of the job is set to the specific user - the user is part of a windows ...more >>

Hi all, I am running a DTS package job which runs on its schedule. The job truncates the destination table and copies data from source. The job runs fine most of the times and at times the job fails with the following error msg in view job history. Please help me to resolve this issue. ...more >>

I have a package I am trying to move data from a progress database to our SQL Server 2000 database. I am getting some field size errors from Progress database, which is expected. I have the max error count set to 100. I am passing the error count to an Sql table on completion. The problem...more >>

Have a DTS package that uses a Sequence number off a table to insert records into a database using a incremented global variable. Have a sql task that performs various other tasks and want to set the global variable from within the SQL task. The question is, is this possible and how does one d...more >>

Hi, I am trying to create a dts package to import about 10 tables from access to SQL server using the DTS import and export wizard. I saved the dts package and tried to add a work flow to make sure the person table is inserted first before the other table. But how can I roll back the entire ...more >>

Hi, We have several large and complex DTS packages for converting from OLTP to Star schema, and maintaining them on SQL server is becoming quite cumbersome. Additionaly, we have to change the server/db names and other parameters for different client installations and we're currently doing this...more >>

Hello. I'm trying to find out if it is possible for me to create some sort of a function to automatically modify a DTS package in a given SQL database. For example, I have 4 MS Access databases containing tables that I need to modify slightly and pull into one table in an SQL database. All 4 hav...more >>

Greetings everyone, I have a dts package with a dynamic properties task and the typical assortment of sql queries, connections, etc... The dynamic properties task exists to set the properties of various global variables which are to be passed in from the command line. Question, can I set one ...more >>

I am having a problem running bat or cmd files in my dts packages. Whenever I first create a new package which runs a bat file, the package runs fine. However, if I log out of Enterprise Manager or schedule to run the package later, the bat file is never able to run. From what I can tel...more >>

My server has Windows 2000 Advanced Server as operating system with SQL Server 2000 Enterprise Edition. I would like to create a SQL Server DTS package to automate the import of my daily performance monitor file. My performance monitor file is created daily at 7:00 am with the followin...more >>

I've created a loop in a DTS, which retrieves connection information from a SQL table and then (is supposed to) populates tables in different Databases. The loop works, but it keeps updating the same DB, rather than updating each of the individual DBs. The connection information seems to be updat...more >>

I want to send a text file over to a ftp server via ftp. so I use add the File Transfer Protocol Task and I see that it only allows me to specify the source (which I change to Directory since the text file is on my pc) but I don't know how I could enter the IP address of the ftp server ?...more >>

Hi, When I run xp_cmdshell in an ActiveX script that is executed within a DTS package, I get the following error... "Type Mismatch : 'xp_cmdshell' " The below line is what I execute .... xp_cmdshell 'open c:\test\blah.bat', no_output I have tried different variants of the above to no a...more >>

Hi all, I try to implement the following in a DTS: Executing a SQL-Task like the following: SELECT ContactExists FROM BrainBase.DBO.IDP_CheckContactID(?) (Table Function) OR SELECT BrainBase.DBO.IDP_CheckContactID(?) (Function) I want to write the result into a Glob...more >>

How come it doesn't tell me if something goes wroing in AS ? The package just looks as is it is till running. When doing the same thing directly in AS i get error information. ...more >>

Does anyone know how to programmatically decrypt the stored procedures (In SQL Server 2000) encryted with the "With Encryption" clause? Thanks a lot, Lixin ...more >>

SQL / AS is great - but one thing annoys me - if I want to cancel a dts task it seems as if it never works...it persists on doing a package till the end and before starting a new package it will cancel and sometimes it just doesn't get back when cancelled. Is there someway to make this better ...more >>

Hi ! When I execute a DTS from Enterprise Manager the package reported "Column name Col00x was not found". This error happens when I change the source TXT File. Is there a way to configure a "dynamically" mappings cloumns ? Thanks a lot...more >>

I have built a stored procedure that returns a result set I want to use in DTS to populate a table, but on the Transformations tab I see no Source columns? The procedure uses data from several tables to populate a temp table, which is then joined to other tables. Nothing very fancy... On th...more >>

I have typed to import a text file to SQL server 2000 with MDAC2.8 installed. The text file is with different record width in each row. I use the 'add connection' and choose the data source 'Text File (Source) and my file. In the text file properties, Fixed field, file type: ANSI, Row delimiter:{...more >>

When i use this code Dim objLotDts As New DTS.Package2 objLotDts.LoadFromStorageFile strNomLotDTS objLotDts.SaveToStorageFile vstrNomFichierDTS Set objLotDts = Nothing I lost the comment put in the DTS package and all the task in this...more >>

Hello People, I would like to check that I have a valid connection between SQL Server and an AS 400 (200 miles away) before I execute a DTS Package, an ActiveX script would be great, and also how to terminte the package if the connection is down, I'll be executing the package every 10 mins. Much...more >>

Hello People, Can any one tell me how to check if the connection between SQLServer and an AS400 (200 miles away) is enabled using a DTS Package, I want to make sure the connection is there before I execute the package, an ActiveX script would be great, also how can I exit from a DTS package if the ...more >>

Hi. I have Sql Server 2000 With Sql SP3 on Win2K. I am Importing Data from Textfiles to a table which has a column of Varchar(512) Thru DTS Package in VB6 but DTS Truncates the Column to 256 Charcters during import. can anyone help me as this is urgent. I have a deadline to meet....more >>