Hi, This seems so simple, but I can't figure it out. I'm trying to keep a 'seed' value in a global variable as an integer value, essentially a count, to insert as a primary key into a table. So i created an Integer global variable, set its value to 1. I loop through some records, doing insert...more >>

Hi, This seems so simple, but I can't figure it out. I'm trying to keep a 'seed' value in a global variable as an integer value, essentially a count, to insert as a primary key into a table. So i created an Integer global variable, set its value to 1. I loop through some records, doing insert...more >>

Hi, I am trying to use the DTS export wizard in SQL 2000 to transfer stored procedures between from one database to another. I keep getting this error: "Failed to transfer objects from Microsoft SQL Server to Microsoft SQL Server" I also received the following additional info when doublecl...more >>

I am reading data from a flat file and one of the columns in the file is MATERIAL and sometimes the values in MATERIAL column have a control character. I want to do a simple validation as follows if MATERIAL as a value containing only alphanumeric values like A-Z0-9 like the following values...more >>

Hi, I am getting error when I run the following statement declare @a nvarchar(255) select @a = tblname from logtbl where tblname like 'orders%' and logtbl.logdate > getdate() - .5 update @a set @a.log_id = l.log_id from @a , logtbl l where l.logdate > getdate() - .5 l.tblna...more >>

Is there I way to export data into .csv executing code not using wizzards? Something similar to INFORMIX command. UNLOAD TO //path/filename.csv DELIMITER "," SELECT (WHATEVER) FROM TABLE ...more >>

I have a dts package which gets data from the Access database located on another box and imports it into the sql server. If you schedule the package then the scheduler creates job which fail when it attempts to run. The package owner and the job owner is the same account on the SQL Server box...more >>

Hi, I have a sql server with authentication set to Windows only I have a DTS pacakge that does a monthly update a some static data. I load the data like: -deletes the table -create the table -fill table with data It's a big table so this is faster then delete the rows I w...more >>

Greetings, I am going mad with DTS. I have two SQL Servers, one on my PC for test purposes and the other at a remote location. I developed a DTS package on my local PC and on the local SQL Server which contains connections to the local SQL Server and some files on the local PC for text impo...more >>

Hi there, I have some DTS routines which run overnight doing some calculating and some flattening of data and form a Data Warehouse Database. We are currently moving the routines from SQL7 to SQL2000 on another server. Now, one of the DTS tasks is an ActiveX Script task which calls 2 meth...more >>

Hi guys Can anyone advise the best practise for developing DTS for my problem. I have two MS SQL 2000 Sever DBs. One which we call WebCS is a duplication of the other (CS) with a little change. The difference between two database is a table. CS DB has tables called group (id, name, ostype)...more >>

Hey All, I am new to DTS so please bear with me. I have a DTS that generates a txt file output. All the queries, export and that jazz work fine. What I need now is to encrypt that exported file with a public key. Right now I let the DTS generate the file then manually encrypt the file. A...more >>

Hi guys Can anyone advise the best practise for developing DTS for my problem. I have two MS SQL 2000 Sever DBs. One which we call WebCS is a duplication of the other (CS) with a little change. The difference between two database is a table. CS DB has tables called group (id, name, ostype)...more >>

Ok, now that I lost you, here is my problem... I have a folder structure like A 1 1.xml 1.htm 1a.htm 2 2.xml 2.htm 2a.htm 3 3.xml 3.htm 3.html And I need to loop through all the files and every xml file I need to continue the workflow and i...more >>

I have extended stored procedures in the master database that were created by an application. we are looking to replicate the server. How do I replicate the extended stored procedures or even just transfer them over to the new server. ...more >>

Something was wrong with my local SQL Server environment. I was unable to connect to my own SQL Server running on my own workstation. So I uninstalled and reinstalled. I knew my database files would be safe and sure enough, I just reattached them after reinstalling. But where are my DTS Pac...more >>

I'm using the SQLDTS FTP Task and sm trying to use the date offset function to grab files from a dated folder. The source is "/Pictures/(dated folder)". The dated folder is in this format mmddyyyy or 11042004. What I am trying to do is set up the FTP task to grab the files from the PREVIOUS day'...more >>

