I am trying to use an ActiveX script task to update the source data of a chart in Excel. The code works as a macro in Excel, but when I move it...

Mike

11-12-2004 12:22 PM
Mike

Hi, I am trying transfer data from Excel file to database using Datapump. I have few 10 rows empty for a column and 11th row has lot of data with...

Sreenath

11-12-2004 11:58 AM
Sreenath

I created a DTS to import a text that is FTP'd from a Unix server. I am not having the common problem with the carraige return character. Instead I...

GaryC

11-12-2004 12:14 AM
Allan Mitchell

hi, Is it possible to to do an incremental update through DTS ? The database tables do not have a time stamp. My problem We have a production...

Tarak

11-12-2004 12:13 AM
Allan Mitchell

1.In strore procedure: SELECT * FROM OpenDataSource('Microsoft.Jet.OLEDB.4.0', 'Data...

land

11-11-2004 10:56 PM
Lan Lewis-Bevan [MS]

Hi I have column FName of varchar type. FName ------ Mktg_2004_03_11Completed Fin_2004_03_10Test Acct_2004_03_09Failed

Steve

11-11-2004 02:23 PM
Allan Mitchell

I have a DTS which runs multiple queries pulling the same type of data from similar tables. One of the 'where' conditions is a date range but this...

awwtau

11-11-2004 02:20 PM
Allan Mitchell

I have inherited several DTS packages that fast-load text files into Sql Server tables. When such steps run, EM indicates that Bulk Load" is...

Snake

11-11-2004 02:19 PM
Allan Mitchell

Can I call a DTS package from inside an executable and return a datatable/dataset to the executable. Thanks, Jase

Jase

11-11-2004 02:18 PM
Allan Mitchell

Hi, I need to automate the execution of REPORTING SERVICES from DTS in SQL Server 2000. As most REPORTING SERVICES are exposed via SOAP, I need a...

Jean-Marc PUGIN

11-11-2004 08:14 AM
Jon Jahren

Hi, I'm looking for a good solution to remove unused records in my dimensions. My users dislike to see unused objects in cube's dimensions and...

Jéjé

11-11-2004 07:07 AM
Jéjé

I had exported data between SQLServer2000 by Source server was SQL Server 2000 any version Destination server was SQL Server 2000 SP3a I had data of...

Poonpipat

11-11-2004 04:09 AM
Poonpipat

Hi, I have two servers with sql2000, one with windows Nt 2000 and another with windows server 2003. When in the 2003 server I right-clicked on <Local...

Andreas Meyer

11-11-2004 02:42 AM
Andi

Hi, We need to automate from DTS the execution of REPORTING SERVICES to run predefined reports against their Data Source (a SQL or OLAP DB). We are...

Jean-Marc PUGIN

11-10-2004 06:13 PM
Darren Green

We have processes which load data collected from around the country in night time DTS processes. Tasks are loaded and run one on the heels...

Lee Gillie

11-10-2004 06:03 PM
Darren Green

Is there a performance difference between running a DTS package from a VBScript using DTSrun.exe opposed to directly executing the stored...

Kevin C

11-10-2004 05:54 PM
Darren Green

Folks, let me first qualify this - I'm a developer and really don't know a lot about Excel. I need to automate some reports that run every morning....

Jim Bailey

11-10-2004 02:51 PM
Jim Bailey

Hi, I want to schedule a package to import access database to sql2000 server (sp3). The pkg fail with permissions error... what do I neet to have in...

JFB

11-10-2004 10:09 AM
Sue Hoegemeier

I tried to create a DTS package to import data from a Excel file then rename the source file. The step for importing data is ok, but the rename...

11-10-2004 07:55 AM

I am loading data from one table to another the structure of both the tables are the same. When I copy from the staging table to the main table I...

Karen Middleton

11-10-2004 04:57 AM
Uri Dimant

Is it possible to get a transform task to process one record at a time and have subsequent workflows execute per record? I have looping implemented...

Leah

11-10-2004 12:09 AM
Leah

Is it possible to use a transform task within a activex sxripted loop? I'd like to process each record handled by the transform task one at a time,...

Leah

11-09-2004 11:33 PM
Leah

Hi all I have a very simple task to pass value which I retreive from execution task against MS SQL Server and using it as an input parameter to...

Gene.

11-09-2004 04:56 PM
Gene.

Ive got a dts package that: Has a string Global Variable. In an active X Script, opens a message box to accept a file path and name. In a Dynamic...

ChrisR

11-09-2004 03:59 PM
ChrisR

OK, this one had me going for quite a while! If you mis-spell the executable name on a Job step of type "Command Line" , this error may result. I...

Snake

11-09-2004 03:54 PM
Snake

Something was wrong with my local SQL Server environment. I was unable to connect to my own SQL Server running on my own workstation. So I...

Joseph Geretz

11-09-2004 03:33 PM
Chris Bellizzi

I need to copy a file into another file. I use this code but I dont get any errors but I dont get the file copied neither. Private Function...

Luis Esteban Valencia

11-09-2004 03:05 PM
Allan Mitchell

I have created a DTS package that writes data to a text file. I want to be able to place a timestamp in the filename so I can keep multiple copies of...

Destination File Timestamp

11-09-2004 03:03 PM
Allan Mitchell

I have created a DTS that sends output to a text file. I want to be able to add a date/time stamp to the file name so I can save multiple copies of...

Otto@ITP

11-09-2004 03:02 PM
Allan Mitchell

Hi, how can I know or log the volume loaded by my DTS packages? I need to evaluate the traffic and the bandwidth required. Does the profiler can...

Jéjé

11-09-2004 01:54 PM
AnthonyThomas

I am having problems accessing metadata for database metadata stored in the Microsoft repository (i.e. msdb database). The objects in the...

William LeConte

11-09-2004 10:50 AM
William LeConte

Which one does the work ? Both ? Isn't most work done on the one that pulls data out...? Can the one that pulls data out cause blocking on the other...

Michael Vardinghus

11-09-2004 09:59 AM
Sue Hoegemeier

When creating a new package under Data Transformation Services with the following information, you get the error message of “Invalid delimited...

goinesj@paec.org

11-09-2004 09:47 AM
Allan Mitchell

Hello, I would like to rename the step in the log file to have something more readable then the default name ?DTSStep_DTSDataPumpTask_xx? Do you...

Franc Benoit via SQLMonster.com

11-09-2004 09:34 AM
Allan Mitchell

Is it possible to email the contents of a directory as part of this task? Thanks.

RR

11-09-2004 08:37 AM
JFB

Hi folks, I have a problem with scheduling one package with dtsrun, because dtsrun returns 1 which is interpreted as Error, although the package...

Helge C. Rutz

11-09-2004 04:54 AM
Helge C. Rutz

Hi, I have two questions: 1) I have the same databases on two different servers. I modified, added and dropped indexes on one of the databases and I...

