Hello. I have to run many sql scripts each day. Sometimes I'll have 100+ scripts to run. The scripts always come in a folder numbered in the order they need to be run (001 - ScriptA, 002 - ScriptB, etc.). I've been running them all manaully one by one so that I can look for errors in the re...more >>

hi I have around abt 10 fixed width text files in a particular directory of the hard drive . I want to automate the task of importing all these files into 1 table of SQL Server. All the files have the same fields. How do i do this....more >>

I have a table with 40,000 keys on SQL Server. In a SQL Task I can create a recordset from that table as an output parameter in a global variable. I have ODBC access to an Informix DB in DTS. I don't know how to join the Informix Table with the SQL table. I don't know how to make the Informix a ...more >>

I'm trying to schedule a DTS package that generates a flat file and then does an SFTP upload of that file. The package runs a batch file (using an execute process task) to do the upload. The batch file contains commands for an SFTP command line program (exe file) to do the upload. When I run ...more >>

I have a Text File (Source) Connection object. I need to dynamically control the Record Length to properly read some non-standard CSV files. When you use the Text File Properties dialog and specify a Row Delimiter of NONE you have to also specify the Record Length. I need to specify the Re...more >>

I have a package (A) which executes another package (B). The executed package B contains a custom task. Package B executes correctly when run by itself, but fails with "Not implemeted" when executed from package A. If the custom task is removed from package B, it runs OK when executed from pac...more >>

I am converting data from a multi-dimensional database which means that many of the columns are in-effect sub-tables that have delimited values. As a result for each of these columns I need to create/insert/update a table. Does DTS have a function that will do this? Thanks ...more >>

...anyone have a solution to this. Have 100 excel files stored in a table in binary format and need to export them...have an asp application where I can pick them one but would of course prefer not having to do that.... ...more >>

Hello there, I have a VB6 application that runs over a SQL Server 2000 Database. Sometimes (most recently) i get the folowing error: Run-time error -2147467259 (80004005) Location: q:\SPHINX\NTDBMS\storeng\drs\include\record.inl:1447 Expression: m_SizeRec > 0 && m_SizeRec ...more >>

Hi Everyone im using the sql package (send mail task) & it work fine on my machine when i try to run the job on the server(other machine) it gives me an error say: "Initialization of MAPI Failed , Please make sure that you have messaging services installed on this system" Any Idea About what...more >>

What is the ASCII Equivalent to the SQL 2000 NULL? Chr(0) would have been my first guess but it does not import into SQL 2000 as <NULL>. Chr(20) is what SQL 2000 gives you when you export a NULL to a CSV file, but SQL 2000 does not import Chr(20) as <NULL>. So someone please tell me wha...more >>

I have created a DTS package. Now I have schedule the package to run under the SQL Server scheduler. When I execute the package manually, it runs just fine. When I run the job from the scheduler it fails. Below is the complete error message. The package is simple. It opens a text file an...more >>

I have some scheduled dts packages. They error out with this message every time. I can run the package manually with no problem. Step 'Copy Data from AGENCY to [CMHC].[dbo].[agency] Step' failed Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description...more >>

I can not get the Connection Property to close when trying to create a connection using an ODBC data source. I click the 'OK' button and nothing happens. Any Ideas????? ____________________________________ Wayne Blosat VP of Information Services PRO Consulting Services, Inc. 713-523-1...more >>

Hi, I am a new user to DTS. I have worked in VB 6.0 to connect to Oracle before. I'm now trying to get some stuff done using DTS. I've been experiencing trouble connecting to an SQL server , querying it, and using the results in an ActiveX script coded in VBScript. I'm stuck in my old ADOD...more >>

I am running a DTS project that calls 10 execute packages in a workflow to create flat ASCII files from tables. I know that in order to change the Source Server and Database name in the Microsoft OLE DB Provider for SQL Server, that I will need to pass in a global variable, but I am clueless ...more >>

In my dts I have a logic in activex task where if file exists then sucess else is fail. I wanted to have an outcome of DTS as sucess, becuase the DTS actually runs. How do I do this. I try to have a laststep activex-sucess but it is not working....more >>

hi, I have flat file with atleast 500,000 rows with fixed fields. But, the rows were divided into 5 different types of rows. First 3 columns are same, 4th column tells us what type of row it is, in all rows and each row length is around 80. The remaining columns are different based on the r...more >>

Hi It is possible to make DTS skip a number of steps according to the result of a query for example: IF (SELECT * FROM Modified_sage_tables WHERE filenme = 'ACCESS1') IS NULL GOTO "STEP XXXX" ELSE GOTO "STEP YYYY" Where "STEP YYYY" and "STEP XXXX" wou...more >>

Hi All, I administer a production database. I wanted the user to read the database using a query analyser or anyother application. But I should avoid any user to use the DTS Import/Export data wizard to take out the data. Since the data being very critical to the business, I don't want any on...more >>

The Excel file are like this: Jan Feb Mar Cost 1 2 3 Sales 3 5 6 .... The SQL tableA have colunms named cost, Sales,... and Month. It looks I have to turn the table 90 degree. Any one has good solution? Thanks...more >>

Hi I currently have a DTS package scheduled to import some data from an odbc datasource into sql. The problem is that the data needs to be more up to date. However the import process takes quite some time and during the updates the data is incomplete or unavailable. Ideally I would report...more >>

I have a table that I need to reference that is not always in the same database as all other tables. I have available to me the database name the table exists in but can't get my sql statement to accept an input parameter containing the database that I need to join to. Does anyone know how...more >>

