Greetings, I have a newbie question. I've been reading methods of syncing a Foxpro DB to a MSSQL server daily. Each record luckily contains a last modified date so it may make it easier. DTS seems like the way to go but I wish to perform more advanced logic mainly: * Sync only new r...more >>

Which would you recommend to setup as a failover database server? (We do not have the ability right now to setup a sql cluster). What is the difference between log shipping and database replication? Pros/Cons? Thanks. - Gabe ...more >>

I have a scheduled job to run daily at 6:00 am, but it only executes the first day after scheduled after that it stays on "Executing Step 1" and since the job doesn't finish it doesn't start the day after that, how can stop the job after it completes, because the job does everything it supposed ...more >>

Is there a way to force a DTS .txt file to always be a set length? I have fixed length fields and the customer needs the record to be 80 characters. Do I need to create a 'dummy' variable to be a filler a blank spaces? Thanks -- Stan Gosselin...more >>

Is there a tool or code which I can use to import multiple Excel 2000 Spreadsheets data into SQL Server 2000 tables. Earlier I had been using EM data import feature to import the data one excel spreadsheet at a time. But now am at a point where there are plenty of Excel spreadsheets (to impor...more >>

I have a large text file but a process that is external to DTS can process only 10000 records in the text file. So before calling this external program I want a file if it greater than 10000 records to be split into multiple files of size 10000 records each. Please advise the best way to sp...more >>

(not sure the best news group to post this) I'm trying to create a new OLEDB connection in the RTM version of SQL 2005 I get back the following error The connection manager 'OLEDB' is not properly installed on this computer. (Microsoft.DataTransformationServices.Design) This is a clean...more >>

i am a little bit confused , i write an sp which creates DTS.Package object and uses LoadFromSQLServer method to load DTS package. i exec this sp within VB code in a ASP page. Web server and Sql server are on the different machines. where does the package run ? on the web server or sql server...more >>

In the DTS package, how do I change the file location dynamcially? I need file location to be changed depending on what server the DTS package running on. I am using @@servername for this purpose. This DTS package is very simple. It is importing a TEXT file into a SQL Server table. Currently, ...more >>

I am using DTS to import tables into my new database from another database, both of which reside on the same server. All the tables, fields and data copy over fine; however when I go into design view of the copied tables, the default values for all the fields are lost. It seems to copy the struc...more >>

What has replaced DTS in SQL 2005 and how do I create a new DTS package (or the equivalent) ? -- Michael Tissington http://www.oaklodge.com http://www.tabtag.com ...more >>

I want to use DTS to build a text file and a dollar field must be right justified, left zero filled and no decimal. Is there a tranformation that can be used on a field that is defined as 'decimal 9(15,2)? Do I have to use SQL or tweak the VB code that can be generated? If either, how? Tha...more >>

We use a few custom tasks in our system in several DTS packages. How can I query tables in MSDB to find all packages using a DTS task. Also, how can I find a particular task property in various DTS packages from the MSDB tables. Thanks Karen ...more >>

I have a large file to be processed. I would like to split the files into say 80000 records in each file to manage the size of processing. Please kindly share the code or procedure to split a file into manageable sizes and handling the resulting split files from DTS. Thanks Karen ...more >>

I have to take the output stream from a stored procedure and turn it into a text file. I do not know how to do this without writing it into a table and then using the table as a datasource, which seems lame. Is there an easy way to do this? Thanks...more >>

I am trying to code a DTS export package to select records from a table where the significant date field is a CHAR length of 8 variable. The values are like '20051027'. I want to code a SQL statement to select all records for the current (system) date. -- Stan Gosselin...more >>

I'm assuming this is a simple question, I can't find a solution though. Hopefully this makes sense 1) I have an excel file with the following columns: First Name Last Name Email 2) I have a table with the following columns: ID (primary key) ExcelID (int not null) FirstName varchar Las...more >>

Could you please help me to find out the ways whow to backup dts packages...more >>