Leila

11-08-2004 01:09 PM
Allan Mitchell

I have a DTS package that reads a text file. The delimiters are tab for columns and {CR} for rows. When I import the file with the DTS, the...

Stacy Hein

11-08-2004 01:05 PM
Allan Mitchell

Hi there, I just created a DTS package to copy data from an oracle system to MS SQL 2000 Server. However when I try to edit the data within my table...

Liam Mac

11-08-2004 01:02 PM
Allan Mitchell

I am trying to call a DTS package from a VB.Net application. If my application is on the DB server it works correctly. If I move the application to...

adam

11-08-2004 11:04 AM
JFB

Hi, I have to call a DTS package from ASP, for this I have created a stored procedure that calls DTS package. I am calling that stored procedure...

Aamti

11-08-2004 10:02 AM
Aamti

Hi there, I have some DTS routines which run overnight doing some calculating and some flattening of data and form a Data Warehouse Database. We...

Cammie Watson

11-08-2004 09:09 AM
Cammie Watson

Hi, I have a sql server with authentication set to Windows only I have a DTS pacakge that does a monthly update a some static data. I load the data...

marc

11-08-2004 02:17 AM
Darren Green

Hi, This seems so simple, but I can't figure it out. I'm trying to keep a 'seed' value in a global variable as an integer value, essentially a...

effervescent@hotmail.com

11-07-2004 05:49 PM
Nigel Rivett

Hi, This seems so simple, but I can't figure it out. I'm trying to keep a 'seed' value in a global variable as an integer value, essentially a...

effervescent@hotmail.com

11-07-2004 03:44 AM
Allan Mitchell

Hi, This seems so simple, but I can't figure it out. I'm trying to keep a 'seed' value in a global variable as an integer value, essentially a...

effervescent@hotmail.com

11-07-2004 03:14 AM
effervescent@hotmail.com

Hi, I am trying to use the DTS export wizard in SQL 2000 to transfer stored procedures between from one database to another. I keep getting this...

peter

11-06-2004 03:36 PM
Allan Mitchell

Hi, I am getting error when I run the following statement declare @a nvarchar(255) select @a = tblname from logtbl where tblname like...

Steve

11-06-2004 02:18 AM
Allan Mitchell

Is there I way to export data into .csv executing code not using wizzards? Something similar to INFORMIX command. UNLOAD TO //path/filename.csv...

aurelio

11-06-2004 02:16 AM
Allan Mitchell

Greetings, I am going mad with DTS. I have two SQL Servers, one on my PC for test purposes and the other at a remote location. I developed a DTS...

Cagdas Ozgenc

11-06-2004 02:15 AM
Allan Mitchell