Could someone please provide me a piece of activex script code which will "get" a file from a ftp site. thanks Mohan...more >>

I am trying to copy data from one SQL server to another (hopefully on a schedule soon). Anyhow when I run it, I get the following error: Error at Destination for Row number 246271. Errors encountered so far in this task: 1. The statement has been terminated. Violation of PRIMARY KEY constra...more >>

How to export data to a fixed length text file in which numeric data fields are right-justified and text data fields are left-justified? Thanks....more >>

hi. I have a DTS to import data from a file. Due to the file is large, it will take 1-2 mins to import to database. Step 1: delete data in destination table (Execute SQL Task ) Step 2: Import data to table from a txt file (Text file Source -> Microsoft OLE DB Provider for SQL Service ) Ste...more >>

Hello everyone, I have implemented a DTS Package (call it Package A) on a SQL Server 2K/SP3 enviroment. I know that there is a COM that you can reference in a VBA enviroment that you can use to execute/create a DTS Package on a SQL Server. What I need is a sample code that shows how to? I need a...more >>

I currently have some global variables in DTS. How do I pass these Global variables into a SQL script of the DTS package. ...more >>

I'm writing a DTS custom transform that is to take a Packed Decimal field from a file, unpack it, and then insert it into a sql server table. So the source for my transform is a file and my target is SQLServer. The transform is working and works fine with the source as a character field an the t...more >>

I have a dts package that updates a database each day. The db has about 8 million records, and the updates affect about 200,000 records. I am wondering how often, if at all, I should use the shrinkdatabase command? I have already coded the command into the dts package, but it takes so long...more >>

I need a little direction about how a the text file (source) "file name" for the connection works within the package. Here is my situation. I have created a package the reads a text file and puts into a SQL table. Everything works great on my development machine. I have moved the packa...more >>

I noticed that saving to Meta Data Services is no longer available with SP3. What happened to this option and what was the reason for removing it?...more >>

I've got an application that is currently converting date data into a numeric format, and storing the dates as an int data type in the database. I'm guessing that, given the language the application was written in (VB 6), the application is just doing using a cint() function to do the conversio...more >>

Hi all, Using the DTS services I can schedule a report in Excel of my data in SQL 2000 at the start of every month. There are a few requirements that I have to meet. At the end of every month I want an excel repot done for ONLY that month. So on the 1st of September, I would want a repor...more >>

Hi Dhaval made DTS to fetch data from oracle. While exectuing a particular step it gives me the following error. It fetches around 35,00,000 records and it gives me error at around 34,00,000 record. can any one help me in this... Error description Description: Error: 1204, Severity: 19...more >>

Hi there, I am trying to get the SQL Data onto Excel sheets using ActiveX Script in DTS. Is that the right approach. I am also using some global variables in the SQL Task to get the output parameters from stored procedure so that source sql statement can be dynamically changed depending o...more >>

I change default data directory and default log directory in SQL Server settings to C:\DB_Data\. When I'm creating new DB it's creating everything fine in folder C:\DB_Data\, but if I'm doing DTS with creating new DB on source server then it's creating data file and log file back in C:\Pro...more >>

When I attempt to run a job that executes a DTS script I'm recieving this error. I can run the job successfully if I open it. Could this be because I created the job using SQL 2k and I'm running it on a SQL 7 server? I can schedule the job and run it fine from a 2k machine. MS online d...more >>

I have a dts package which takes input as text file name( from global variable) and then transfer the data to a table.I run this dts package from c# program by assigning different file name. Each time it loads to the same table. The new requirement has come. The input file is a tabdelimi...more >>

We are writing new interfaces for an SQL application and will have a lot of uses for either DTS Active-x scripts or SQL Functions. I know DTS Active-x conversions can be time consuming when processing a large amount of records. Has anyone compared using an SQL user defined function embedded i...more >>

How do we deal with packed data while using the DTS import facitlity. The data provided is a fixed record length flat file with sepcific record legths packed to reduce data size. Does Sql Server 2000 offer any utility to unpack this type of data fiel to import into a table in the server. ...more >>

Hi, all! I'm a newbie...sorry. Here's my problem. I don't know how to see what a scheduled DTS package actually did...and to store those results for later review...other than have the stored procedure(s) involved write records to a table that I've called ImportMsgs. When I run the packa...more >>

