Hi I'm migrating data from the old schema to the new schema using DTS. The old and new schema are different. In the new schema we have identity columns as Primary keys and referred as foreign keys in the child tables. In the old schema Primary keys are not identity columns. So when I migrate ...more >>

Hi, I am using the Transform data task to transform data from the database table to the flat file using Lookup queries. The database table resides in Oracle 9i and I am using Microsoft OLE DB provider for Oracle in the connection object. My Table contains approx 3 million records. I...more >>

I have a situation where I have 600 text files that I need to input to 600 tables. Each of the text files relates to one and only one table. What I would like to be able to do is to setup a generic DTS package that I could pass the table name and the input text file name to it to do the import....more >>

Hi, I schedule a DTS package that runs manually, it's executed on the server The owner of the package is Admin The owner of the task is also Admin And Admin is owner of the DataBase group But the schedule task returns me the error: "cannot be run because the CmdExec subsystem failed to load....more >>

Does anyone have a link to the docs for DTS for SQLServer 7. I can't = find my old MSDN Disks. --=20 Jim Vierra...more >>

Hi , Where can I get the DTS package ID and what is the commad to run that package using that Package ID in the SQL Scheduler ? -- Travis Tan...more >>

I created a dts package that imports data into sqlserver. I run the dts package from a vb.net application on a machine that does not have sqlserver installed. I get the error quoted above. I used an installer project to install my vb.net application on the machine running the application. Inc...more >>

Hello Gurus, I have SQL 2000 DTS package transfers data from one server to another server. I have execute sql task with following sql SELECT count(*) FROM table1 In output parameter i have created Global variable with output parameter type =Rowset On sucess i call following acti...more >>

Hi All, I have a small DTS package that try to get data from Oracle to SQL server. Package runs without any issue when execute interactively, but when schedule it fails. My guess this could be a permission issue, how can I resolve this issue. How could I grant access permission to Oracle DB...more >>

What's the best way of populating the From and Thru date Global Variables for a DTS to use as parameters in extract queries?...more >>

I have a DTS package that for the past 4 weeks has taken between 3.5 and 4.5 hours to run each night. Without any other things going on or additions to the DTS, the job jumped to 6.5 hours two nights in a row, and then skyrocketed to over 22 hours. I removed the 15 queries, out of over 65 q...more >>

Has anyone used this tool.. Having a bit of a hard time figuring out what exactly I need to setup to use it.... http://www.sqldts.com/default.aspx?302...more >>

created package through sql using the all tasks extract info selected a mdb file on my server. then asked this to create a dts package and scheduled it for once a week. when I run it manually I have no problem. When it runs through the scheduler it cannot find the mdb file on the server. ...more >>

created package through sql using the all tasks extract info selected a mdb file on my server. then asked this to create a dts package and scheduled it for once a week. when I run it manually I have no problem. When it runs through the scheduler it cannot find the mdb file on the server. ...more >>

I am trying to figure out if I can build a dynamic text file connection in the DTS Designer. The datasource will be a text file, but the name will change... Any pointer or links to articles would be helpful... Thanks...more >>

If anyone from Microsoft is out there, please help because I know this HAS to be a bug and you would think Microsoft could give us a fix! We have Mainframe data being exported to a text file in fixed column format with 600 columns and growing in the future. I then go into the Local Package ...more >>

I'm going to rebuild my SQL Server and would like to know the best way to backup my DTS packages. I'll be completely blowing away the partition where SQL is installed, and re-installing SQL from scratch. Is it best to simply copy my msdb db somewhere, install sql, stop sql, then copy my curr...more >>

Topic: DTS export data to a text file. One table to a text file. Works perfectly well. Problem: The next process that is using the text file does not admit file size greater than 2 GB Question: I need to instruct the package to export to many files, each up to 2 GB. mytext_1.txt, mytext_2.tx...more >>

I have some SQL Server 7.0 DTS packages that use Microsoft data Link files (*.udl) to define the DataSource for DataTransfer/pump tasks. The source DB are Sybase ASE11 Databases. The UDLs are defined like. [oledb] ; Everything after this line is an OLE DB initstring Provider=MSDASQL.1;Pas...more >>

I have been given the wonderous task of working out how to import multiple data files into a SQL DB (appx 250 per day) The Files are of different sizes, number of rows, columns and formats but have the same header row which defines what is in the file. I've sussed all the import stuff but ...more >>

I need to repeatedly call 3 stored procedures (only the first 2 stored procedure need to be called repeatedly) on a Sybase ASE 11 database to pull data into a SQL Server database table (with different parameters): e.g. exec p_PullDataForDates1 20050101,20050131 exec p_PullDataForDates1 200502...more >>

Hi, I am using the trasform data task to transform the table data to the text file. The table contains around 30 columns. The problem is that when I selects the destination tab in the transform task the 'populate from source' windows appears. But when I press the execute button no column...more >>

