I am not sure if this is possible or not but I am trying to do the following. I need to export data to a test file in the following...

kapsolas

12-29-2005 08:26 AM
kapsolas

Help! I am trying to get a sybase SQL anywhere database converted to a SQL server 2005 express database. I have done it with DTS in SQL server 2000...

RyanS

12-28-2005 08:55 PM
RyanS

I have asked the similar question few days ago, but nobody responsed. So I am asking again with more detailed info: =======> An excel file is...

Trent

12-28-2005 03:15 PM
Trent

I have need to produce a report (excel sheet actually) from SQL that would run each Tuesday and each Friday of every week. What needs to be on the...

Blasting Cap

12-28-2005 01:13 PM
Andrew J. Kelly

I had several of these during a database copy from SQL 2000 to SQL 2005. Any ideas on a cause? The second one happened once during the copy and looks...

R Johnson

12-28-2005 07:10 AM
R Johnson

I need to dump Access MDB files to SQL Server 2005. No extract and transfer, just transfer the raw data. However, the mdb files can be reaching...

nick

12-27-2005 07:08 AM
Jéjé

I'm using DTS in SQL Server 2000. This is the first time I've used it extensively. I have a task which is trying to "manually" roll back a set of...

John Saunders

12-27-2005 04:28 AM
Darren Green

Howdy all. My goal here is to be able to be able to move a DTS Package from one box to another and not have to specify the new box name in the...

ChrisR

12-26-2005 02:56 PM
redpoint_13

Hi All, Is there any way to generate customize error message in DTS package ? I know we can use FileSystemObject in vbscript and write messages.but...

jariwala_b@rediffmail.com

12-25-2005 11:47 PM
jariwala_b@rediffmail.com

Hi, i'm new to SQL server 2005 integration service(formely DTS), i was trying to build my first integration project but i'am facing an issue while...

alamine

12-25-2005 03:50 PM
alamine

Hello there I have database with many relationsips At the start it is empty and when i'm trying to import to it data. some of the tables are failed...

Roy Goldhammer

12-24-2005 02:00 PM
Andrew J. Kelly

Hello there I've run dts between two servers that connected by the internet, and one of the tables failed. I've transfered 78Mb, and the log file...

Roy Goldhammer

12-24-2005 07:58 AM
Andrew J. Kelly

I need to move some data generated from a SQL Server 2000 scheduled job over to Exchange 2003 calendar. After some research, it appears that a DTS...

john

12-23-2005 10:47 AM
vadim.svinkin@gmail.com

If DTS is not supported in the new Workgroup version of SQL 2000, how does one get data and SPROCs in and out of a server? Is there...

mtncruzr

12-23-2005 03:37 AM
Darren Green

Hello there I've transfare data from two databases in a diffrent Servers, who connected by the internet, Before i've started the DTS i reset the...

Roy Goldhammer

12-23-2005 12:02 AM
Roy Goldhammer

I've got a few Transform Data Tasks in a DTS package that run queries to move data from a production DB to an OLAP staging DB. If it run the query...

Mike Austin

12-22-2005 04:33 PM
Mike Austin

I have a DTS package that performs data transformation from a flat file to a database table. I've added two columns to the table but, the two table...

Larry Bird

12-22-2005 11:45 AM
Larry Bird

Hi Firstly Happy Xmas and Happy Chanuka To ALL I am attempting to import data from msaccess using the DTS into a database that exists. I can't pick...

mrrcomp

12-22-2005 10:40 AM
mrrcomp

I have a flat file with 3 million records.One of the field is numeric. What I am trying to do is transform the flat file data into sql table.The...

munny

12-22-2005 06:11 AM
Enric

Hi, Is it possible to output the content of a table into .txt file using UTF-8 encoding and how? Thanks in advance.

SoccerManic

12-22-2005 06:06 AM
Enric

Hello: I have a web application from where I need to execute a DTS, my platform is SQL 2000 and .net 2003. From a Vb.net module I want...

Gina Hernandez

12-22-2005 02:58 AM
Darren Green

I am trying to configure the WHERE clause for the SQL statement I am using in an OLE DB Source for a data flow so that I can do an incremental...

Stephen

12-21-2005 11:18 PM
Stephen

In SQL2000 DTS you could execute a package from the DTS designer and see how long each step took. Is there any way to do this in SQL2005...

Jeff Lynch

12-21-2005 11:17 PM
Peter Yang [MSFT]

We are using SQL Server 2005 Integration Service (SSIS) to import data from an EXCEL source file, which is on a secured web site(need login),...

Trent

12-21-2005 10:19 PM
Trent

I am trying to use the package migration wizard to transfer a package from Sql Server 2000 (DTS) to Sql Server 2005 and I get the following error no...

Allen

12-21-2005 05:17 PM
Koni Kogan

