Hi, I have a DTS which has a connection, 3 destination text files and a Process execution job which runs a simple batch file to concatenate this 3 files into a 4th text file "Endeud.txt". I added an activeX command Job to input a date which is saved in a global variable. I need to add this dat...more >>

Hello all, I have a DTS package saved to run as a scheduled .bat. There is an ActiveX script within the package which among other things contains: oSendMailTask.MessageText = "texttexttext " & vbCrLf & "Uke: "&Datepart("y", (NOW)/7) & "_" &Year(Now()) [...] To keep track of changes while ...more >>

I have inherited over 100 DTS packages, and am in the process of reviewing each one. I have been doing this by entering the Design screen, and reviewing each step. Is there an easier way to view what the DTS does other than going into design mode? (Note: just running the DTS is out of the ...more >>

Hi, is there any Primary Interop Assembly for the DTS Package in order to use this COM componente from .Net applications? Thanks LucasC ...more >>

Hello, I have two questions: 1. Source field is a varchar(4000), the destination is a TXT file, only getting first 255 bytes of data. Can this be corrected? 2. Long field contains XML string, what is the best way to parse this? I could write a script, want to avoid the development. T...more >>

The script displayed below is being used to display some information about the package and log to some messageboxes (presently). The EnumPackageRecords works fine and returns all the data it should. EnumPackageInfos and EnumStepLogRecords do not return any data or display their messagebox. No er...more >>

I have an incoming text file (comma delimited) with repeating groups (arrays) of data which I wish to load to a single table. Is there a "built-in" mechanism for handling this situation or do I need to write code within the package? Assuming the later, any code sample would be greatly apprecia...more >>

Hi, Maybe a silly question, but here goes I'd like to create dts packages that do (whatever...something generic and dynamic) and package them with other software (c / vb6 exes) to distribute (maybe using installer scripts such as Wise or InstallShield) I know end users will already hav...more >>

Hi every one, I have a huge problem, we hava a DTS that make : 1) Get the name of the file to Unzip 2) Unzip dbf files 3) Transform DBF files into SQL Tables 4) Delete the DBF files to ensure that the next zip if isnt have any dbf files, we dont transform the prior DBF These Delete is an Act...more >>

Hi! I created a DTS package which has an ActiveX Script Task as one of its elements. Below is some part of it strNumer = DTSGlobalVariables("NumerPliku").Value DTSGlobalVariables("NumerPliku").Value = strNumer + 1 When I run this package withing DTS Designer global vari...more >>

We've just performed a DTS copy objects and data from the production server to the development server, but the DTS failed on updating the referential integrity. The following error is reported with the specific names of the database, fk, table, and column replaced with generics in brackets:...more >>

Is there a way that I can create a text file as the last step in the DTS package that reads 'The extract was successful' ?. Is there a activeX or VB code that can do this ? If so, can someone help me with code ? Thanks in advance. ...more >>

I have a simple ODBC link where I import an "income" in dollars. There are no errors, but when i look in my selection it has truncate some of income. It deletes 2 zero's from the input. For example, it suppose to be $21000, but is shows up like 210. But $21111.11 is not effected. And to m...more >>

Hi, How can I transfer all my DTS metadata services packages from on server to another. All connections used in those packages that point to the old server should be changed as well. Any help? Thanks ...more >>

Recently we have migrated the datawarehouse server to windows 2003 server from windows 2000 server. Since then all dts packages are getting timedout with the following error. Step Error Source: Microsoft OLE DB Provider for SQL Server Step Error Description:Timeout expired Step Error code: 8...more >>

Hello, I am wondering if it is possible to execute an asp file from a DTS activex Script Thanks -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-dts/200509/1...more >>

Hello, I am wondering if it is possible to include a class and to instanciate it into a dts script? Thanks -- Message posted via SQLMonster.com http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-dts/200509/1...more >>

Hi all, I'm pulling my hair out trying to do some error trapping. I have a "Transform Data" task, which exports data from a Oracle table to Sql Server table. For any given row that FAILS to export, I need to find the rowID field from the database table in Oracle and sends an email to a s...more >>

Hi I'm using DTS to migrate data between excel and SQL database. I have created global variables for setting up the values for source excel and destination database server, database name, user id and password. I've added a dynamic properties task and have assigned the global variables prope...more >>

I have a Product dimension on which I expect about 90 attributes mainly they are related to classifying the material. Can somebody please share ideas how I can implement such a large set of dimension attributes any other alternatives you can think off. Sometimes the attrbutes can be dynami...more >>

I have a DTS with one conection and two destination text files. I need to transform this two text files into one text file (first one files date and under the other files data) How can I do this? *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hai, I'm working with SQL2000 server and i'm using DTS import. I have made a schedule package (job) from a DTS. When i run direct the DTS, there is no problem, it works But when i run the job, it failed. But some other jobs to import a DTS there is no problem. Who can help me. ...more >>

I've used DTS before and had pretty good results importing data from other data stores - however, I've had poor results running the DTS packages that I've saved... Most of it was due to my lack of knowledge, I'm sure, but I need to get something like this running, so now I'm going to where th...more >>

Hi all... I need to do the following: I have a table in SQL Server 2000 that has some data. One of them is a company's code. To retrieve that data I have this query: SELECT CODEMPLEADOR FROM TARJETA T, EMPRESA E WHERE TAR_ESTADO = 'I' AND E.EMP_RUT = T.EMPRESA_RUT Using ...more >>

I am having problem in creating DTS package. I have 4 steps in DTS package. First step is an activex script calling from asp file to copy files from one folder to another. Second step is an sql task to delete data in temp tables Third step is again an activex script calling from asp file to ...more >>

Hello, We have a DTS package that we are testing some issues against. It seems that SQL that is executed in DTS (against server 7.0 SP4) causes excessive locking at the row level. Reading up on transaction isolation levels, the default mode of "read committed" should be just fine, and not ...more >>

Hi, can I run transfer from database to another database? When I see the params from dtswiz, I can not fout nexts parametrs for destination database. Thenk for any idea RF...more >>

Please bear with me, I am very new to dts. I have a small package that I execute with the dtsrun command from a stored procedure. It simply copies the values from a sql table to a text file. So far so good. I now want to be able to pass the destination path as a variable to the package. I h...more >>

i am firing the following from QA bulk insert pubs.dbo.Orders from '\\<ServerName>\test\Orders.txt' with (DATAFILETYPE = 'native') This <ServerName> is not the servername of the SQL Box, but the remote box where i have created the shared folder test with approrite permissions. B...more >>

In a DTS I want to transfer data only if some conditions are met. I get values from a table into global variables using an Execute SQL Task. Then I use an ActiveX task to check the values. If the conditions are met I return DTSTaskExecResult_Success, DTSTaskExecResult_Failure otherwise. The...more >>

Hi I have received sql server 2005 june ctp dvd.I would like to run the integration services and start creating containers and tasks but the start/programs menu does not show any of these. Can you please inform how to work with them. Thanks Babu...more >>

I need to change the "From" field in the DTS package notification so users can reply to the e-mail and have it directed to another e-mail account that's not the default profile . We only have one profile on all the servers and I'd prefer to keep it that way if at all possible and using xp_sen...more >>

Hi all, can anyone help me please! I need to know how I can redistribute DTS SQL 2000 SP4 on a client pc without installed sql client tools. What Files (DLLs) I need ? Thanks and greetings Martin ...more >>