I am just beginning my career in the IT field and I am having trouble with database migration. I am trying to convert a mysql5.0 database to...

Jason

12-09-2005 11:43 AM
Jason

Hi, I've installed SQL Server 2005 on the box which had SQL Server 2000 installed. Then I modified the DTS Package with FTP task using SQL...

exkievan

12-09-2005 11:37 AM
exkievan

I have two sqlserver2k databases on different servers on the same network. I need to push recently inserted/updated data from one to the other, but...

lstainer@accans.co.uk

12-09-2005 09:07 AM
SQL

I would to control my DTS package from within my ADP project under Access. I don't want to import the DTS package as a vb module, I would like to...

Xav

12-09-2005 08:33 AM
urchin

SQL 2000 SP4 DTS Designer I recently copied a DTS package with an Execute Package Task from one Server to another. I am now changing connection...

c0derguy

12-08-2005 06:16 PM
c0derguy

I would like to download a file from an HTTP server. Is there a way with DTS to download a file from a webserver as we can do it from an FTP server...

xgoulay@gmail.com

12-08-2005 04:48 PM
Dave

I'm having problem on SSIS because I dont know how to specify how much records it will commit. The package that I'm running is working with about 2...

CarlosR

12-08-2005 02:35 PM
CarlosR

Hello! I am unable to run or edit any DTS packages on my SQL Server 2000 server through Enterprise Manager. I receive the following errors: Package...

kmole

12-08-2005 02:33 PM
kmole

Hi. I am attempting to import a DB that was sent to me in CSV format. The DB contains roughly 18,000,000 records. Unfortunately, on record 645,323...

DB

12-08-2005 02:14 PM
Danijel Novak

I am trying to append some 50000 rows of data from table A to table B in the same database using DTS. Howvere I get an error message which says...

sharman

12-08-2005 12:53 PM
sharman

Ok guys, i really need help here. I have a DTS that do daily extraction from sql server to oracle. These data contain Chinese character, Korean,...

jiajilah

12-08-2005 04:35 AM
jiajilah

I am converting our old DTS packages to the new SSIS packages in SQL server 2005 integration services. I must apologize first, becase I am quite a...

Ryan

12-08-2005 04:03 AM
Darren Green

Hi, I am very new to working in DTS and offcourse IS in Yukon.Can any one suggest me the start up in transforming data from CSV file to SQL Server...

TechFreak

12-08-2005 03:57 AM
Darren Green

(I previously posted this in sqlserver.datawarehouse with no answers. Please excuse my crosspost - I really need this to work...) Hi, I'm trying to...

Jacob_I

12-08-2005 03:26 AM
Jacob_I

I've installed SQL Server 2005 both on my desktop system and on a Windows 2003 server. I'm wondering why the "flat file source" selection is...

mp3nomad

12-07-2005 11:24 PM
mp3nomad

In the activex of data pump task, I need to apply a same function to every source column to get destination column. Is it possible to write a for...

pm

12-07-2005 10:45 PM
pm

I'm all for progress but I miss the simplicity of 2000's DTS. All I want to do is copy a source database to a destination along with that...

michael

12-07-2005 09:10 PM
Sophie Guo [MSFT]

I wish to save a DTS package in structured storage but if I use Import/Export from the desktop the User and Ownwr password boxes are disabled. If I...

elaineuk123@yahoo.com

12-07-2005 06:37 PM
elaineuk123@yahoo.com

Having a problem with the precision on some values when DTS exports from Excel. e.g. 0.08 appears as 8.0 in the text file. Does not occur for all...

GO

12-07-2005 03:30 PM
GO

We are working with SQL Server 2000 in a Windows 2003 Server, and opening Enterprise Manager from this server to design DTS packages works fine, but...

Francisco Araujo

12-07-2005 12:56 PM
Francisco Araujo

Hi: I have a SQL task that does merely this: SELECT * FROM myTable WHERE SiteName = ? There is one string input parameter which is a...

Kayda

12-07-2005 11:47 AM
Kayda

Hello all, I am tryint to import data from Excel into a table in SQL using a DTS package. I have not had to work with such a strangely formatted...

Leo

12-07-2005 10:37 AM
Leo

I have a DTS package which checks for files in a designated folder, and imports the ones it wants. However, if no files exist it just reports an...

NH

12-07-2005 09:09 AM
Darren Green

Good morning, I have a 2003 AD domain with a SQL2000 dedicated machine (server). I try to export on a windows 2000 server (excel or txt files) from...

Steve

12-07-2005 08:11 AM
Steve

We would like to upgrade to SQL 2005, but we have customers who use DTS on SQL 2000 to pull data from our database. Will we have problems? -- Jay...

Jay Croft

12-07-2005 05:07 AM
Darren Green

Hi, I am observing a strange behaviour of an SSIS package I created: - It reads from a comma separated {CR}{LF} line terminated flat file into a SQL...