Table A is created in an Oracle d-base randomly every day...sometimes 5 am sometimes 11 am...very unpredictable. Every day when the query is run that builds the table, it overwrites the previous day. Once I successfully import the table I can fire my scripts. Right now I've been doing all t...more >>

Can I use DTS to export database mySQL to Microsoft Access or Microsoft SQL? If so, how? If not, does it have any utilities to support this task? ...more >>

Hello All, I have a windows service on several remote machines that gather data and load it to SQL 2000. The service on the remote machine runs at a desirable frequency and gathers the data. I'm using DTS on a central server to bring the data back. The DTS package has it's own schedule...more >>

I have a SQL Server 2000 DTS Package, where within a Data Transformation task, with source being a text file delimited with ~¬ and destination being a SQL Server table, I tried to use the "Trim String" transformation to transfer column by column (one to one mapping). Each Transformation has ...more >>

Hello Every body, I am using SQLServer 2000 Personal and enterprise edition – VB.net I already have DTS package with global variable – Example sourceServerName, sourceUserName, sourcePassword, TargetServerName ,TargetUserName,TargetPassword. I need use this package for multiple job sche...more >>

I forget my dts password for an dts on Sql 2000 SP3 .How can i reset or find my password for edit my DTS .I have db admin and sys admin user rights on this database. thanks for your help. Özgür Çetiner ozgurcetiner@hotmail.com...more >>

I am trying to process a delimited text file where 2 lines together makeup 1 single record. Here's sample data DD0010001SVC0929D9940000001111111 00800000009400 1 0010001SVC0929D9940000001SERVICE CHARGE DD0010001SVC092...more >>

Hi, I'm building a DTS package and one of the tasks it needs to do is to transform an existing order table in this format: UserID OrderID 1 0010, 003c, 0145 2 045, x15 3 x9010 to a table of this format: UserID OrderID 1 0010 1 003c 1 0145 2 045 2 x15 3 x9010 ...more >>

I have created a package that imports One table from Oracle. If i run this Package in DTS DEsigner...it runs fine, but when i schedule it, the job failes The execution of the following DTS Package succeeded: Package Name: DataMart Import (Oracle) Package Description: Imports Tables From Or...more >>

