I need to update/insert reconds into an existing Vfoxpro database from Server2000. I set up a linked server using a VFP ODBC Driver. I can see the table in EM. In QA I can do a select using: Select * from Openquery(LinkedServerName,'Select * from MyTable order by Col_PK') This update statem...more >>

Guys I have this great DTS package which I created from a looping example y'all pointed me towards. Just when I was about to put it into production, I was told that I should not have hardcoded my file names. Well, the purpose of the looping was that the file names changed daily and I wanted to p...more >>

Hi! I have current project wherein only certain fields in the tables in SQL Server would be extracted and transferred to a new Excel file. The thing is, data extraction would be done through the front-end, Visual Basic.NET form, and this would be performed by clicking the Extract comman...more >>

Hello, I have a number of DTSs scheduled under SQL Agent. The first step of these DTSs is to check if a file exists (said file gets FTP'd from a mainframe). As the exact time the mainframe job sends the file cannot be determined (the time the job is eligible to run is known, but depending o...more >>

I'm loaing data using DTS (Excel to SQL 2000). There are triggers and defaults on the tables being loaded. The columns are nullable that are to be updated via insert and update triggers. After the load, the columns have nulls. I'm copying colum from Excel to column into DB. When I update the ta...more >>

Hi Iam NEW to this DTS.. I have created a connection object for my SQL Server database, an Execute sql tak with the sql query and Text file (Destination) connection. When I execute this package, The Execute SQL task runs successfully but not the Text File (Destination). I tried to create a workflo...more >>

I have written a DTS package that executes perfectly when I run it from the Enterprise Manager and also executes perfectly when I run it from dtsRunUI. However, when I attempt to run it from the command line using dtsrun /S"SHELDON" /E /N"CessnaImport it displays the message DTSRun OnStart: ...more >>

We are trying to run a DTS for a database that has a table in it that contains japanese characters in a unicode column. When we run a select against this column, we show no data in the database where the data was DTS's to -- but we do see data in the original table. Is there a setting I am missing...more >>

What options are there for importing and exporting from SQL Server to Active Directory? ...more >>

Hi All, I'm designing DTS package on SQL Server and need to call/execute Oracle package (stored in an Oracle database). How to call an Oracle package from DTS? Cheers, Kris ...more >>

Hello! We´re exporting data from our oracle server through a dts-package into a textfile. The problem is as following: When we run the scrip direct on the orcale server, we get a single 0 as fieldvalue. If we run the DTS package, we have a double 0 in the textfile. I have no idea why? ...more >>

Is there a way to suppress all the results from a DTS package? I have a job that loads a ton of data and I don't want the "1000 rows transformed" messages to print to the screen/log file? Is there a way to have it just not send anything. Thanks....more >>

Hi What is the best way of defining and using constants (for example, error codes) in DTS? I want to use these constants across various packages in my application and in various tasks in the same package Thanks...more >>

Copied new stored proc from development server into the live server using DTS It was successful, but it has dropped the tables & created new ones How's it possible Anyway to recover back the data? thanks in advance!...more >>

I'm using VB.NET to create a DTS package at runtime and write date to Excel 200 Quoting MSDN KB Article: 31995 "If you execute a CREATE TABLE statement against Excel, such as the statement that the wizard generates, this creates both a worksheet and a named range with the same name; however, DTS...more >>

I need to import data from an as400 database, what is the best way to do this? Regards, Sean Gahan ...more >>

I have sql server data which i want to export to access everday with out intervention of the user.I scheduled it. But As the database and tables are same, The data is being appended to old one. I want DTS to export the data in seperate tables( may be with different names) or in seperate databases ...more >>

Greetings Everyone, I am having a very strange problem using Transaction with my DTS package. Here's the scenerio.... I have 2 separate DTS packages for the tasks listed below. 1. In the first package, I import data from a Remote Server to my Local Server. 2. And in the second package,...more >>

I have a table called, "Patient Information". The primary key field is "Patient ID #" When I use DTS to upsize from MS Access 2000 to SQL Server 2000, I get the error message.. "Violation of Primary Key constraint 'PK_Patient Information'. Cannot insert duplicate key in object 'Patient Informati...more >>

My ActiveXScript that executes a proc, gets an occasional error. I'd like to be able to trap the error and do either a msgbox or on error resume next. I know that increasing the timeout and the number of records to process reduces this error. ...more >>

None of my DTS Packages will run when scheduled. Is there some set up that needs to be done in order to get this to run? I right click on the package and click schedule, set it up and it errors. Any ideas would be great....more >>

Hi I have an application that generates an access database of sales figures every day, the filename contains the date the file was generated so changes each day. How can I get SQL to import these files automatically from a specific subdirectory with different filenames and without user int...more >>

I've imported some views from one database to another using DTS. Done it loads before with no real problems The load had a problem with two of the views. I checked and everything was fine with them so tried to load just those two again but it said they already existed in the target database. I ...more >>

hi, I would like to concatenate parameter in the Insert Query of a data driven query task. For e.g. "Insert Into Table1 Values ('Value 1 ' + ? + ' and ' + ?). query parses without error and i am able to map destination value to the parameters. However, when i checked the table, null value is...more >>

I am having a problem deleting a package from Local Packages in EM. I deleted the record from sysdtspackages which was probably a mistake. Now, the package still shows in Local Packages even though the record is NOT in sysdtspackages anymore. When I try to delete it via right-click and delete, I...more >>

I am trying to used DTSSql Task to execute a stored procedure with input and out parameters. I followed the steps mentioned in http://www.sqldts.com/?234 , it works. I changed the stored procedure to include a simple insert statement and return the identity value. The output parameter does not...more >>

Hi, How can I add/delete Owner password after I creation of DTS package? Thanks Hooman ...more >>

I have a task that I want to use a combination of ADO recordsets and TSQL. How do I, for instance perform a count query, and do some functionality based on the the result. Ideally I would like to do a count e.g. SELECT COUNT(idfield) FROM TABLE into a variable and then do some ActiveX functional...more >>

Hi all How can I delete a list of tables with SQL Script Many thanks //H ...more >>

I am trying to use the value of a global variable as a parameter of a stored procedure. The global variable exists and is used successfully in other parts of my DTS package. But I always get an error when trying to use it in the SQL Execute task. This is what I have tried: Exec master....more >>

I received a message when I made the import data from sql 7.0(running on win2K English) to sql 2000(running on windows2003 spanish): the convertion of the varchar value '10240006001' overflowed an int column.maximum integer value exceeded. I apreciated any help thank you. Eloy E-mail:...more >>

Hi all, I have a wierd problem,my DTS packages stored in server does not show steps sometimes all the tasks in the package dissapear in all packages,why will this happen when,is it due to overload of server or attaching tables to access? or toomany connections?? any ideas?? no explanation ...more >>

I've been running SQL Server 2000 SP3 client and server tools on my Windows 2000 server for several months. Recently I tried to open an existing DTS package and get the error: There was a problem retrieving the list of OLE DB providers. Now, under connections, the text connections have d...more >>

We download, daily, a text file with transact SQL in it that drops and recreates a table with updated data. Can DTS import a text file as Transact SQL and execute it? Thanks, Ken...more >>

Question I need export all DTS to other server with the same database. thanks. Fabricio Briasco. ...more >>

I have about 10 machines where data from 10 different departments is stored in MSDE. I have a centralized SQL server where I want to copy the data from other machines and analyze it. How can I write a program which creates DTS package on the fly and copy data from all the 10 machines. I could have...more >>

I have moved all my SQL 2000 databases into a new box from Windows 2000 to windows 2003 All the databases and users went ok but when I try to run a DTS I get the following error Cannot open a log file of specified name. Cannot find the pat Thank you...more >>

Help! I have a database that is in a case sensitive state, I am using DTS to transfer the database to a cluster that is case insenseitive. Everthing goes fine until I run some update scripts on the database. The srips are performing an application upgrade. I noticed on some tables the data typ was c...more >>

(tried posting this already but it was so big it broke it out) I have inherited a DB from another project and am tasked with fine = tuning some of the SP's. One that is really biting me is this web page = that allows you to search on like 22 different combinations of fields. =20 Naturally i...more >>

Hi All, We have requirement to transfer data from SQL Server 2000 to Oracle 9i in AIX machine. We plan to use DTS to do this. Have any body tried this ? how to connect to Oracle 9i on AIX, using ODBC ? Is thrre any known issue here ? Thanks for your help, Trist ...more >>

I don't know if it's an odd coincidence or not, but I'm getting an error when I try to DTS in an Excel file to SQL. The odd coincidence is that this started happening around the time I upgraded to Office 2003. That might have something to do with it, it might not. Anyway, the error I receive...more >>

Hello, I have a problem with success/failure when executing a child package from a main package. In my child package I have implemented an error handling step which have the property "fail package on step failure" activated. The error handler code will always end with failure and therefore ...more >>

Hi, I have setup a DTS Package (Copy SQL Server Objects Task) and all objects but Views and Stored Procedures are copied. I have in my list both non encrypted and encrypted views and procedures. The System views and procedures are however copied successfully. Thanks Anon ...more >>

Hi, I was exporting data through DTS VB program from one source to another destination. It gave an error saying that " cannot allocate the space for the 'table' because Primary filegroup is full. I thought it was because there was no space in hard disk. But 7 GB is free space is in Hard ...more >>

Hi, Is it possible to setup a DTS Package and authorizations such that a end-user can Execute the package but can't change the design/settings of it, and if so what authorizations (SQL/Windows) need to be setup for this? (The package will be created and tested by a Developer but once it...more >>

Having studied inf 269074 I am bemused. On a win 2003 server with SQL2000 SP3 I have made a trivial package (because the complicated ones wont run scheduled)and it will not run as a job. I can set it to be admin owned, run SQL agent as admin and still get no joy. All packages run fine in E...more >>

I have a Sheet that needs to be put into 2 separate table The sheets has the following columns (essentially): id,desc,date1,date2,date3,date4 The sheet would look like: ID Name Date1 Date2 Date3 Date4 1 Mark 12/15/05 10/2/...more >>

I'm very new to writing DTS Packages. However, I have one where I want it to execute a certain package if the DayOfWeek = 1 (Monday), otherwise, I want it to do something else. I'm having trouble trying to get my ActiveX Script to recognize the 1 for Monday. I'm guessing that I'm missing settin...more >>

Hi , I`m trying to create ftp task that gets it`s parameters dynamically via ini file . all seems o.k. and the ftp task seems to get the right parameters but for some reason when a try to run the package I get the massage of invalid "invalid string format for source file names " here is my i...more >>

hi, I have to take over on a 500 dts project....and I'm tryng to understand in wich way I can easily document this "monster". one idea is to use visio reverse engineer via oledb for dts (DTSPackageDSO) but, even if the data source is ok, nothing works...colud anybody help me even suggesting thirdy p...more >>