I am trying to import data into SQL 2000 through an ODBC and keep getting an error, I tracked down the error and it is because the program that I...

sschafer

12-21-2005 12:49 PM
urchin

We have a number of DTS packages running on a SQL 2000 server, pulling data from a non-relational accounting database. The package is set up using...

TomT

12-21-2005 07:20 AM
Darren Green

Hi, I am trying to send a MSMQ message from a DTS package using Message Queuing Task. I am getting the following message when I am try to send the...

Navnit Mehta

12-21-2005 04:46 AM
Navnit Mehta

I am trying to copy a "snapshot" of a remote sql server 2000 database to a local sql server 2000 database. I just want to run a simple Copy...

Jed

12-20-2005 08:24 PM
Peter Yang [MSFT]

When copying a stored procedure object that selects from the table "books," why exactly is the "book" table considered a dependent object? The...

PJ

12-20-2005 07:03 PM
PJ

Environment: SQL 2005 EE RTM I am trying to provide a dynamic XMLA string to an Analysis Services processing task using a package-level variable. ...

Randy Martin

12-20-2005 06:47 PM
Randy Martin

Hi all! I'm launching a dts that has to load a file into a db table and when I'm executing it a failure is raised: Server could not load DCOM. any...

milly

12-20-2005 06:09 PM
A X L V

Hi I would like to export sql server tables in text files. I have a metadata table "tables" with the tables name that I want to export. i would...

FedeX

12-20-2005 10:49 AM
Darren Green

Dear All I have arround 100 packages in all packages I have put IP of the server in the connection. Now I want to use all this package on other 2...

amish

12-20-2005 10:16 AM
AM

Hi, I have just installed SQL 2005 Developer Edition on a Win2003 Server. I have an installation of SQL 2000 on the same machine, which I use for...

Malcolm Klotz

12-20-2005 09:18 AM
DanaDBA

Hi, Environment : SQL Server Intergration Services Beta 2. Requirement is that moving the contents of all CSV files in a particular folder to...

TechFreak

12-20-2005 08:55 AM
Darren Green

Hi there, In my DTS package, I want to define my connection DataSource using dynamic properties. I'm using a query to initialize the source. Can I...

VinCe

12-20-2005 06:44 AM
VinCe

Hi All, I am trying to import all tables from an Access 2000 database into a SQL Server 7.0 database. The import seems to work fine and says it...

Nathan

12-20-2005 06:08 AM
Darren Green

In my ADP I start a DTS pakcage from my vba module (use the object dts.package2), I display the status of the progress in a pop up form. My issue is...

Xav

12-20-2005 06:06 AM
Darren Green

Facts: I have a Windows 2003 Standard server that has SQL 2000 Standard installed. Both MSSQL and ServerAgent services are running under a windows...

JFR

12-20-2005 06:04 AM
Darren Green

How can I insert the results of a query into another table? TIA RC-

RC-

12-20-2005 06:00 AM
Darren Green

Hello, I'm hoping someone here might be able to offer some advice related to an SSIS design quandry I'm working on. Pardon the long post, but I...

dan@developerdotstar.com

12-19-2005 06:01 PM
dan@developerdotstar.com

I can't start the SQL Agent in an MSDE installation. It stops right away. The Error log says : <<SQLServerAgent could not be started (reason:...

Jav

12-19-2005 11:11 AM
JFR

I have two tables that I need to compare. The purpose of the comparison is to check for duplicate records, or better said, check for new records in...

RC-

12-19-2005 08:42 AM
vadim.svinkin@gmail.com

Hi, It's hard to give an explanation without knowing your code and data but most of the time when i receive problems like this (works on QA but not...

Umut Nazlica

12-19-2005 08:17 AM
Umut Nazlica

Hi, I am trying to write a AvtiveX to export automatically Tables in Textfiles.. I set dynamically Source (Table) and Target (a file name).. I delete...

FedeX

12-19-2005 06:04 AM
FedeX

I have a simple data fow task that consists of a Flat File Connection linked to a script component, before moving to a Data Flow Destination. The...

Nightcrawler

12-18-2005 05:34 PM
Nightcrawler

I had no luck upgrading my SQL 7 DTS packages to Sql 2005. Is there any possibility of getting a copy of the SQL 2000 Eval so that I can...

John Hoge

12-18-2005 04:10 PM
John Hoge

Salut, Sur SQ serveur 7,dans un LOT DTS, j'attaque une base SCD TERADATA via ODBC. J'aimerais passer en parametres de ma requete deux dates qui...

gilles.carali@gmail.com

12-17-2005 02:40 AM
gilles.carali@gmail.com

Salut, Sur SQ serveur 7,dans un LOT DTS, j'attaque une base SCD TERADATA via ODBC. J'aimerais passer en parametres de ma requete deux dates qui...

gilles.carali@gmail.com

12-17-2005 02:40 AM
gilles.carali@gmail.com