I have the following code where I am executing the steps. My problem is how do I not execute the steps and set the DTSTaskExecResult as Success? If DateDiff("h", File.DateLastModified, Now ) <= 24 Then Set oPackage = DTSGlobalVariables.Parent oPackage.Steps("DTSStep_DTSExecuteSQLTask_1").Exe...more >>

Hi, I try to load in a ActiveX script a DTS Package containing Analysis Services Task. But the "LoadFromSQLServer" command hangs before retrieving the Package information. For other DTS Packages the "LoadFromSQLServer" command is working fine. Thanks for help. Hermann. ...more >>

hi I have two tables which I export to excel with DTS with option drop and recreate table. Problem is that excel file is after export around 3 Mb and if it is open, saved and closed it drops to 1,6 Mb. Becouse I need to automate this is it possible to do something to initialy get 1,6 Mb after e...more >>

I have a package with several steps (execute package tasks) which execute other DTS packages. Attached to each step, I have an ActiveX workflow script to check the exection of the previous step (the ultimate purpose will be to act as a failure step and send mail). This script, as expected, run...more >>

Hi! I am trying to execute stored proc to tranfer data to another database. THe stored proc executes successfully in query analyzer. When I try to execute as a step in DTS designer, in the transformation, the source does not show any columns and gives message invalid transformations. I have...more >>

Hi All! What are cons and pros between DTS packages stored in SQLServer vs. Structured Storage File Can a package stored as Structured Storage File be edited in Enterprise Manager? How can it be opened? Thank you in advance...more >>

I have a DTS job that can run many times successfully, but every few days it fails. When it fails, the process is using all of one of the CPU's (I have a 4 CPU machine), but is using very little memory and has zero I/O! I have to stop and start the SQL Service before everything will return...more >>

Hi, I use DTS FTP Task to ftp files. When i log in to the FTP site, i get into the Inut directory. How can i specify that i want to change Working directory to Input and choose the file i want to ftp in to this? Is it possible in the FTP task? Thanks much.. *** Sent via Developersdex htt...more >>

I am very new to the SQL 2000 package and would like some help with DTS. Can I use Stored Procedures and, if so, how? I created DTS package, added a SQL connection and added an Execute SQL Task, but the only thing listed are tables and views. Thx...more >>

We have testserver and Production sevrer. We have DB named say sampleDB in testserver,which needs to be synchronizeb (i.e data ,structures , views,SP,etc(all objects)) with production server. thanks in advance....more >>

Greetings All, I am trying to create an ActiveX Script Transformation in SQL'r 2000 DTS job, getting data from an access database. The data is in 2 fields - a Status_Date column and a Status_Time column, both of which are defined as Date/Time in Access. The Stutus_Date column holds only a dat...more >>

I have a script to remove double quotes in my table, however, when it gets to the identity column it errors out. How can I overcome or skip over the identity column using this script? /*=================================================== BEGINNING OF SCRIPT ==========================...more >>

hi, I would like ask about the DTS, when I deisgned the package and schedule to execute it automaticlly by daily. But it cannot work properly. By manual is ok ! Don't know why? -- Regards, Tarek ^^' ----------------------- Tarek's WorkShop...more >>

I am attempting to copy a table from one SQL 2000 server to another. I am using the Copy Objects/Replace Existing options. The task runs for about 15 seconds and then it fails with an error "Line 2: Incorrect syntax near 'Advisory'" Line 2 of what? Where can I find the script or whatever it is...more >>

Hi, I've a testpackage which i'm trying to adjust. What i would like is to import multiple textfiles (because there are files with the same name) and archive them. The package is from sqldts.com so i'll paste the activex scripts: Script 1 - Defining the Global Variables: Option Explici...more >>

Hi, I tried to use the following code but the error occurs at abc.send "ActiveX Component can't create object, any idea Thanks Ed Dim abc Set abc = CreateObject("CDONTS.NewMail") abc.to = "To@CompanyName.com" abc.from = "From@CompanyName.com" abc.subject = "Hello World" abc.send...more >>

I am programmatically loading and executing packages from VB.NET. When ActiveX script tasks instance objects, such as ADO, and those objects fail, the only error indication I get is a GENERAL DTS error. The error of the underlying object, from the script, is lost. For example, ADO COMMAND TI...more >>

I have a text file that is 25 fields long and contains about 150,000 records. The text file comes from an export of paradox data. The data isn't scrubbed very well, when i tried to take it directly from text file to database, gave errors such as invalid column, etc. That is because there...more >>

Hi, I've a problem with a GUID column. In my target database the column disallow Null values and the default value is mewid() So, when I try to insert a null value, then a newid is generated. but this doesn't works through a data pump task!!! I always received the error "unable to insert ...more >>

I have an intermittant problem with a DTS package that stops running on step 8 or 23 steps. The package is executed by another DTS package using the execute package task. When this problem occurs, the "problem" package exits without creating an error in the "control" package that runs it (or...more >>

Is there a way to determine the name of the SQL Server instance to which a DTS package is stored? I would like to be able to determine the instance name so that I can set the properties of a connection object to that instance name. My aim is to be able to store a dts package on each instan...more >>

Hi all Is there a way to retrieve a lost dts package password from some where in the sql server??? Any other idea how to reopen a locked package will be highly appriciated! TIA Rea ...more >>

Hi, I'm taking over from a DBA who has a number of DTS packages defined and scheduled. I need to stop some of the packages from executing, but I can't find any place where I can do this. Any help appreciated. Thanks amit...more >>