I have a Text File which I Import through a DTS package That is all fine and dandy, but what I would like to do is set the destination of the file to a different server through code. So if I specify server X and database XX in code then the dts will dump the file there, if i specify server X (...more >>

Someone else ask this question, but there were no responses so i'm trying again. "I am trying to import a fixed length field text file using the transform data task. When I run the step not all of the records get imported. I get no error messages or warnings. I can import the same file into b...more >>

when I try to run the optimizer with this query analyzer selection it says An error occurred when trying to run sql statement. Got this the last 5 times trying to use index optimizer - the other times i solved it without the optimizer but this time i would like to see what it says. select *...more >>

Does DTS for 2005 have anything like the Dynamic Properties Task that 2000 had? Maybe I'm just not looking in the right place or the name has changed. I've found "Package Configurations", but it doesn't do everthing that DPT did, like assign a property from a variable. I'm sure it can all be ...more >>

Hi, I need to have a dts package that creates a text file dynamically to archive data from table.The file name needs to be in the format of currentdate_table.txt and only one file needs to be created per year.So if the DTS is on any day other than 1st jan then the data needs to be appended...more >>

when doing this create view viewname as select * from table1 no trouble but when doing this if @temp 1 = 1 then begin create view viewname as select * from table1 suddenly sql server doesn't acknowledge the syntax in the create view statement ? how come ? ...more >>

hi, i have a back up text file(csv). it has an action character (Update/Delete/Insert) at the first of the line. so far, i read the text file from my c# code and populate to the table. but, i feel it's a bit slow. can i change this process to dts. but, i'm afraid that there's an action ...more >>

Can anyone answer for my, why, after all these years of waiting, Microsoft still cannot get simple SSIS tasks to work any better than DTS. Ridiculous. The following, very simple call to a parameterized stored procedure (up_GetData ?,?) from within a Data Flow Task will NOT parse correctly (i...more >>

Temporary table (#table) data remains through a series of DTS sql steps. I am even able to dump the data to excel. But just after that temporary table is lost. Why does it happen? Does the sql connection gets lost once i hit a task having excel connection? Please help. ...more >>

I am trying to write a script to read a tab delimited text file. I am not clear on how to map the tabbed data to a column. I am not a programmer but I am ttying and need some guidance. I found the following and got it work as far as reading the tabbed file, but how to do the tab data to a c...more >>

I have a DTS package that scheduled to run nightly but it fails on SQLMail Task, I get error "MapiLogonEx Failed due to MAPI error 273:MAPI Logon failed" . This DTS package dumps data into an excel spreadsheet and e-mails spreadsheet to user in company. I'm using Outlook 2003 client with Exc...more >>

We have quite a few packages we setup with Enterprise manager and we are running them from the command line using a batch file. They have been running fine for 6 months and now one of the packages is getting the following error. DTSRun OnProgress: DTSStep_DTSDataPumpTask_2; 139000 Rows ha...more >>

Hi, I'm not much exp. in DTS programing.I want to transfer Excel Data to SQL Server. Now my SQLDatabase and Excel file path are dynamic.(user will enter during runtime). I've created the DTS package in which i've specify the transformation task for Excel Source to SQL Server Destination. W...more >>

I've been trying to get a stroed procedure to execute a DTS and have come up with a baffling problem. The DTS has a Text FIle Source connection whice the file name is set via a global variable. When i run the DTS from the Enterprise manager it runs fine, importing a file from across the netw...more >>

Getting following errors , any help (SQL 2000 SP4 on Windows 2003) Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump Step Error Description:The number of failing rows exceeds the maximum specified. (Microsoft OLE DB Provider for SQL Server (80004005): [DBNETLIB][Connect...more >>

Hallo NG, ich habe schon einige Erfahrungen mit dem Einlesen von Text/CSV Dateien, um deren Inhalt in Tabelle zu bekommen. Jetzt grübel ich über ein Problem mit einem MetaDirectory Export. In der Textdatei stehen die Daten nicht in Spalten sondern untereinander. Etwa so: dn: cn=MustermM,...more >>

I need to find a way for a dts package to retrieve an XML file that exists on a website and retrieve the file on a daily schedule. We tried a dts package that uses Activex to open a browser and retrieve the file, which works when we run the package while logged in. BUT, when SQLServerAgent e...more >>

I need to know what behaviour SQL Server Agent has with a scheduled DTS package that takes longer to run than the next schedule period. for example say a package is scheduled to run everyday at 11:00, but the packages takes 27 hours to finish. What is the default action of the server agent....more >>

Hello I am sure this can't be that hard. I have an oracle procedure that prepares some data in oracle and loads it into an oracle table. I want to use DTS to execute the procedure and on successful completion load the prepared data into a SQL server table. I have tried using an execute...more >>

I need to copy a file from one domain to another. The file is available in https location and needs to be copied to a share location in a different domain. How do I achieve this using DTS. Does DTS support https connection. Thanks GS I am using SQL Server 2000...more >>

Hello Everyone, Please help me with following problem. I have scheduled a DTS package and get error "Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON". This package runs properly when I'm running manually. For details See below BAGS 'N BAGS OF THANKS Raj (local)Executed as user: CCMO...more >>

I have two simple dts pacakges , DTS_Main and DTS_Sub. DTS_Sub being called from DTS_Main. When DTS_Main calls DTS_Sub getting the following timeout error while calling the package not while executing. Is there any settings I can set to increase the time out setting when calling sub package.B...more >>

I have a package set up to export a single column in a table, this column is varchar(4096). The output from the package is a fixed width field of 4096. My goal is to export lines of various lengths (10, 200, 1500, 200). Is this possible? I have found many referenced to reading a variable leng...more >>