I'm trying to write a DTS to load data from a csv file into a database which has "." in the name. I can set up the connection ok but when I try to set up the transform data task, it keeps saying that the first part of the name needs to be added to sysservers. How do I stop it from thinking tha...more >>

I am creating a Job using the SQLDMO interface, if the job fails I want it to email someone with an appropriate error message. On some servers this works fine and on others it doesn't, it all seems to depend on the mail profile settings. The wierd thing is that an activeX script that doesn't ...more >>

I'm using the vbscript below to import values into SQL Server. If a column is null then I want another value used from a different column. But I keep gettin the error "invalid procedure call or argument DTSSource" Any thoughts. Here is the code. '******************************************...more >>

Do you know how to back up all the DTS packages automatically without having to put the server name inside the VBscript? Thanks in advance BIBIBO ...more >>

Hi, I wish to import data from XLS into SQL Server using DTS. However, i want only a particular cell mapped to some column in a table in database. For example, C(9,9) of the XLS should get mapped to Column X in Table Y. Is it possible to do this in DTS? Or do i need to create a staging XLS o...more >>

Hi, I have an application that has aroubd 100 DTS Packages. I want to backup my DTS packages. Is there any easy way of exporting the packages other than that of opening each package and saving it as a .dts file. -- Thanks Akber....more >>

How would I replace part of this data type ... When using it in select it just gives an error....but the lenght is only 16 in the table defintion - how can it be long then...= Need to select and replace a substring. /Michael V. ...more >>

Hello, I have set up a job that executes numerous DTS packages on a nightly basis to transfer a large amount of data from a legacy database to SQL Server 2000. The job is expected to notify our department if the Job has failed or succeeded via email. Every now and again I get the following m...more >>

I'm having an issue that looks suspiciously like a timeout on a task. We're using VB6 to use Automation to write a DTS package in memory, execute it, and remove it. This is a flat, fixed format, file as a source, with SQL Server 2000 as the destination. The file in question is about 2.5GB in...more >>

I have been setup a Win2k3 Server and MSDE 2000 SP3, both of them can startup success. But I can not connect MSDE with other computer, the error message is connect fail ....something like that. I can connect MSDE in the Win2k3 Server when I type localhost to connect it. I can not connect it ...more >>

I have an Execute Package which calls another package and passes its inner package global variable into the child package's global variable ,I have a global variavle in the master package which I like to set to execute package task's inner package global variable.I have done this by writing an s...more >>

I am running a package from within another package using ActiveX script. Everything works fine (global variables are passed and set between both packages as expected). Can the execution status dialog show the progress of a child package's tasks (list each task and the progress)? Any ideas on ...more >>

Hi I am trying to import some data from an excel spread sheet in to sql using a DTS and Excel 97 - 2000 data source (I have also tried importing with Excel 4.0 and 5.0 datasource). I am getting a problem were data is ignored if it does not match the type of the first row. An example of the d...more >>

