We have a C# application which calls DTEXEC.EXE. SQL Server (2005) is not located on the same machine where C# application runs. Hence, DTEXEC.EXE file doesn't reside on machine where C# application runs. My question Can we install DTEXEC.EXE (and NOT whole SQL Server 2005) on machine that ...more >>

Client doesn't want to install AnalysisServices on same server as SQL 2000... Why ?? Problem now is how to automate processing of cubes. Normally I add a "Analysis Services Processing Task" as last step in my DTS-jobs on the SQLserver. Since MSAS is not installed on the SQLserver I cant...more >>

hi, I'm using an Execute DTS 2000 Package task in SSIS. I can choose Structured Storage File and pick up a pcakge name, but I get an error while setting inner variable. =================================== Invalid class string (Microsoft Data Transformation Services (DTS) Package) -------...more >>

Hi I am soon to begin development of DTS packages, can anybody recommended book titles that I should look at? Kind Regards Ricky (SQL2K/Win2K) ...more >>

I have a need to pass an argument to an executable in an SSIS package. The value of the argument is not static, it will vary at execution time, so I need to pass the value of an SSIS variable as the argument to the exe in the Execute Process Task As an example I can define my executable as...more >>

Hi. I am creating a DTS package that has a number of tasks. The primary purpose of this DTS is to import and process data from local delimited file. I have a data source connection that wraps the source file content and allows the system to see it as just another database. Right now th...more >>

I am using DTS in SQL2K to pull data and tables (copy tables and views from source database selection) from a remote MSDE2000 installation. Things appear to run OK, but I eventually get an error on a particular row everytime for one table in particular. The error varies between the Transac...more >>

Hi all, I have a table which has 6 columns and a text file which has four columns that are need to be loaded to the table. I have set the data source and the destination data. Now the two columns the text file doesn't have are primary key column and timestamp which simply should be incremente...more >>

Hello, I just implemented log shipping on SQL Server 2000 Developer edition and I need to keep all modifications to DTS packages on Primery Server to be replicated on Standby Server. Could you please give me a hint how to do that? Thanks, GB ...more >>

I have a DTS package that connects to an Oracle server and outputs a csv file. I would like the user to be able to run the DTS package without having an SQL server installed, so I want to exported it to vb and compile it into an executable. What is the best way to compile this code? What i...more >>

hey people, greetings to everyone.. I am new to SQL and I would like to know, is it possible, and if, how? to initialize DTS package with visual basic script? If you can help me with some information about that I would be very thankfull.. ...more >>

I have a C# windows application that will be used by several users from their workstations.Within the application I am executing a few DTS packages and the resulting output files are placed in user specified local folders. -The DTS packages reside on a remote server. -I have a windows user ac...more >>

Hello there I wanted to know if anybody has an example of an activex task in a dts that will query a soap service ? I never queries a soap service from vbscript so I guess i need to see an example to start ? please Thanks ...more >>

Hi, I have just installed SQL 2005 Developer Edition on a Win2003 Server. I have an installation of SQL 2000 on the same machine, which I use for DTS package creation. Since the SQL 2005 installation, my DTS packages are breaking on the DTS Mail Task, it fails with the message that the semm...more >>

In SQL 2005, I am creating a new package that I want to save in SQL server. Per the documentation, I should be able to select "Save Copy As" from the file menu, however I don't see this option, nor do I see any other way to save the package to SQL from the SSIS designer. I am able to impo...more >>

Hi, I am trting to import data from many spreadheets. The first column in the sheets is the serial No. So, after importing the data from teh first workbook, I made the first column as Auto-incrementing and also made it the primary key, so that we didnt have the same No for different rows. ...more >>

Hi, I am wondering if I can create a package in SQL in SQL Server 2000. I was thinking of creating a stored procedure which can build a dts package. Kind regards, Ayman ...more >>