Hi , I created a SQL scheduler which copy the files from one server to local server. But I still getting a error message "Access Denied .......". Is it a user priviledge issue or something else ? Please help. -- Travis Tan...more >>

Hi, I am managing a large database--several hundred tables. The current system I inherited employs an Excel spreadsheet to manage the details (description, business rules, etc) of the tables and fields. We would like to convert the information in this spreadsheet to a more convenient Acces...more >>

Getting error below when try to run inport job automatically. Job saved in MSDE on WinXP box. Importing from SQL2000 on Win2000 Server. I can execute the job manually OK. SQLAgent on importing MSDE logging on as system account. Any help would be appreciated. Thanks. Alan ----...more >>

Hi, I am exporting a table data to a flat file using DTS Package. Some of the columns in the table contain special characters. After the data is exported, the special characters in the flat file are not same as the special characters in the columns of the table. How does this happen? How c...more >>

Hi all, I have tested using UDL files to access MSSQL to MSSQL databases and it works great, does UDL also support access to Sybase or Oracle databases / platforms? Thanks...M ...more >>

I have a common scenario: I have several packages that I want executed sequentially, and if one fails they should all be rolled back. So, I made a main executing package that executes each package. Each of the sub packages is set to "Join Transaction if Present" and to "Rollback Transaction ...more >>

Hi, I'm getting some funny error. I've developed a c# (console application) code - .exe - and Using DTS (SQL 2000) Execute Process Task to run the .exe. I run the process every month. Now when I run the process, I get following error; "CreateProcessTask 'DTSTask_DTSCreateProcessTask_2': Proces...more >>

Now you can call a WebServices from SQL (DTS) WebService Extended Stored Procedure http://www.rdlcomponents.com/EXSP/default.aspx Thanks Jerry...more >>

Hi, I want to add a variable on a datetime, i try this : ********************************************** Option Explicit Function Main() dim ctps dim duree ctps = DTSSource("dtstempsdeb").Value duree = DTSSource("dtscallduration").Value DTSDestination("ctemps").Value = ctps.Add(du...more >>

I'm trying to create a simple DTS package to copy some data from Server1 to Server2, but Server2 doesn't appear in the Server dropdown list in the OLE DB Provider's Server list in the DTS Designer, even though I can see the box in EM, can query it in QA, and can ping it. It doesn't matter ...more >>

I'm trying to create a simple DTS package to copy some data from Server1 to Server2, but Server2 doesn't appear in the Server dropdown list in the OLE DB Provider's Server list in the DTS Designer, even though I can see the box in EM, can query it in QA, and can ping it. It doesn't matter ...more >>

Hi , I created a package to transfer some lookup tables store in text format into SQL server. I able to create the package and run it successfully. But if any updates or new record inserted to text file I also want to updates to SQL database. Old records in the text file I do not want...more >>

I am importing a paradox table into a MS SQL 2000 database. Both tables are named Member. The paradox Member has a Customer ID (Varchar(4)) and User ID (Varchar(3)). When I import the table to MS SQL, I want to combine this two to become the UserID (Varchar(7)) of the destination table. Fo...more >>

I've figured out how to do a DTS to run a view and dump data into Excel, butI had to hardcode the Excel filename. How do I get the system date and save it as something like "Accounting_05MAY2005.xls"? Where do I start? Thank you kindly!...more >>

I'm trying to use On Error Goto Label in the main funtion of my ActiveX task,but it says syntax error.How can I use that? Thanks ...more >>

Hi All, I would like to know how to get the date that a package was LAST executed? also, how do I move a group of packages to another server? Thanks...M ...more >>

Hi, I want send a formated mail ,every one hour to our client's I want to use SQL Server ,is their any way do it. *** Sent via Developersdex http://www.developersdex.com ***...more >>

Dear All: First, sorry to be wordy, just trying to give what we have found so far so that you might be able to see something we missed or didn't check. We have 6 DTS Packages that we use to update our Web database from our internal database. We have a job setup to run all 6 DTS packages i...more >>

What's the best method for formatting a date from a standard SQL Server datetime format to ddmmmyyyy (e.g., 12DEC2005) in an export query? Thanks, Rob...more >>

I'd like to use xp_smtp_sendmail in my DTS package to send an email to the admin and also bunch of stored procedures I have.The problem is that My database server is behind the firewall and what I read about this guy is that it opens up a TCP/IP socket to the SMTP SERVER.Apparently I cannot u...more >>

In my DTS pkg, I have an ActiveX script that has a condition: if <condition> = True Then Main = DTSTaskExecResult_Success Else Main = DTSTaskExecResult_Failure End If On the failure condition, I set a workflow (red) connected to a task for sending me (xp_sendmail) email. I ran this pk...more >>

I have a few DTS packages in SQL Sever 7.0 Each have a Data Transfer Task with a Sybase 11 ASE database as a data source and the SQL 7 table as a destination. The Data source are defined using a Microsoft Data Link File (UDL), and the actual connection is via ODBC (Merant Sybase Driver) as...more >>