I've create a DTS package to load a text Document to a existing table into SQL ,one of the field is a datetime field,went i execute the package manually i get a date of 2049 for a 2 digit year of 01/01/49 but went i execute the same DTS thru a Job i get a date of 01/01/1949 . Does anyone ...more >>

We recommend that our clients install SQL Server at each of their satellite offices. Every night we DTS the central database out to the satellite offices. That way, if the link goes down, or if the main server were to go down, we'd have one or more backup databases to switch over to. One clien...more >>

I'm pretty short in the experience area here so this is probably something pretty easy. Any help would go a long way! I'm trying to use DTS to create a .CSV/.TXT file that stores the results of a simple query. The query runs OK by itself, but the DTS action fails with "Invalid Pointe...more >>

Hi, I am new to DTS Packeges in SQL Server. When I create a "Data Driven Query Task" int the fourth tab "Queries" there are four types of queries. Can anyone please point me where I can find documentation on how those queries work, and, how those queries are used in actual dts run. like when it w...more >>

I have to analyze all DTS packages of a few servers. Is it possible to document the packages with the workflow and properties, in any relatively quick method? Right now I am opening the packages and documenting each step manually. I have a few very huge packages that are used to build a war...more >>

Hello: I am using the following select statement as the data source in a Transform Data task: SELECT Convert(Datetime,"Trips"."tdate") As TripDate,"Trips"."Job","Trips"."RunNumber", "Customers"."name"As CustName,"Customers"."ssn", "Payors"."descr" As Payor,"Bill_Schedule"."descr" ...more >>

Hi All When I did transfer from Excel file to SQL Server I had this error.. Once I tried to save the source Excel file as csv file and after do transfer... But I think it's not a solution. Any Ideas Thanks....more >>

Hi , I Want to move some huge data from a SourceTable to DestinationTable. i had two ways to do it. i)execute a simple query like. insert into Destination table select * from SourceTable. using ado.net from a .net client application. ii)Use DTS for the same. ===========================...more >>

I am trying to move data from mysql to sql server, enterprise edition. The problem is that after selecting the tables, the dts hangs Kindly suggest a suitable solution. The mysql contains close to 71 lac records, which i wish to transfer to sql server. *** Sent via Developers...more >>

Hi all I have created several DTS packages in my SQL Server. I have saved the packages to SQL server (not as storage file or VB file)... is it possible to backup or get the DTS package so that I can use these created packages on another Machine or SQL server...?? Thnaks a lot Oshadha...more >>

Can anyone tell me how can i import data from as400 and transform it? in ..DOT NET Should i connect to As400 through JDBC with a Java App OR Can i use Ole DB with .DOTNET to import data from as400 OR Is is possible with DTS services located in SQL Server 2000 Thx ...more >>

Just wanted to sound out the group to see if anyone has come across a problem that came up recently. We have 30 something DTS packages running on SQL 2K sp3a, W2k Server sp4 that copy individual tables from a Progress database via ODBC. The first thing that each of these packages do, is run an...more >>

Hi All, Here is my story. I have a master package that governs execution of children packages. All children packages are executed with Execute Package task and referenced without PackageID (wiped it out in Disconnected Edit). All children packages are passed global variables. It all worked fin...more >>

Through a simple DTS package, I'm copying 5 tables from an Oracle DB to a SQL DB, I do have Oracle Client 9i installed on the SQL Server, and I established a DSN for the Oracle DB (ODBC). In the DTS package however, if I schedule this to run as a job, (also fails running manually) this is the err...more >>

Hi, I have simple code that work fine in VB, but I have problem to translate in to C#. The Code in VB: ------------------- Set oTransform = oCustTask.Transformations.New("DTSPump.DataPumpTransformScript") oTransform.Name = "Transform" oTransform.TransformFlags = DTSTransfor...more >>

Is it possible to chage global variable values using VBScript, if so how? ...more >>

Need small help in how to call a stored procedure from Activex Script. Using Execute sql task, it will be easy but I don't want to execute that task all the time. Only in certain situations, I need to run the stored procedure. Any code examples? thanks,...more >>

i've got 2 tables: table1: primary key "Contract" table2: composite key "Contract" and "LineNo" table 2 structure: Contract LineNo B001 1 B001 2 B001 3 B002 1 B002 2 B002 3 etc..... i'm importing from access to sql server, source and des...more >>

Hello, I am trying to automate the process of importing MLS (Multiple Listing Service) listings to a real estate database. I created a test DTS package that must execute in the following order: 1) Delete listings in database 2) Transform listing text file and export to SQL Server list...more >>

Is there any performance difference between using a structured storage file package as compared to a SQL Server package?...more >>

When you use a query as the source for a property in the Dynamic Properties Task, is it better performance to use separate connections to allow parallelism? In other words, is parallelism an issue inside a dynamic properties task or only in workflow of the package? Thanks....more >>

I am running DTS packages from a VB app. The package runs fine interactively, but returns "Execution cancelled by user" when called from the VB app. Any clues as to what might be causing this problem? Thanks in advance....more >>

Can some kind soul please help with a DTS selection problem I am having (under SQL 7 sp3, NT4), that is returning too many rows The following select statement returns a row for every entry in the CustomerMaster, even if a corresponding entry does not exist in the CustomerExtension table. Howe...more >>