Hi, I'm looking for a good data encryption tool which can be run from within a DTS package (and therefore probably must have the capability of being run from the command line). The idea is to create a text file, encrypt it, and then FTP to a remote FTP site. Conversely, another package must pi...more >>

Just wondering if people agreed that an option to snap dts Connections and Tasks to a grid would be worthwhile? Personally I would find it just a little bit neater, not for any particular technical reason.. ...more >>

Hello I have this pattern that I want to use to match parts of the string to the (city, state zip_code) pattern. I know that it works outside of DTS but when I try to use it in my DTS package I get this error --------------------------- <DTS Testing Transform Task> --------------------------...more >>

Hi all I have a problem with an SQL Server db, which is proving quite tricky to solve. I deleted a table dbo.Addresses and created a new one dbo.AddressesV2. I changed all the relationships with other tables to reflect this change, and the db runs without a problem. The problem rears its...more >>

i'm trying to use in a DTS package the Dynamic properties task, i tried the ini file option IT WORKS and i'm really satisfied, but others are not, so i tried to use the sql query option and i have an error which is "the database is read only or the object does not exist" (sorry translated from ...more >>

We have a dts job that has a password assigned, but not remembered. Is there anything that can be done to get into the package and reset password? Thanks in advance....more >>

We have a series of COM+ components which are called from ASP pages in our application. The components are enabled for different levels of Transactional Support - either "Supported", "Required", or "Not Supported", depending on the specific component. When any of the components which are enabl...more >>

Hi, Is there a way in SQL to create a date/time variable in a table and format the variable as "Short Date"? If yes, can you tell me how? Thanks for your help. Jen...more >>

Hi All I am trying to track down some information regarding DTS performance and best practices when performing a data pump from SQL Server to Oracle 9i. I am specifically looking at the maximum throughput achievable by DTS and any documentation available on how to use DTS to ensure the...more >>

Dear all, When I create a new version of a dts package I want the scheduler to point at this version without right clicking and hitting the ‘schedule package' drop down is there any way to just amended the scheduled job. How do I put an identifier in for this new package? Many thanks Sam...more >>

I'm attempting to run a DTS data transformation task from a SQL 2000 table to an Oracle Table. When using the "Test" button under the Transformations tab it reports a positive test. But actually running the DTS Package I get an error (shown at bottom of post). The error message talks abou...more >>

I have a problem when expoing VIEWs from one table to another (using the Export/Import Enterprise manager tool). In the destination table they appear as tables ... not as views. Any fix for this? I use SQL2000SP3 on IBM netfinity machines w. W2003. Stefan Nilsson ...more >>

I am executing this from an ActiveX script within a DTS Package. I am attemtpting to turn the Automatic Error Checking off. Can I do this? Here is my code ---------------------- Dim checkRange For Each checkRange In xlsWorksheet.Range(Excel_Range) If checkRange.Errors.Item(xlNumber...more >>

I am trying to import a table into a cdf database to get it from Goldmine into MS CRM. There is a "ContactID" (int- pk4) field that evidently is the key in the cdf file but there is no matching field in the source data. Do I have to somehow create a new column in the source data in order to ...more >>

is this a SQL DB? if so how can I export it into a text file? the .mdf file is on my C:\ currently. I archived it from my Websense app. thanks Antz...more >>

I am experiencing a very odd DTS problem. Below is my sample DTS code: 1. New DTS 2. Create a SQL connection 3. Create a Text destination 4. Create a Transformation to move a table from SQL to Text - no transforms 5. On the source select an existing table 6. On the text file destination - I d...more >>

I have a DTS Package that has 2 tasks and 1 connection. Tasks 1. ActiveX module that reads connection properties from a text file and iterates thru them changing the connection properties of the Package connection. 2. ExecuteSQL task that has my script and uses the connection. Here is my pr...more >>

I'm trying to get my DTS job downloading from Oracle to delay for 3 hours if the I cannot find a specific record in an Oracle table. I tried to use "On Failure" but it doesn't seem to work since nothing seems to fail. What can I do? Thanks for your help Dave Wong...more >>

Hi I am importing several textfiles to different SQL-tables, through a local tasks in DTS it works very well, but.... The ANSI-textfiles has one header row with a different layout so I skip it through Skip rows=1. When I look at the textfile in the Connection properties (Fixed Field Column Posit...more >>

Hi I want to export data from SQL server 2000 to text file. I am using Transform Data Task for the same I am facing peiculiar problem in exporting columns which have 'bit' data type. In text files, the values for these columns appear as True/False instead of 1/0 How can I ensure presence of 0/1 ...more >>

Is there a (n easy) way to find out which DTSpackage is run by a job? The number given in the jobstep is does not ring a bell. Tnx, Hans Brouwer *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

Hello all, I want to be able to upload an excel file with the fields layed out a certain way and create a database and a table and insert the rows from the excel file into that table. I have everthing set up do do that except I have to go into enterprise manager in order to import the excel fi...more >>

Hi, This is a follow up of my earlier (18 april) described problem... I am trying do to an export of my SQL tables to Access, by running a VB file generated by the DTS import/export wizard. The first time, everything works; all tables are created in Access and filled with data, however......more >>

i use a dts package to maintain a standby server - this dts package does the following: creates a complete backup file on main server restores this database on the main server as a 'temporary' database some sql is ran to remove sensitive information from the newly restored 'temp' database on ...more >>

Hello I am intermediate level database programmer. Now in our organization web programmer complete one web site with sql server as a back end. Now we want to upload that database to our web server (web host). They have same version of sql server. I don’t want to use DTS (Export tool Can you...more >>

Hi I ca't get the Popup method of Windows Script Host to work. Specifically, I can't get the Popup to disappear after a period of time (nSecondsToWait parameter). Task currently executes to display popup and holds till user completes task (clicks a button) I am implementing the Windows scripting ...more >>

Hello everyone, I am receiving an error when I attempt to import data into my SQL database from an Access data file. I receive an Invalid character value for case specification. The exact error is as follows: Error at Destination for Row number 1646. Errors encountered so far in this tas...more >>

Hi, I have a DTS package that contains an activeX script and a "Microsoft OLE DB Provider for SQL Server" connection. I have defined the server and database to use in the connection. How can I from my activeX script get a list of tables, table indexes by somehow referencing the connection I ...more >>

Hello, I am trying to import a database from another box using the EM gui. When I run the command I get the following error. Errors: [SQL-DMO]The Bulk Copy execution failed. I am having problems with the 1st database and need to remove the instance. The databases are having problems trying...more >>

sql2k sp3 I have a DTS package that shoves the results of a query into Excel. It converts the 0's in my bit fileds into the word false. How can I stop this from happening? TIA, Chris ...more >>

Is it possible to install the new DTSRun.exe on an old SQL Server 7? I have SQL server 2000 as well and have created packages with the new client. When I try to run them on the old server, the error invalid switch for /A comes up for the global variable paramater. Thank you, Lon...more >>

I have set up a Job to run several DTS packages, each package is simple and contains only one step. Basicly it copies a table from another ODBC database to the SQL server. What occurs from time to time is that the job fails. I can go into enterprise manager and run the DTS package manually and...more >>

How does end date work in a regularly scheduled package? I have a package that needs to run daily until April 24. I need the package to run on the 24th. If I choose an end date of April 24th, will the package run on that day or not?...more >>

Hello: I have an Access 2k database that I am using as reporting tool. I need to pass some parameters to a DTS package via a form in my database. Several people in this forum have informed me that the I need to use the ? placeholder and a parameters button to accomplish this. I und...more >>

How would you do the following in a DTS package if MS Access was not installed on the server? Set obj = CreateObject("Access.Application.9") obj.DbEngine.CompactDatabase strPathToMDB ,strTempDB Is there another object used by dts to work with Access databases that would allow the database...more >>

Will DTS work with the Pervasive database engine? If so, are there any limitations that anyone is aware of? Thanks for the help...more >>

Hi, I have a DTS with several tasks. On of it is een activeX-script in VB. Is it possible to debug the DTS or the active-X script? How can I do this? Thanks, Nicky...more >>

I want to import some data into my MS SQL server thought DTS. I have all the filed import ok apart from the date feild as it is in a string format IE 20040408 which relates back to YYYYDDMM. how can i convert this date into a format a format that can be imported into my TimeDate field? ...more >>

I have created a DTS package, and get errors on some datetime fields when I attempt to run it. The source data is in the 'yyyymmdd' format. The destination field is datetime, and the transformation type is datetime, with the format of 'MM/dd/yyyy'. Some of these data fields work perfectly, but s...more >>

When importing Excel data into a SQL Server table, sometime DTS/Enterprise Manager tries to read one more empty row. This causes an 'not Null allowed' error for the PK column. Also, sometimes when previewing the source data, data in some cells were missing. This also caused an "not Null...more >>

hi to all. I'm executing 'DTSRun' in command prompt. DTS package contains calls to 3 subpackages each of them has about 10-15 tables to run data transfer. The problem is that if any of the tables failed for any reason I can only see the errors in the dos command window, but not in the log file(e...more >>

Hi there, I wonder if anyone could point me to a resource where DTS autorization & security is covered in-depth. I have this situation and I can't reason why things are working and why NOT: I have a DTSpackage on SQL1, which copies a table from SQL2 to SQL3. When I run this this package fro...more >>

Hi, I've created a DTS which pulls off an XML doc from a url, stores some of the values into dts global variables and then runs a query based upon these values. I now need to run this DTS from a stored procedure, but I need to pass a value to the DTS to be used as a DTS global variable. ...more >>

I've writen an activeX script to get an xml doc from a url and then assign one of the nodes to a global variable. I then want to pass this variable to a SQL statement and thought I could do this still using the DTS. So I set up a connection to my SQL server and a sql command. The statement is:...more >>

Hi I am sending data across the internet from one SQL Server to another using DTS (using a Tranform Data Task). 1. Is it possible to encrypt the data sent ? 2. Is it still possible if it sends it from an access database to SQL Server ? I am using SQL Server 2000 Thanks, Craig...more >>