Hi I execute a dts package from an Access database to import SQL Server tables into the Access database. It works and fails randomly! As a last resort, I executed the package in a loop so it tries 10 times before telling the user it has failed. This has worked around the problem as it g...more >>

I am relatively new to the SQL world and recently started managing a number of SQL server. I have discovered DTS and find it a very powerful tool. I have been working with it enough that I am finding myself needing the variability that I can get from my VB scripts. I keep reading about this grea...more >>

Is there a simple way to do a full SQL Server instance move to another server: all DBs, DTS packages, Jobs & other Management functions, Replication, Security, ...? On the DTS packages - ours have a server name coded into the DB connections. If moved to ServerB, will all the ServerA con...more >>

Hi, I am in a huge crisis. I have to export more than 400 code tables into csvfiles. Each table should be exported in to seperate file. I have to create a package to execute all these tables into files. All the code tables are in different layout. I have two questions 1)where do i write the sc...more >>

I recall seeing a package available that would allow you to track the execution of a scheduled DTS package. IT was called, Mosaic DTS Audit Task. I can't seem to find this anywhere. Does anyone know if this or a similar product is available. Thanks in advance for your assistance, Paul...more >>

In DTS I've created some local packages while I was signed on as "sa". The packages work fine and are scheduled appropiately. The jobs under owner I have a different user and that user is the user asigned to the SQLagent. and it all works perfectly. However, when I change the "sa" pass...more >>

On SQLserver2000, I have created a "Database Maintenance Plan" and everything works fine. Except for the "Remove files older than X amount of time" in the Transaction Log Backup" TAB. It works fine for the "Database" and "Reporting" tabs respectavely. Any ideas on getting the "Remove ...more >>

Hi, I have a question: I have a DTS package with two tasks: 1. A Copy SQL Server Object Task: to copy a table object between two database servers 2. A Execute SQL Task: to delete all rows in the table previously copied This is a database used by a web application, and there might...more >>

How can DTS Package be secure after it has already been save without no passwords secutiy....more >>

I have 2 tables 1 & 2 on a SQL Server A. I have a DTS which calls the tables 1 & 2. This DTS in on the same server, server A. I scheduled a job which runs this DTS once a day, it is also on server A. Is it possible to have this job schedule on another SQL Sever? Or to have the DTS on another ...more >>

I have a DTS than uses the File Transfer Protocol Task to copy a number of tables. One of our IT staff moved the folder where these tables are found. When I changed the Source Directory Path, I received an error message: "You have changed your FTP source information. All the files you ...more >>

I am new to DTS but I have quickly found that it is very Powerful. I have started building my transform that inserts records into a "holding" table. I need to check to see if an ID exists in another table. If it does get the values from 3 fields if not then use some constant values. I ...more >>