I have a DTS package that copies data from a SQL Server table to a corresponding DB2 table and am getting the following error: DATA TRANSFORMATION SERVICES: Data Pump Exception Log Package Name: db2 Staging DTS Test Package Description: (null) Package ID: {D60735CB-225F-4829-85A7-E891D33...more >>

I'm using the following transformation script to import data from Excel: One excel row has to be splitted into 5 records. The field ID is my primary key. How can I persuade SQL Server to automaticly set the primary key values ? Unchecking "enable identity insert" does not help. '***********...more >>

I am trying to import a pipe delimited file in a DTS package. I am getting the error "Too many columns found in the current row; non-whotespace characters were found after The file I am trying to import is only 12 rows with 1 row of header information. I have noticed that this is a bug when ...more >>

In DTS 2000 Vb script there is "DTSTransformStat_SkipRow" which will skip a row when we are processing. I need the equivalent of this in 2005 how to write in VB.NET Code If you can find some thing please let me know. ...more >>

Hi Everyone I have a DTS package which runs fine from the Enterprise manager but the job fails. I am logged into the server as the sysadmin and the job owner is the sa account. I have also made sure that all have full rights to the SQL database. The DTS job has a bunch of SQL Tasks and few OL...more >>

Hi, I have one comma delimitted text file without headers. It has 10 lines. I imported the txt file to a table, but only 9 rows have been inserted, but When I try to import the txt file using Bulk-Insert, it inserted all 9 rows. Pls help me why all records are not inserted in DTS. Some t...more >>

SS 2000 In my SQL Server DB, I need to create a DTS package that will push the content of a view to a text file on an FTP site. I have created the DTS that pushes the data to a file server but I don't know how to push the data to an FTP site. How do I create this DTS? I'm new at this, ...more >>

I have a database (SQL Server 2000 Enterprise Ed.) with a single table (Products), which has 3 columns set for Full-Text-Indexing. This database is working fine. All queries are done through Stored Procs, and works like a charm. I tried to copy the database to another database (SQL Server 20...more >>

I want to pass a param to a stored proc, from a DTS package. I'm able to pass params to queries in certain Execute SQL Tasks (by using a Global Var and the ? in the query), but I can't figure out how to pass a param to a stored proc in an Execute SQL Task. Can I? Or do I have to us an Activ...more >>

I am refactoring stored procedures that use dynamic sql. The reason the store procedures use dynamic sql is because the data that is need comes from another MS SQL database that resides on the same server instance. The name of this database is determined at runtime. The following is a code ...more >>

I want to use DTS to have a quote delimited, space separated text file for meeting the requiremenst for one of our vendors for data format. I've been doing quoted, vertical bar separated, running the DTS, opening the txt file output, and doing a Search->Replace All "|" with " " is there a ...more >>

Hi all, I'm getting an error when running a simple dts package created through the import/export wizard. It's only happening on 9 tables out of 50. The tables that error out do have the TEXTIMAGE_ON [PRIMARY] but when I take if off the target table I still get the error. The error is below. A...more >>

Hi, When I export my data from SQL Server 2000 to Access, the Foreign Key Constraints are not recognized and I must manually create them in Access. Is it possible to convert them from SQL to Access automatically? Any help would be greatly appreciated. Leila ...more >>

I have been tasked with creating an export from a mssql db which will contain data and in addition have pictures filed in a directory. Is there a way in tsql to convert these image data types to jpg files?...more >>

Hi, Thank for your help. I need to export data from a sql table to a excel file but in the query I want to use parameters (start date and finish date) and this values I need change. (prompt me to type) I try to use global variables but this do not accept in the query (Execute Sql task) R...more >>

Can a SQL Server 2000 DTS Package be run from a Web application? If so, what permissions, SQL Server roles, etc. are required? I’ve been only able to find examples of Windows and VB applications. I would like an example of a Web application (written in C#). Background: I have a SQL Se...more >>

I would like to provide our users a form inside our program to schedule a DTS package. I.e. I am looking for an activeX or other API to the SQL server agent. I cannot find any documentation. Help! Jonathan Orgel ...more >>

I have character data (money) that I need to convert to numeric data type. When I use the convert or cast functions I receive, " Error converting data type varchar to numeric." error. I found that the character data contains credits with a negative sign. Does anyone have a good idea how t...more >>

How to execute dts from stored procedure? How to use xp_cmdshell to evoke dtsrun? I have the following parameters: dts package name="myPackage" UserId="uid" Password="pass" Thank you!...more >>

I am making a DTS package that will import several columns from an Excel spread sheet. I will be appending these imports to a table on the SQL server. As the Excel spread sheet I get comes from several people and are all named then same I need a time stamp each time the DTS package runs. I alrea...more >>

I am trying to write a very simple DTS package which copies all object from one database to another existing database. If the target DB is empty all works fine. However if the target DB already has data I get the following error message: [Microsoft][ODBC SQL Server Driver][SQL Server] Ther...more >>

I have a SQL Job that is calling a DTS package and the last 3 days I've been getting a failure at the DTS step. This code has run fine for many months. It says invalid character for cast specific (and overflow error). The source field is a date/time and the destination is a date/time. Cast...more >>

Hi eb Seems like some funny credentials problem(?): I am trying to connect and load an excel sheet in to a sql server table. Executing the dts package directly works just fine but running the same package as scheduled job fails. The error message says - either the excel file is opened exclusivl...more >>

hi there, I have the following problem: -I have a table on an as400 (ibm). -This table is linked into MS-Access (for Data-conversion issues) -this link is source to an DTS-Package when using access, everything is fine, but when I start the DTS-Package, the user and password for the as40...more >>

I'm now trying to transfer some data from an Oracle database to sqlsever,I had two questions: 1) There are two providers available( ODBC and OLEDB ) for connecting to oracle database.which one is better? 2)Are there some guidlines for this specific situation (Transferring between Oracle an...more >>

I am doing my first dts and I am getting very fustrated. Need to ftp some files, massage some data, and load it in a table. Using dts seems very cumbersome Reading the files via ftp doesn't work because can't change directories on mainframe Copy files from win server cumbersome because c...more >>

How do I get the result string from a "Execute SQL Task". Say I have a SQL statement "DELETE FROM TBL_X" I run my DTS package and 50 records are deleted. Or it could be an UPDATE and 50 records changed. Query Analyzer reports this in the message tab. I would like to get this "Message" from...more >>

I'm using DTS to update an Excel file on a local drive and then FTP that updated file to another server. The FTP process (an 'execute task process') is set to begin 'on success' of the 'copy data' process and, sure enough, the DOS window in which the FTP process runs doesn't fire up until the ...more >>

Have 1 file each day with 4 or 5 record types. Have 5 DataPumps, one for each record type - 10 columns, 15 columns, 15 columns, 18 columns, 50 columns. Each maps 1 to 1 to a table. The last DataPump is only sent 2 days a week, the others are sent everyday. Because the DataPump with 50 co...more >>

I need to copy a file on another Windows server using a predefined UserAccount. Is there a way to do this in DTS? I don't believe I can use the FSO because it would not be connecting with the correct user account. I tried using a Text File connection to/from with a transformation in the mid...more >>

Hi, I have a small project in which I have to import fields from a csv/xls file and map it to multiple tables within a database ensuring field validations and referential integrity between tables, i.e. Insert/Update per the Parent-Child relationships. I have been reviewing DTS Designe...more >>

How to create multiple tables from single text file space deliminted with variable within the source rows to create table. Total of about 13 tables from single text file. Michael Grant ...more >>

Hi, I am trying to importing data to my SQL Server DB using DTS but I am getting errors. I don't have control over Orcale and looks like the errors occur on DataTime fields. Here is the error message: "Error at Destination for Row number 103299, Errors encountered so far in this task: 1. Inser...more >>

Hi there, Table: tblTestImport Reference varchar (10) Primary Key PlannedEnd smalldatetime CompletionStatus smallint Outcome smallint ProvSpecLData1 varchar (15) Primary Key ProvSpecLData2 varchar (15) The data comes from a csv file and needs to be run 3 times a day. The PK combo (on th...more >>