Tom Kern

12-07-2005 02:26 AM
Sophie Guo [MSFT]

Hi, I have to import data from a Excel sheet into a table. The Excel format is "Generic' and the values can be numeric or alphanumeric. I get a...

PeterNZ

12-06-2005 10:28 PM
PeterNZ

What needs to be instlled on the SQL Server to enable a DTS package to use SQL Mail? I gotta use an SMTP server on another box to send out SQL mail,...

Chris Davoli

12-06-2005 01:48 PM
ChiWhiteSox

I am dts to import an access db. The first time I ran it using 2000 everything worked flawlessly. Then when 2005 came out I ran it and immediately...

David

12-06-2005 01:45 PM
David

Hi, I'm try to upgrade the SQL2000 hardware, how can I copy all package to the new machine?

Lo Kwun

12-06-2005 10:36 AM
ChiWhiteSox

Guys, Today I have a SQL2000 DB running on a Windows2003 server. I wanna move this DB to a new Server where I also have Windows 2003 Server, but in...

Monteiro

12-06-2005 10:12 AM
Darren Green

I have a problem using DTS (SQL Server 2000) to export to a text file. If I try to create the DTS using the designer if I am exporting from a table...

gilbertcj@gmail.com

12-06-2005 06:25 AM
gilb

Hi, I am trying to create a DTS package wherein the data from the sql server is transfered to a text file. I am using the Transform Data Task to...

Mohan

12-05-2005 05:30 PM
Darren Green

Hi all, I have a main DTS Package (SQL Server 2000) that executes another DTS Package (with Analysis Services Processing Task) with Execute Package...

Alex

12-05-2005 05:25 PM
Darren Green

Does SQL 2000 workgroup edition support DTS, Data Transformation services...not user interface, but be able to the source or target of the...

Eric

12-05-2005 05:24 PM
Darren Green

Trying to use the DTS Wizard to Import data from one table into another. The problem is that the source table has DateTime data and I have to fit it...

PSRDCJIM

12-05-2005 05:21 PM
Darren Green

I can drag and drop the Send Mail task in a dts package and use it to send mail to a specific person and it works. The question is, how can I use it...

Chris Davoli

12-05-2005 05:18 PM
Darren Green

I want to upload data into 5 dimensions in my Analysis Services database. I do not want to update the dimensions during the cube processing I want to...

KarenM

12-05-2005 04:35 PM
Dave Wickert [MSFT]

Hi I have quite a strange DTS problem. I wrote a script to load data from a Excel spreadsheet into a Access database. If I run the script (doesn't...

groups@netdream.ch

12-05-2005 03:08 PM
groups@netdream.ch

What is the fastest way to load 150,000 user objects (with most of the AD user attributes) from Active Directory into a SQL table(s) using...

Joe Murray

12-05-2005 02:18 PM
Joe Murray

I need to export data from a SQL 2005 database to an XML file. I would like to use SSIS as the environment of choice to achieve this. Is there any...

Ralf

12-05-2005 01:33 PM
Ralf

hello! I have a question about importing file on network share but access denied. First of all,let me introduce my working environment and...

YesGoGoGo@gmail.com

12-05-2005 11:24 AM
YesGoGoGo@gmail.com

I built a custom component (con. mgr.) that uses some external dependencies (dlls) and properly registered it with SSIS. When I open up BI studio,...

Albert

12-05-2005 11:03 AM
Darren Green

Hi I have a WinForms client which needs to execute a DTS Package on SQl Server 2000. The Sql Server db is on a server. If I run the client on the...

Parag

12-04-2005 02:59 PM
Parag

I would like to know How I can automate an DTS and How I can publish an Cube with OWC 2003? or I need other tool for this issue?

Flavio Cortes

12-03-2005 08:47 PM
Allan Mitchell

I am using an Excel connection in my DTS package. After running the package in DTS Designer, I tried to open the Excel file using the...

PD

12-03-2005 04:55 AM
Allan Mitchell

Hello, This might sound like an easy question but I am wondering if it is possible to execute a DTS package using ASP.NET, if so...how do you do it?...

Mike

12-02-2005 10:09 PM
Mike

....than the domain assigned to the SQL Agent Service account. For example, we have an account XYZ\SQLServiceAcct that is shown as the owner of...

Chris.Elliott

12-02-2005 05:50 PM
Chris.Elliott

How can I transfer DB diagrams and referential integrity relationships between databases with the same structure. I copied dtproperties table from...

Mike Moore

12-02-2005 05:32 PM
Allan Mitchell

Hi, I am using SQL server 2005 (Ver:9.0.1116). I am unable to find how to create a DTS package from Sql Server Management Studio. It is showing "DTS...

hangar18

12-02-2005 05:26 PM
Allan Mitchell