Hi Guy, I need some information. In my DTS I want to use a traformation task with a stored procedure as source. This step is ok. THEN... This SP need, for a correct function, 2 parameters that I want to set it with 2 DTS global variables. In task trasformation source, I write " EXEC...more >>

I'm tryiing to run a package that transfers data from an Oracle database to a table in SQL Server 2005. The package runs just fine from the BID. However, when I deploy it to the server, it fails. It gives a "ORA-01017: invalid username/password; logon denied" error when I use the Microsoft ...more >>

Is it possible to extend the Design Sheet. Is the sheet limited to what you can cram onto it?? Thanks TVO...more >>

The dts are stored in the msdb database in the tables sysdtspackages, sysdtssteplog, sysdtspackagelog, etc... Somebody knows how obtaining the querys o commands (text) contained in each step of the dts? This is becouse I need to know what tables are used for what dts, facilitating my tas...more >>

This has been a problem since I started working on SQL 7.0. When I = transferred database from one server to another using the Import/Export = Wizard, the foreign key script that is created automatically fails when = there are foreign keys where some of the data is not in the linked = table. I...more >>

I need a different approach to programming a transfer of a database. An old approach, kind of a hack, using SQL Agent to schedule running a ..BAT file, is to zip a .BAK file and copy it to another machine, which runs a separate .BAT file that unzips the .BAK and runs a .SQL script using ISQLW....more >>

Hi I’m new in SQL 2005 and hope for some advice. I want to import some data from Sybase 12.5 into SQL Server 2005. It’s about 10 tables, and 2 tables have about 1 mill records each. After that I want to import every new and updated record once a day. Is there anybody who has any ad...more >>

I hope this is the right place to post this, but I have a question. We have an AS400 DB2 mainframe that is our primary database. I need to replicate that data to a SQL Server. I am currently using SQL Server 2005 Standard. Do I use DTS for this or something else? Any help and informatio...more >>

I'm trying to use the same email that I use in ASP in a DTS package, but it errors out with "Active X scripting encountered a runtime error during execution". The code is below. Can I not do CDONTS in a DTS pkg? '********************************************************************** ' Visua...more >>

Environment is SQL Server 2000. I know how to write VB script code in a DTS pakage (using the drag drop of the Active X Script), but can I use VB.Net code instead? Also, is there any examples of how to do this ie; how to add references, some code examples? -- Chris Davoli ...more >>

Howdy all. My goal here is to be able to be able to move a DTS Package from one box to another and not have to specify the new box name in the DB connections. I know I can do it in the Global Variables under Package properties, but that's not all that great either. Therefore I try to assig...more >>

I have two sqlserver2k databases on different servers on the same network. I need to push recently inserted/updated data from one to the other, but the databases have different schemas, i.e. the data needs to be transformed during transfer. Also I need this synchronisation to be as close to real...more >>

I would to control my DTS package from within my ADP project under Access. I don't want to import the DTS package as a vb module, I would like to remotly manipulate the package. For instance my ADP proj. need to send a variable to the DTS pack. (a date) in order to dynamicly create a table whose...more >>

I have DTS packages on one server and i wanted to move these to some other server , how can i do this? is there any way to generate the SQL Script so that we can run these Scripts on the targeted machine? or do we need to manually create these packages on the other server?...more >>

Hi. I am attempting to import a DB that was sent to me in CSV format. The DB contains roughly 18,000,000 records. Unfortunately, on record 645,323 I get an error that one of the delimiters is missing. The import fails. Is there any way to bypass this? And any following errors? 1, 2, eve...more >>

Hello, I've got a questing regarding updating existing data in a SQL Server table from an Excel file. The situation (simplified): Source: Excel file containing (PK,value) Target: SQL Server table contating (PK,value ,DATETIME) I would like to "merge" the excel, into the SQL Server ...more >>

I would like to download a file from an HTTP server. Is there a way with DTS to download a file from a webserver as we can do it from an FTP server using the FTP task provided? ...more >>