I can manually execute a simple DTS package that has a 'Microsoft OLE DB Provider for SQl Server' connection. Although when I try to schedule the same task the following error is given. The process could not be created for step 1 of job 0x99646A80FF6D8E44BCD580840B5DA56A (reason: The sys...more >>

Does anyone know where I can download the hotfix for the known problem documented in the Microsoft Knowledge Base article indicated above (#814113) ? G....more >>

Hi, I have a problem in dts package workflow implementing activex script... I have a dts package which contains several steps. If everything goes well, email is sent to support persons. But they requested to be informed even if dts package failed (customized message, so I cannot use Operat...more >>

I have an file.dts package that I want to get into my database...where do I import it from?? Thanks ...more >>

I am trying to set a gloabl variable in a DTS package as today's date, to update daily. I know in other programming environments the use of "now" accomplishes this task. Is this possible in this environment, and if so, can someone please advise me on how to do this? If there is an eas...more >>

Like many others i have a dts procedure that runs fine manually but on a schedule fails. I have all permissions set as admin and the servers are communicating. When this problem actually started is when I updated the MDAC to 2.7. It was running fine prior to this. I am using sql 7. No error me...more >>

Hi I had an old architecture where VC code did a lot of data churning, now I have converted them as DTS tasks. I suddenly realise that the data files get full very soon, there is no great change done from existing arch, except that there is a table that holds ingested data until processing is ...more >>

I have a simple dts package that copys a file from one folder to another folder Using the FileSystemObject when I try to execute it I get a prmission denied error. Who do I need to give permissions to move the files?? thanks ...more >>

I know, I know. All of the MVPs are saying, no!! not this again. Go read Q269074. I have, and everything else. I have jobs that were working fine until last week. Now I get the dreaded and standard error... ------- Executed as user: TMANT\NTADMIN. DTSRun: Loading... Error: -2147217900 (...more >>

Hi, due to a screwup when updating DTS jobs, many jobs on our production system have been destroyed. Form research I understand it is possible to restore local jobs from msdb..sysdtspackages. Is it also possible to restore packages stored in the repository ? thanks conor ...more >>

I've got several packages running on a server that copy tables from an ODBC compliant data source to SQL Server. When executing the packages via Enterprise Manager on my local machine, they run fine, using the DSN's setup on my machine. However, when the packages are scheduled and run in the m...more >>

I get an access denied error when I attempt to delete and access database file after importing it using DTS. It appears that DTS holds on to the file until the package completes. Here is what I am doing. The file in question is an Access.mdb file If file NewFile exists rename to Process...more >>

I have used sqldts.com as a source of the majority of my information to create a DTS package that loops just like the example "Looping, Importing and Archiving" however I am not using the file system, I am using a list of servers. I have a DTS package that loops through and saves data onto sev...more >>

I need to find a way to get around a DTS error produced when I try using a certain text file as a data source. For a screenshot of the error, pls view the following link: http://www.danallen.com/299- ReleaseArea/2003_07_15_TextfileProblem/DTSError.JPG Links to both good and bad d...more >>

Does anyone know how to use a DTS package to schedule a stored procedure? I am using SQL server 7.0. All I want is my stored procedure to run at a scheduled time, I am not concerned if I dont have use a DTS package for that. ...more >>

Can we insert one Source row ,multiple times on the destination usind DAta Driven Query task or Tranform Data task. If thers 1 row on the source ,I want to insert 4 or more on the destination with the sane value . IS that possible. Plz let me know its urgent BAbu...more >>

I am writing a VB app. It will be run from within an 'Execute Process Task' What's the best way to affect the task from within VB so that it will be either a success or fail? Thanks! ...more >>

Hi, I wrote the following VB Script code to import data from Access 2000 table "Time" column: ----------------------------------------------------------- Function Main() if (DTSSource("Time") < 1/1/1754) then DTSDestination("Time") = "2/2/2079" else DTSDestination("Time") = DTSSou...more >>

I have a DTS package in which I am trying to open an Excel application and dumping data from database. When I execute the DTS package by itself it runs without a problem. But when I am calling this DTS package using a Stored Procedure and I get the Following error "ActiveX component can't ...more >>

I do not have the cache turned on, but dts is cacheing the information every time I run the package ( The package runs faster almost every time). How do I stop DTS from doing this? I need a clean run each and every time I run one package or any other package ...more >>

I have a DTS package that runs fine when executing by itself but when I try to execute the DTS package from a Stored Procedure I am getting "ActiveX component can't create object: 'Excel.Application' " See below for a detail error that I am getting when run from a Stored Procedure. Can any on...more >>

I need to use a DTS Lookup, I would prefer to use a SPROC or UDF as the source however it appears to only take a paremterized query is there a workaround for this??????...more >>

I'm looking for an example of one column in an Excel spreadsheet being imported into a Sql Server table. If anybody can point me to an example, it would be of great help. Thanks in advance....more >>

How do i get the package lineage inside the DTS pacakage? I would like to insert the lineage to a log table when the pacakage is executed. Can anyone help regarding this? (The LineageFullID property is exposed by the DTS.PackageLineages object. But i'm not sure how to get the lineage for th...more >>

Hi, I want to Compare the Date time by the following VB Script code: ----------------------------------------------------------- Function Main() if (DTSSource("Time").Value < "8/8/1754") then DTSDestination("Time") = "2/2/2079" else DTSDestination("Time") = DTSSource("Time") ...more >>

I have text file which will be inputted to the SQL table. How can I check if the row is already existing in the SQL table (the first column is the key) so I do not need to add the record (from the text file) to the table since there is an existing value. What is the best way to do a look...more >>

I have a package runing between 2 servers in different domains, I can run it manually noproblem, if I schedule the job it fails with error 208 in eventvwr I assume this is a security/permissions thing, but I am not sure why the schedule fails and the package executes....more >>