I have created a task that executes a simple query: select count(*) from ifsmessages Within this task I have created an output parameter called gMsgCount with a data type of int. I have given it a parameter type of Row Value. Next I created an ActiveX object with VBScript language. Eventually...more >>

Hi all! I have a package that imports data from a text file, located in an specific folder. My problem is that many files can be inside the folder and their names are unknown for me. How can I find out the name and quantity of files within the folder, and use these informations into a dynami...more >>

We have several backup jobs on MSDE. How do I monitor these jobs and get notified when a job fails. What are the different notification possibilites with MSDE. ...more >>

How would you test if there is established connection to a data source and then use this information when continuing...? If no connection abort operation.... ...more >>

Whilst importing a CSV file, DTS fails on fields with commas in them. The text fields are surrounded by quotes and I've managed to get other pieces of software to successfully read the file, but not Microsoft Office products. DTS seems to have set the Text Qualified property to Double Q...more >>

How do schedule a DTS package to run at certain time using a certain userid? Thanks,...more >>

I am trying to run DTS pakage as a job and the job fails because it does'nt have read access to required files in the file system. The job runs to completion when run from the console but not from CmdExec in the job. The files and directories have full control for all users. Any ideas. *...more >>

In a DTS package, I am trying to define the transformations between the source and the destination. I have selected the "Copy Column" type and went into the "Transformation Options" dialog box. I selected my source columns and my destination columns. My problem is that when I then hit the ...more >>

Hello Why DTS Designer doesn't shows description of Data Transformation Task, as it does make for any other kind of task? It's pretty uncomfortably. Thanks, Vladimir Chtepa ...more >>

Hi, I have a foxpro database--not sure what version, but it is a .dbf file and I know it is foxpro. I need to get the data out of the database and into sql server, so i run my DTS, and I am asked for a data source. I then select Microsoft FoxPro VFP Driver(*.dbf). Then, I go to creat...more >>

Hi, I have 2 tables: 1 contains postcodes and map coordinates - tblpostcodes. The other contains new locations with postcodes and map coordinates tblpostcodes - tblnewLocations. eg: tblpostcodes ------------ ID Postcodes Col1 Col2 1 GU6 8NQ 504.5 139 2 GL20 5PA 389.2 232.6 t...more >>

Hi All, Can any one give me an idea in how to plan the popluation of Fact Table in a ware house ?. ...more >>

Hi, Is it possible to write to the application log from within a script in an ActiveX task? It's pretty easy to do with a custom task in VB, and there's also an undocumented system stored procedure that let's you do it (although you need to be running under high priveledge to use it), but i...more >>

Hi, I made a very simple DTS Strutured Storage File with a connection to a SQL Server and a bulk insert. If I try to use data file on drive C everything is OK but if I try it On Drive D it failed. I checked permission on both drive and everything are the same. I put full control to everyone...more >>

If I have a simple DTS package, exporting rows from a table out to a text file, will that spawn multple threads on the server, and if so, can it be prevented, and if so, how? Thanks! Josh ...more >>

