We have an interesting scenario here at work which to be honest doesnt seem very difficult but we have never had the opportunity to try this out. One...

Tony

09-27-2006 07:52 AM
Tony

I have some DTS packages that load a flat file to the SQL 2000 database and then to a AS 2000 cube. I want to migrate this to SSIS on SQL 2005 and AS...

KarenM

09-27-2006 07:42 AM
Charles Kangai

Hi, I have an requirement wherein I get the data in the form of an txt file and I need to push this data onto different tables based on an column....

Sudhakara.T.P.

09-27-2006 07:33 AM
Charles Kangai

I am running several ActiveX script tasks that are basically inserting legacy data into the new DB structure. Using stored procedures with cursors...

Gaye Turnbull

09-27-2006 05:15 AM
Gaye

Hi, I am trying to run a DTS package from my SQL server command line using DTSrun.exe. I cannot get the syntax right to find the package, for...

artzoop@hotmail.com

09-27-2006 04:56 AM
Charles Kangai

Hi i'm trying to install a dtsx package in SQL Server 2005 Package Store and i'm keeping getting back the error: "The path is not valid". Perhaps...

Hennie7863

09-27-2006 03:30 AM
Hennie7863

I am import Excel files into SQL 2005. I need to capture the total from Excel and compare the total in SQL destination table. If they are not equal,...

Lawrence Lau

09-27-2006 01:55 AM
ramani viswanathan

Can anyone recommend a good book which deals strictly with using Activex in DTS ? Is there an DTS Object Module similar to the Access Object Module...

rmcompute

09-26-2006 06:28 PM
rmcompute

Is is possible to sum data being imported in DTS without actually putting the data details on the 'hard drive'. I want to SUM fields on some...

MikeChicago

09-26-2006 03:11 PM
Lawrence Lau

