Hi there. This happens on the server only. Sql 2K. When trying to create a new package I get the "DTS Designer Error" window. After clicking on...

FinFlorida

02-06-2008 10:30 AM
FinFlorida

Hi, When I create a new DTS package or choose an existing DTS package, the following erratic behaviour is _sometimes_ observed (and driving...

ErikYkema

02-06-2008 08:26 AM
ErikYkema

I am looking to take the results of a WMI query and store in a table. I want to retrieve and store centrally data like: disk space, OS information,...

Mark

02-05-2008 04:16 PM
Mark

I am getting this error on this line in an ActiveX task. I am not sure why. Dim oConnection as DTS.Connection2 In fact it happens in any line which...

John Dalberg

02-05-2008 02:51 PM
John Dalberg

Hi all, I'm writing a custom control flow task, which should access a SSAS database / cube (using C#). In the package hosting my task, I configured...

Stefan

02-05-2008 11:17 AM
Stefan

Hi, How do I set the IsBig Property of Aggregator transformation in SSIS? Regards, Gayatri.

Gayatri

02-05-2008 02:05 AM
Gayatri

Hello all, I'm assuming BIDS and VS2005 are the same thing. I don't remember if VS2005 was already on this computer before installing SQL 2005...

Conan Kelly

02-04-2008 02:29 PM
Conan Kelly

We are attempting to import data from several SQL Server databases with identical tables structures - into a single database that will be run...

SoccerFan@community.nospan

02-04-2008 12:31 PM
SoccerFan@community.nospan

I am using a global variable in a DTS package. When I add the '?' which represents my global variable within the DTS package it throws a...

JDS

02-04-2008 11:37 AM
JDS

An excel spreadsheet has to be open on Machine B on the network to pull data from a third party tool. I have to refresh several columns in this...

arkiboys2

02-04-2008 10:29 AM
jhofmeyr@googlemail.com

I am using MS SQL Server 2000 together with the DTS Import/Export Wizard and MySQL Connector/ODBC 3.51 to import data from MySQL to...

c.osborne@nls.uk

02-04-2008 08:54 AM
Sean McCown

Hi, Using ssis, is it possible to refresh the data inside an excel file which is sitting on a separate machine (i.e. machine B) on the network? When...

arkiboys2

02-04-2008 06:53 AM
arkiboys2

First time having to import Oracle data: I am unable to change datatypes in the Oracle table, but how to convert numeric to int etcetera, see error...

jos

02-04-2008 04:32 AM
jos

Hi everyone, I am working to learn DTS as a method to pull data from legacy Access database(s) into a new SQL Server 2000 data structure, rather...

Ed B

02-04-2008 03:51 AM
jhofmeyr@googlemail.com

Hi all, I have a very simple SSIS package with data reader as my souce (getting data from Oracle w .Net Providers/OracleClient Data Provider...

ila

02-04-2008 03:44 AM
jhofmeyr@googlemail.com

Hi, I'm using SQL Server 2000. I'm reviewing all of the DTS packages that we have in Production and I'm looking for a way to identify when a DTS...

darrin.wilkinson@cma.ca

02-01-2008 02:15 PM
Sean McCown

Hi, I've used a SendMail task in one of my SSIS package. Earlier it work fine. But now it fails with the below error Error: An error occurred with...

AVL

02-01-2008 02:13 PM
Sean McCown

Let's say I have ssis package that collect some data from N sql servers (all on the same domain). All connections are windows authentication. I want...

l

02-01-2008 01:56 PM
Sean McCown

Hi, Here is a strange problem i"m facing with my SSIS pakcage. I've a SSIS package which reads from a csv file and loads the records into database....

AVL

02-01-2008 01:45 PM
Sean McCown

Here is our problem – we are trying to get Visual Studio/SSIS development environment set up that would be able to connect to our Oracle Database...

ila

02-01-2008 01:40 PM
Sean McCown

We have a DTS package that moves a file between 2 servers. Randomly, instead of moving the entire file, it moves only one record in the file. This...

mscertified

02-01-2008 01:38 PM
Sean McCown

I have created Metrics Report but I am having problem to add summarized detail of my rows and Columns. For instance. Col1 Col2 R1 1 ...

Smith

01-31-2008 05:58 PM
Smith

For years I have been accessing the DTS wizard through Entrprise Manager to do casual copies of data between SQL Server 2000 instances on...

Peter Hyssett

01-31-2008 01:15 PM
Kevin M

I'm trying to pass a global variable from a DTS package to the child packages that it calls using ExecutePackage tasks. I have selected the child's...

Dallas Texas

01-30-2008 04:16 PM
Dallas Texas

Does anyone know if SSIS is included in the SQL 2005 evaluation version ? -- ___________________________________ Search IT jobs from multiple...

Jack Vamvas

01-30-2008 02:20 PM
Francisco A. Gonzalez

Hello here how can i transfer data of tables from server1 to server2 with SSIS while the data on server1 is being loced by transaction? can i set...

Roy Goldhammer

01-29-2008 12:25 PM
l

Hi: I am trying to programatically create a dts package that reads data from a MS Access database that employs Workgroup security. Can anyone...

Dedge

01-29-2008 11:49 AM
Dedge

Hi, I've used a SendMail task in one of my SSIS package. Earlier it work fine. But now it fails with the below error Error: An error occurred with...

AVL

01-28-2008 07:02 AM
AVL

I would like to execute a ssrs report from within a ssis foreach loop but there is no task especially for this so I tried to use the web service...

john pryor

01-28-2008 02:48 AM
PubDC

I've just been presented a brief introduction to Integration Services by one of the DBAs in our company. Everything looks different... and I'm not...

drink.the.koolaid

01-27-2008 03:34 PM
drink.the.koolaid

Hi, I am trying to move the DTS packages from SQL server 200 to Sql Server 2005. I am unable to do this. Can someone please help me? Thanks,

msx86

01-25-2008 12:33 PM
Sean McCown

Hi @all! I have got an application developed on 32 bit Windows. This application controls and executes DTS Packages on a SQL 2000 Server. So far...

Gaaas

01-25-2008 09:33 AM
Gaaas

Trying to learn SSIS basics and have a test Excel 2007 file - 4 columns and one row of data: Text, integer, date, and text. The date is formatted...

Duke Carey

01-24-2008 12:32 PM
Duke Carey

Hi, I am trying to populate the decimal values 0.000001 from the excel to one of the field in my table using DTS but it is not populating...

Vandy

01-24-2008 12:28 PM
Vandy

Hi. I've created my first SSIS Package and need to schedule it to run hourly on a remote server. Could someone tell me how this scheduling is done,...

Mike

01-24-2008 11:02 AM
Sean McCown

Hi guys. Well, I think the main subject is self descriptive... I have to copy many rows as fast as I can. Both databases (source and target) are on...

efinkelb

01-24-2008 09:35 AM
Jack Vamvas

I had a job to run a DTS package. Do I have to reschedule the job after I modified the DTS package ? OR The SQLAgent job will pick up the new change...

Johnny

01-24-2008 08:39 AM
Sean McCown

How can I create and traverse through the records of a dataset in DTSx package? Should I create s script Task and edit the script, or try the...

rkbnair

01-24-2008 12:07 AM
Charles Wang[MSFT]

I have a SSIS package the makes a flat file connection to a file on our network which has the same name and location everyday. I can connect to when...

NC3

01-23-2008 02:04 PM
Sean McCown

Hello, I am trying to Schedule DTS Package using dtsrunui. When I run DTS directly from dtsrunui window it is working fine. But When I am doing...

Bhavik Shah

01-23-2008 09:28 AM
Russell Fields

Hello, I have Excel 2002 installed. At the driver list in the data source field in DTS, the "highest" Excel entry is "Microsoft Excel 97-2000". How...

Joachim Hofmann

01-23-2008 08:53 AM
Sean McCown

hi, I used SSIS package configuration files, with "DontSaveSensitive" protectionlevel, (like the 4'th method of the microsoft...

CD

01-23-2008 04:12 AM
CD

I ahve written some code that takes a templated package and updates all the relevant columns and reader/destination sources. This package when run...

Paul Lineham

01-23-2008 03:21 AM
Paul Lineham

Hi Professional, I worked on sql server 2000 and in which I worked on DTS and in 2005 I worked on SSIS but I would appreciate if you can tell me...

Smith

01-23-2008 02:03 AM
jhofmeyr@googlemail.com

I am trying to create new transformation for my dts package, when i try to open activex script transformation properties window it gives me error...

kkk

01-22-2008 10:49 PM
kkk

I keep getting the below error when trying to make a dynamic connection to a directory of csv files. The message is clear that this is a source...

NC3

01-22-2008 07:59 PM
Sean McCown

Hello all, Is anyone having problems with the FolderBrowserDialog being blank in a script task? Please see my thread in ms.pub.dotnet.languages.vb...

Conan Kelly

01-22-2008 07:55 PM
Sean McCown

Is there something you can run(srcipt) to determine if any of your packages are using a userid/password? Thanks.

AHartman

01-22-2008 07:55 PM
Sean McCown

Gurus, I have an interesting situation I have a dts package that will have to have a subquery in one of the tasks... This subquery will have to...

Bill Orova

01-22-2008 07:54 PM
Sean McCown

I am executing DTexec to consume an SSIS package on the file system. I am getting a password failed to decrypt error ??? and have no idea why? Thank...

Hoa.Hoa.Nguyen@gmail.com

01-22-2008 07:54 PM
Sean McCown