Hi, I am trying to import a text file using dts package into sql server. While running i get the error as following. Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump Step Error Description:The number of failing rows exceeds the maximum specified. (Microsoft Data Tra...more >>

Hello, I have been learning DTS for a couple weeks now, and have been relatively successful with using the transformations and SQL queries to create statistics tables. However my current task requires that I essentially take one of our databases and make an exact copy of it on the same m...more >>

Hi all. We are using the DTS to get data from one table or SELECT into a .txt file. Both fixed and separated. Our problem seems to be that when we get about 20-30 columns the DTS wizard shuts down unexpectly. We do get this at our place and at our customers place. Is there any limitations on ...more >>

Folks, let me first qualify this - I'm a developer and really don't know a lot about Excel. I need to automate some reports that run every morning. The end user needs Excel format, and I'm somewhat familiar with DTS so I thought that approach would make sense, but I'm having data typing proble...more >>

Hello I am migrating a SQL server from one (old) SQL server to another (new) SQL server. How do I move my DTS Local Packages, jobs, and Replication info from the old server to the new server? Will this be something that I can do with a restore from a taped backup of the (old)SQL server to the ...more >>

The limited documentation for DTS 2005 script tasks says that they can reference any registered assembly. When I select Add References, I only see the Framework assemblies. How do I add my custom assembly to this list? Adding it to the GAC doesn't help, and the VS-2003 registry path where ...more >>

I have a DTS package with 2 steps, step 1 is executing a SP using SQL login and step2 copying a text file to another server. The user who will be executing the DTS has only SQL login. I need to execute step 2 using a domain account (Windows Authentication) in order to be able to copy the fil...more >>

Hi all, We need to deploy a DTS package to a remote server. We have a scheduled job that execute the DTS package. What's the best way for doing this? We are using Win2K, SQL Server 2000, sp3. Thanks, Anna ...more >>

Hi, I have two servers with sql2000, one with windows Nt 2000 and another with windows server 2003. When in the 2003 server I right-clicked on <Local Packages> in <Data Transformation Services> and choose <new package> I got the above error message. I closed everything re-opened Enterpris...more >>

I like to schedule a program call Test.exe to run on SQL Server. I already create a step and the type I select as Operatig System Command. I run the jobs manually but the Test.exe did not kick off but I can see Test.exe in the windows task screen. Pls help -- Travis Tan...more >>

Dear all, I am currently helping my colleague documenting his SQL server processes and would like to know if there's any way to document the DTS packages besides copying it down manually? I have like 100 over DTS packages and it would be really tedious to do the manual way. Thanks! ...more >>

I have several DTS packages (local) that run fine when executed manually from EM, but when run as scheduled jobs they fail with the following error message: Executed as user: AD-ENT\SHEQ_SS. ...nStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnSta...more >>

I have gone through quite a number of threads where people had similar problem: parent package calls child package, a step in child fails, child completes anyway, parent doesnt fail. As per the other threads, I have set the following logging properties: In child package / package properties ...more >>

SQL Server 2000, Enterprise Manager Windows 2000 I have a dts package that runs like a charm when kicked off manually. When trying to kick it off via a schedule, it creates a logged error (see below). I'm not sure how to troubleshoot this. The tasks that are bombing are reading Visual Fox...more >>

For anyone interested, I have a full pass to the SQL Connections conference in Las Vegas next week which I won in last year's drawing. I cannot go and so I am selling it for the best offer I get. Just reply to this post if you are interested. The full cost of this pass is $1395. Don't miss o...more >>

Hi, I receive an overflow error when I execute a package. But what is strange my source has not changed and this morning the package works fine. and now I've the error. and I've change NOTHING on this package, and the data source is exactly the same! I've executed this package 20 or 3...more >>

Hi, I've dts package where i import a textfile with over a 1000 colums. Only the first six columns i use to import to a normalized table (never mind the other columns, i'll worry about them later). My question is, how can i import multiple texfiles based on my dts package. I don't want to m...more >>

Is there a way to launch an Access database setup to autorun from within a DTS package?...more >>

Is there a way to have an FTP task CD to the directory where you need tp copy files from? All I see through the DTS FTP task is the default home directory of the FTP UNIX login....more >>

my requirement is like this i have two pakages 1.inner 2.outer my flow is like this if error occured in outer package then in err handling work flow ,iam calling inner package. if error occured in inner package it has to do some error handling work flow and it returns failu...more >>

I've got a DTS process that creates mdb's for exporting data back to clients based on recent orders paid. The main system is SQL Server but our clients prefer mdb files for their purposes. My DTS process currently looks up orders paid through a certain date, but not yet exported and then inse...more >>

We are storing text and pdf format file in image column and reteriving successfully from java, I need to detach the column value as text file and wondering how do export binary data as text file. Any help is appreciated. -- Farhan ...more >>

Hi I am having some trouble importing certain tables from an odbc database (Sage Line 50). Most of the tables import without any trouble whatsoever, however there are 2 tables (SOP_items and POP_items) that always crash dts when it tries to import them. The DTS screen simply dissappears from...more >>

Does anyone know why the error "Cannot create object" would occur when trying to create an Excel object in VBScript within a DTS ActiveX?...more >>

I inherited a server where some jobs have a dts step that uses "Send Mail Task" to send an email. It appears to require a Profile and password to send the email. The only profile name that appears is "Outlook". The PW is blank. These steps, however, do not successfully send the email so I a...more >>

Using SQL2k DTS, I'm connecting to Oracle 8i using the MS ODBC Driver for Oracle for my transformation task. It's pretty slow and I've read in several postings that I'll have more success with Oracle drivers. I've run the install for OO4O and Oracle ODBC drivers but I can't see either of them ...more >>

Whenever I try to use the DTS wizard, if I do something like the following: Right click Select All Tasks Import or Export Click next I never get beyond that... the "class not registered error comes up (parse display named failed). The same problem in the designer. Please advise if...more >>

hi again :)) everytime after I store my dts-package via vb with Package.SaveToSQLServer the presentation of the package in SQL Server 2000 has changed. the whole arrangement of tasks & constraints has changed and the text-box has vanished... now it is very unstructured and very hard to fol...more >>

I am using the select statement to pull data out of the database and into an excel file via dts. Is there anyway to make 'Log File' appear as a hyperlink in the resulting spread sheet? select s.sch_id, 'Date Scheduled'=convert(varchar(17),s.sch_date,113), s.e_subject, 'Number Processed'=(s...more >>