Hi: I want to use a global variable setting in Data Pump Tasks and Execute SQL Tasks. Is there a way to do this other than using a '?' in the WHERE clause? i.e. I want to use the variable in the SELECT part of the SELECT statement. So something like this (which isn't possible): SELECT ? AS ...more >>

Hi, I have a SQL Package with a owner password and a execute password(is this so-called?). This means that a user can execute a package but not look into it. I want to read the package in visual basic.net but i recieve an error on these packages: "Access to package properties requires entry...more >>

How do I compare data in 2 tables if tables are located in 2 different sql servers?...more >>

Hi! I have e excel file that has two sheets and both sheets have text on them. There is text placed on few first rows of these sheets. I want to place data that comes from a strored procedure at the bottom of these sheets. How can I do that? I know I can easily place data on an empty shee...more >>

I have a DTS that access an .XLS file and imports the content to a SQL Server table. I am executing the DTS via a Windows .Net application which in turns calls a store procedure which actually initiates the DTS Package. Folder/File permissions are set correctly. In fact, I do the below as...more >>

I have a Transform Data Task copying from Oracle to MSSQL 2000 with this code: SELECT DISTINCT DATAAREAID, Name FROM CompanyInfo WHERE DATAAREAID in (?) The task executes without errors, but no data is transformed. When I hardcode (substitute ? with 'aaa,bbb,ccc') correct data is...more >>

Hi, I have used the DTS Wizard to generate a DTS script that migrates table data from a Sybase DB to SQL Server. I now want to be able to plug in the DTS Dynamic properties such that I can change both the Source and Target databases. I'm hoping I do not have to edit the original tasks ...more >>

Hi, I currently have a DTS job that movers about 40k to 50k rows from SQL 2K to Oracle 9i DB. I am using Oracles own OLE DB to connect to the Oracle DB as its quicker than ODBC. Its taking 7 minutes to move 2000 rows using a transform data task. So I guess its going to take over 2 hrs to...more >>

Help, I'm going mad with this. When importing a CSV file, DTS appears to ignore that I've told it that text fields are quoted and where a quoted field contains a delimiter, it's simply split that field into two, making the transformation stop due to "extra" fields.... Please, any thoughts a...more >>

Hello, I'm getting the following error when executing a DTS package from VB.Net. The DTS packages runs fine from the designer and used to run fine as well from VB.net "Global variable 'ExportedRowCount' already exists in the collection" Here's my vb.net code. The error occurs right after ...more >>

I'm using the code sample provided at http://SQLDev.Net/DTS/DotNETCookBook.htm to attempt to load a .DTS package in C# through the COM Interop services, and execute it. When the LoadFromStorageFile method is called I get the following error: System.Runtime.InteropServices.COMException (0x800...more >>

Hello, I had created DTS Packages long time ago and they were working fine. I never had any problem scheduling any of them. However, I can not schedule any of the packages I created a while ago or the brand new ones. I receive an error message and described below. Any help on this is high...more >>

I'm running a dts package from an ACCESS2000 ADP with the following code Dim dtsp As New DTS.Package dtsp.LoadFromSQLServer _ ServerName:="xxfs001", _ ServerUserName:="sa", _ ServerPassword:="xyzsde", _ PackageName:="DTSprojectimport" dtsp.Execute ...more >>

We have a dts that has been running for months. Now it won't run - it doesn't even start. Nothing in the logs. And if we try and create a new job from the package, it won't run either. We can't even run it manually. Also when we create a new dts that runs fine when executed as a dts, it wo...more >>

I've read and heard some conflicting information about the best method for setting up a MSDTC resource in a cluster. I am running MSSQL 2000 SP3a and Windows 2003. 2 node cluster with currently only once instance of MSSQL with a great chance of growing. A few questions I have: Should the re...more >>

I am having trouble with this, and when I google the topic there aren't any threads with solutions. The field is postal code, and when I open the file in excel, it says reads "the number in this cell is formatted as text". The destination field in our table is nvarchar, and I formatted the exce...more >>

We have several scheduled DTS packages on SQL Server 2000 sp3 moving data from an accounting package. The transforms occasionaly hang up and the problem may go unnoticed, is there a way to timeout a transform or any other way of detecting this situation? Julian Bowker Marble Steps Systems ...more >>

Hi Folks, I am getting this strange error while scheduling a DTS. What I am trying to do is copy data from DB2 on mainframe to a SQL server table. I created the DTS package and runs fine manually. But when I schedule it, I get this error : Executed as user: MYDOMAIN/SQLADMIN. DTSRun: Loading...more >>

Hello! On SQL 2000 I created with Import Data Wizard package "dtsTest". I get data from Access file on location "C:\Temp\dbTest.mdb". Wizard created "Connection 1" and "Connection 2" icons if I select Design package. I call that package from VB.NET 2002 that way: --- Dim pck As DTS.Package2C...more >>

When using Microsoft Data Link as Data Source, I use SQL Server authentication with the correct password (including the sa account) I test the connection and it succeds. However when I try to get the dts package to use the udl file I get a package error: Login failed fo...more >>

Greetings, I hope someone might be able to point me in the right direction on this one. I am new to this so....... here goes. I have a DTS ActiveX script that I would like to traverse through a series of subfolders and copy selected files, rename them and drop them in another directory. Se...more >>

Hello, all. I'm new to DTS and am currently working on a project to import two CSV files into the same table. Basically, the challenge that I'm having is that each record of the file contains more than one item that needs to be inserted as its own row. For example, FILE1: DATE field...more >>

SQL Server2000 SP3 I have been trying to create a DTS that uses an FTP task The DTS executes fine from the DTS designer window However, when I try and run the DTS from ASP.... On the development server where the database is on the same system as the web-server all works fine my file g...more >>

Hi all, I created a dts package successfully to transfer a number of Visual FPro tables to SQL. When I attempted to schedule this task, the job failed and the task's history showed the following message: "Unable to determine if the owner of job has server access. Could not obtain information ...more >>

Scenario: client wishes to create a utility email account at his company (utility@blah.com) and have flatfiles (typically sent as zip email attachments) emailed directly to it. He wishes to have some form of automation set up to where the flatfile is received by the utility email, automatically ...more >>

Hello All, Suppose, if I have to connect to various Servers dynamically, I will have to use a Dynamic Properties Task. Let us say I first create a Connection, named "SourceSrv" using the "Microsoft OLE DB Provider for SQLServer". To change the connection info for "SourceSrv", I need to c...more >>

Hi guys Just a quick couple of questions regarding the best practice(s) for maintaining a database on two servers: The situation: I have a database on my server which I am constantly working on (modifying structure and content) and I have also placed a copy of the same database on my cli...more >>

Hello, I have a issue with missing and non-operational Connection objects on the DTS Toolbar. I am using SQL Server 2000 in a Windows 2000 environment. The following connection objects are missing: Excel, Access, Dbase5, HTML, Paradox and Microsoft Data Link and Other ODBC Sources w...more >>

Hey all, strange problem here... query #1 displays 357 records correctly and all is well. However, when placed within query #2, it updates every single record in the lta table, what's going on here? any thoughts? 1.) select * from LTA INNER JOIN new_list ON lta.voy = new_list.voy AND lta.p...more >>

My later addition of ON FAILURE sub-packages are not being executed and yet there is failure. Illustration: Suppose package A--success-->B--success-->c is already pre-compiled/Executed (and is running fine). On adding ON FAILURE D, E and F i.e A--success-->B--success-->c | ...more >>

My later addition of ON FAILURE sub-packages are not being executed and yet there is failure. Illustration: Suppose package A--success-->B--success-->c is already pre-compiled/Executed (and is running fine). On adding ON FAILURE D, E and F i.e A--success-->B--success-->c | ...more >>

I'm using the following script to transform my source (a fixed field text file) from yyyyMMdd to a normal datetime field in my destination table. Function Main() dim i_Day dim i_Month dim i_Year i_Day = Cint(Mid( DTSSource("Col006") ,7 , 2 )) i_Month = Cint(Mid( DTSSource("Col006") ,5 ...more >>

Hello everyone, I am using DTS to transform data from foxpro.when it meets the date of NULL,it fails and says"Insert Error , column 4( 'Coloumn_name ',DBTYPE_DBTIMESTAMP), Status 6 :Data overflow ". And then i try to open the DTS Transform Data task and do a preview of the data from the 'Sour...more >>