Good evening from Germany! Has anybody an idea, how I can change the servername for using the DTS-standard-protocol (msdb database, tables...

Steve Brody

09-26-2006 03:07 PM
Steve Brody

Can somebody from the MS team help me with this? I never got an answer. I'm a sys admin on the SQL Server and working locally. I go into bids and try...

sqlboy2000

09-26-2006 02:48 PM
Charles Kangai

Converting mind and server to SQLServer 2005. Bought a book to help in the transition. I need a new DTS project. I open SS Business Inteliigence...

BrianG

09-26-2006 01:50 PM
Charles Kangai

Hello There, I have a very simple SSIS package that I want to schedule to run via SQL Server Agent Job, but so far I was not able to make to...

martino

09-26-2006 11:43 AM
martino

Hi, we use xp_cmshell inside custom procedure to execute DTS and dtexec is any way to create clr procedure that will call dtexec ? could not find...

t2581@hotmail.com

09-26-2006 08:33 AM
Charles Kangai

A ple for advice... The DBA's have configured the SQL Server 2000 (running on Windows Server 2003) DTS to run under the SA SQL Account and not a...

KCSL

09-26-2006 02:05 AM
KCSL

We are anticipating make the change to SSIS next month. I am tying to anticipate issues on the migration trail.

IanO

09-25-2006 03:49 PM
IanO

Hello, I've written a DTS to copy selected objects (stored procs/tables/functions etc - data from tables also) over from a source database to a...

Bob

09-25-2006 08:31 AM
Mayur

Hello. This question was asked by "LucasC" about a year ago and no one answered. I'm having the same issue now. To paraphrase LucasC: "We are...

sonny@nellhead.pointyhats.com

09-22-2006 04:01 PM
sonny@nellhead.pointyhats.com

Hi. I have a simple DTS package set up with a datasource, transform data (for my query) linking to a destination text. I also have a global variable...

Rick Bond

09-22-2006 01:44 PM
Rick Bond

I had created a DTS package which contains a single activeX script task. To this DTS package, I pass the complete connection string via a .bat file....

SainathK

09-22-2006 09:34 AM
SainathK

Hi All, I'm new to dts stuff. I've designed a dts package to create renewed licences. It loops through a number of files, imports the data into...

rachel_c@rocketmail.com

09-22-2006 09:28 AM
Slice

*** Sent via Developersdex http://www.developersdex.com ***

Rick Forde

09-22-2006 09:17 AM
Rick Forde

Do anyone know where to find the package log details that can be displayed by right-clicking a package and choosing "Packages Logs..."? It would be...

dj

09-22-2006 09:09 AM
Slice

Hi all. I need to import csv file stored on some http address to MS SQL 2000 DB. I use...

gNM

09-22-2006 02:17 AM
gNM

I'm running into this bug http://support.microsoft.com/kb/889170/#4 My question is, how do you get the hotfix described in the article? I'm...

Dana

09-21-2006 08:30 PM
Dana

Hi, I am import data from Excel to SQL Server using DTS. But the column name is in the second row (some cells in the first row merged). How can I...

Ava

09-21-2006 02:28 PM
Slice

Hi I am trying to load the 30 records into the database table. I have created one Format File and one .sql file to load the data. I observed one...

Veeru

09-21-2006 02:18 PM
Slice

Using SQL Server 2000 latest SP and DTS Designer. I am using a String trim transformation with -Text file (~ delimited) as data source -SQL Server...

Patrick

09-21-2006 02:12 PM
Slice

All, This is for SQL 2000 DTS. It is possible to run a task (ActiveX in this case) at the completion of a package, regardless of sucess/failure of...

psandler70@hotmail.com

09-21-2006 01:36 PM
Slice

"kiran" <kiran.gazz (AT) gmail (DOT) com> wrote: I think you interpreted the reverse of what I was asking. It appears from the above that you are...

John Hardin

09-21-2006 11:33 AM
John Hardin

To follow a potential fix to the previous worthless thread: ("System Resource Exceeded" DTS XLS) I was able to get around this problem by a manual...

Slice

09-21-2006 10:51 AM
Slice

I'm trying to load 35 million records using bulk insert. The bulk insert works fine in 2000 but fails in 2005. BULK INSERT .. FROM...

carmaboy@gmail.com

09-21-2006 10:25 AM
jashan

Hi, I'm trying to import data from DB2 to SQL 2000. The import works great, however, when I try to edit the 'Transform Data Task' on the workflow...

jeffnelson3@mchsi.com

09-21-2006 09:59 AM
Chris W

Hello, what software products/processes are folks using when it comes to automating problem notification for on-call support of unattended SQL...

Chris W

09-21-2006 09:40 AM
Chris W

Hi all, I have a sql2000 DTS package I'm moving between windows2003 serves on the same network. The moved package appears to lose all column...

Bruce Hendry

09-21-2006 09:14 AM
Bruce Hendry

I got this message "Unable to instantiate XML DOM document, please verify that MSXML binaries are properly installed and registered" in Visual...

Lawrence Lau

09-21-2006 08:16 AM
Lawrence Lau

I am loading data from SQL Server to Teradata using DTS. I am using OLE DB connection. The data loading process is too slow. 1,000 records per...

Black Bird

09-20-2006 02:39 PM
Black Bird

Hi, My initial tests show that this feature will only see DTS Local Packages. How can we migrate the DTS Meta Data Services Packages? Thanks Chris

Chris Wood

09-20-2006 01:51 PM
Chris Wood

We need to scan code behind about 160 dts packages so we can identify which packages use xp_sendmail. Any ideas? is the script generated by a dts...

Joe Functoid

09-20-2006 01:36 PM
Joe Functoid

Options range from a simple Save As in Enterprise Manager through to more automated methods. Transferring DTS...

Darren Green

09-20-2006 11:26 AM
swetha

I am using a derived column to calculate values for exploded sales estimates. The formula is pretty simple (Estimate * (sales/Summedsales)). Each...

SQLIdiot

09-20-2006 10:59 AM
Roy Harvey

Hi, We get the following error dialog box when we try to migrate SQL2000 DTS packages from an SQL2005 server. Index was out of range. Must be...

Chris Wood

09-20-2006 09:55 AM
Chris Wood

Hi, We have a MIMER database which got corrupted. After studying mimer for a long time, still i could not repair the database. So i found a round...

Senthilkumar

09-20-2006 05:31 AM
Senthilkumar

Create your FTP connection manager (with static values). Create a package configuration by selecting Package Configurations from the SSIS menu,...

Charles Kangai

09-20-2006 01:26 AM
Deepesh

I run several DTS Packages that load databases residing on two seperate instances of SQL Server 2000 on the same server. For security reasons,...

PGene2

09-19-2006 07:59 PM
PGene2

I need to set up 2 exports in DTS, they both go to an Excel File. In both cases I need the file name to be dynamic, i.e. company_<todaysdate>.xls 1....

timedrifter@gmail.com

09-19-2006 07:30 PM
John Hardin

I'm trying to schedule a package which exports data from SQL 2005 table into Excel. Package consists of the following blocks: 1. Execute SQL Task...

alex

09-19-2006 01:42 PM
alex

I have just converted an Access application to SQL Server 2005 with no problems. Now that everything is working fine I am looking to create a...

Greg

09-19-2006 04:43 AM
Charles Wang[MSFT]

Hi, I have a problem trying to run a DTS from a flat file to a table using the Transform Data Task Property. I am using VB Script in the...

Kevin Humphreys

09-19-2006 04:27 AM
Kevin Humphreys

Hi, I need to create a generic package in SSIS that can export data to an excel file. I don't know in advance which table or which column to export,...

Dorte

09-19-2006 02:41 AM
Dorte