I have a package that includes different tasks. At the end of some task I have a "ActiveX Script Task". Here I want to get the name of the previous task. How do I do that?? (I'm writing in VBScript) /Maria...more >>

Just reread the mail. Did you actually mean that you wanted to upload a table to an FTP site? In what format? Remember SQL Server is not file based. -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.konesans.com ...more >>

Hey all, Trying to use the import function of a dbase in enterprise manager to move a ..dbf file into the sql database. In DTS Import/Export wizard it's asking me for a Data Source: which I'm using "Microsoft Visual FoxPro Driver." Is this correct? The .dbf file was made useing VFP 6.0. Als...more >>

Hi, I am new to SQL server. I have updated my web site to SQL server (used to use Access sucessfully) I now need to synchronise both ways - ie some data is created on the server and need putting on the web and some data is created on the web and needs fetching back to the server. I hav...more >>

Is is possible to import a unicode flat file? I'm using a Text File (Source) connection object, with a Transformation Data Task to a table. But an 8 KB file shows up as 3 characters of gibberish. The destination column is nvarchar(4000). Does the Text File connection support unicode? -- Di...more >>

Hi All(an): As I was advised I created this query: USE ipd INSERT INTO dbo.OrderRegulation (TitleId,YearId, MyIssue, RetId, IssueId, Location, Draw, Reorder, [Returns], Cost, Price) SELECT StagingOR.TitleId, StagingOR.YearId,Stagin gOR.MyIssue, StagingOR.RetId, StagingOR.IssueId, ...more >>

Does anyone know of a way to pass DTS global variables into Execute SQL Tasks? I am replacing some Send Mail tasks with a more generic TSQL proc that uses CDO.Message.1 to send to SMTP, and would like to make use of the existing mechanism that used DTS Global variables and a disconnected edit to...more >>

Hello, I have two issues, hoping someone can help. Issue 1. I have various DTS packages that copy data from Progress Database to Sql Data Warehouse. The ODBC Connection is stable and packages have been auto scheduled by creating a job that is managed by the SQL Agent service to run daily ...more >>

Hi All, The dtsrun utility has a [/L log_file_name] Parameter, Which is Used to Specify the name of the package log file. The Package will Log All (Failure and Success) to the Specified File. How Can I Log only if the Package Fails not while It Success? So that the Size of the File will al...more >>

Hi there! I want to export data to file texts based on parameters that come from a second table. For example: select * from table1 where field = ?parameter? But: ?parameter? are all values from another table. For each different value of ?parameter? I want to create a new text file. I ho...more >>

Hi, We have hundreds of DTS packages being executed via DTSRUN that are encrypted. We are upgrading to a new server and OS and the old encryption value doesn't convert. Is there a utility or some way to determine from the encrypted hexadecimal value what the DTS package name is? I thoug...more >>

Hola grupo, please help me .Tengo problemas de demora de tiempo al armar una tabla dinamica de un cubo OLAP en excel, el problema se evidencia cuando agrego a excel una tercera dimension del cubo a la tabla. No se por que se da si solo mi fact table tiene 8000 registros. a continuacion explico co...more >>

I have a web application that uses server.createobject("DTS.Package") to access a DTS Package on a different box. My question is, does the actual CPU processing occur on the web server where server.createobject("DTS.Package") is invoked, or does the CPU processing occur on the sql box where th...more >>

Hi all, I get an invalid pointer error when I run the DTS package exporting to text file. All the columns are mapped to destination properly. The following is what I have for thanks SET NOCOUNT ON declare @CallLastResult as datetime set @CallLastResult= (select max(datetimeofcall) from ta...more >>

Hello All, I have my database in SQL 2000. I managed to import a csv file and save the DTS to create a staging table (as described by Allan many times)and now I am ready to delete,update and insert data in my final table (in the same server). I keep reading about this and I think I need t...more >>

I am running SQL Server 2000 SP3 and have a DTS package that uses a SELECT query to dump data to a | (pipe) delimted file. The SELECT statement has 36 columns in it. Whenever I try to edit the trasformations mmc.exe crashes and I get blown out of Enterprise manager. I remeber having thi...more >>

Hi I have a dts packet that copy data from 6 different tables. If anything fails I want to send an email saing what table who faild. Can I do that with only one "Send mail task"? /Maria...more >>

Hi, I have saved some packages under meta data services packages but none of those show up in my enterprise manager. I also found that my meta data services folder is missing too. How can I get these show up again? The funny thing is the meta data service stuffs are fine in m...more >>

Hi there... Imagine that I need a comment in the beggining and the end of each table records. And my records come in blocks from different tables. How to insert it? Thanks! Example: *TABLE1* (Line with the comment) 1,2,3 2,3,4 *EOF* *TABLE2* 1,2,3,4 2,3,4,5 *EOF* Thanks ag...more >>

Hi, I am building in a data mart using SQL server DTS. I have confusion that Example Suppose we have text file for Cust table. It has 3 customers A, B, C This information comes in text file from legacy system. We load this data in cust table in staging. Now we get a new te...more >>

I am writing logic where I use an ExecuteSQL task to define multiple source views, then want to use data pump tasks to pump from each of 12 source views to a target table. To do this, I have defined 1 datapump task and disabled it so it does not run as part of the automatic workflow. T...more >>

Ok, I'm a relative newbie to dts... I need to take several relatively simple SELECT statements, i.e., select * from table_xyz where code = 'a' and insert the results into different cells within an excel row. The excel file is used by salespeople and others and the dts package of which the...more >>

Hi, I have two types of ascii files. File1 Col1;Col2;Col3 10,11;8,00;2,99 File2 Col1;Col2;Col3 10.11;8.00;2.99 ; = col separator and , . are decimal marks. I import files by DTS and File2 works fine but File 1 is a problem. I get general conversion failure source col DBTYPE_STR...more >>

Hi I have som dts packets that imports data from oracle into Sql server. They work fine when i run them but when i try to schedule them they fail. Error = -2147467259 (80004005) Error string: Error while trying to retrieve text for error ORA-01019 Error source: Microsof...more >>

I recently had an experience with a database which was mysteriously ERASED. That is every table was suddenly purged of all data. This is not something which could have been done casually. Unless deliberately (and maliciously) sequenced, a series of DELETE FROM statements would have failed sooner ...more >>

Is there no way around the problem of preventing garbage data from screwing up an ExportData and corresponding ImportData using a BulkCopy object? I was using the tab as the delimiter until some errant data (an embedded tab) in a field caused the import to fail. You can set your own delimiter, ...more >>

Dear All, I asked this question some days ago but still unable to resolve the issue. Can anybody kindly guide me as I am new to DTS environment in SQL Server 2000. I am building an application in Visual Basic 6.0 with SQL Server 2000. It will move data (mainly account numbers and associat...more >>

Dear all, I understand this has been asked before but I don't quite understand exactly how to do this The situation is I have source data in Oracle database and the destination in MS Sql server Suppose I have table A in both Oracle database and MS Sql server which have the same table stuct...more >>

Hi, I have a DTS package that runs at different times of the day. I have set this up as different jobs. The function of these jobs is to gather data from a server in our corporate domain and write it out as a text file for my other applications to process. Sometimes, the host server has some is...more >>

Hi there, We don’t know how we ended up with more Tasks then Steps, but when we look in Disconnected Edit we see that that is the case. When we look closely in al the individual Steps we see that some Tasks are never connected to a Step. Is their a way to remove these obsolete Tasks? Annick ...more >>

Hi, Just trying to import data from an excel 2000 spreadsheet into a sql table using dts and getting the following error - "Could not create an instance of the DTS Package" Any ideas? Thanks TGB *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in...more >>

Hi I'm importing 40 text files, with headers and delimited by Vertical Bar into SQL tables with exact column matchings. Initially the files has {CR}{LF} as the end-of-row delimeter, but this has been changed to just {LF} I am having trouble with just 6 of the 40 files, and there is nothing ...more >>

sql2k sp3 Ive got a package that transforms a datetime in one table into a char(10) in the other. Im using the Date Time String Function to to this. I feed it in a date and time the way it's stored in a datetime column, it comes out like 07/22/2004. This is all well and good. But once I ...more >>

Hi, I written the following C# code that uses sqlnamespace and dts libraries to load and execute a dts package. The code works fine, but if I run it twice, I get the an exception indicating "The SQL Namespace has already been initialized". My code destroys the namespace object and I can't fin...more >>

after the first iteration (at least working) of my dts/etlm application for a datawarehouse, i decided to do the next step to more professional implementation. is there a book, that covers etlm with a tendency to implementation with dts? currently i decided implement my next iteration with m...more >>

I am currently developing a custom transform for our datamart ETL. The idea is to do foreign key lookups directly in the transform to convert incoming strings to the correct IDs. This is similar in principal to the idea of using a lookup but much faster. One question I have, is it possible ...more >>

Join members of the Microsoft development team as they chat about what's new in SQL Server 2005 Beta 2. One major new feature that's been announced in Beta 2 is data encryption. Come chat about other new features and changes that exist in this highly anticipated beta of the next version of SQL...more >>

Can anyone get the following VBScript to work when run in an ActiveX Script Task in a DTS package? Function Main() Dim objSession Set objSession = CreateObject("MAPI.Session") Set objSession = Nothing Main = DTSTaskExecResult_Success End Function SQL Server won't create the MAPI...more >>

I have set up some DTS packages to import data from an outside ODBC source. I have scheduled these packages to run automatically by scheduling jobs for these packages. My question is; when I schedule the package as a job the command that is generated is some kind of long code like this DTSru...more >>

DTS Environment Control =20 What solutions have other worked up to handle DTS packages and = promotions through their different environments? =20 In our scenario we have a 4 tier environment (Dev/Test/PreProd/Prod). = The challenge is when you promote your packages up; the connections...more >>

Hi, I have a DTS package that runs at different times of the day. I have set this up as different jobs. The function of these jobs is to gather data from a server in our corporate domain and write it out as a text file for my other applications to process. Sometimes, the host server has some is...more >>

Hi, I have a dts package that imports a number of text files into a SQL Server 2000 database table. The package has been set up to accept a text file with a row delimiter of carriage return and line feed ({CR}{LF}). Some of the text files I receive only have a line feed ({LF}) as the row delimite...more >>