I have created a DTS package which transform rows of one table from sql server to oracle. What happens is while transforming rows, if there is a...

mvp

07-15-2006 04:52 AM
Allan Mitchell

What is the best way to load records into a destination only if the pk value does not exist? tia chris

Chris

07-15-2006 04:42 AM
Allan Mitchell

Hello, I have tried to create configuration XML file and it is working, but when I am trying to put configuration parameters into SQL table I...

luk

07-15-2006 04:39 AM
Allan Mitchell

In SQL 2005 SSIS - how would I be able to load data into a oledb destination table only if the record does not exist? I could load the data into a...

Chris

07-15-2006 04:36 AM
Allan Mitchell

I have a strange error. Here's the setup: Local machine (L), myself: full SS2005 suite (9.0.2153), SS2000 (8.0), and Win XP Pro SP2. Remote machine...

shakir

07-14-2006 03:51 PM
shakir

I am experiencing a problem when using a .UDL file to change the SQL server / database settings. Scenario: ------------- I am importing data through...

kiss deez

07-14-2006 03:15 PM
kiss deez

Hi, I am trying to use a File System Task within a SSIS package to copy and rename a group of files. When I run the package from the Visual Studio...

AT

07-14-2006 10:50 AM
AT

I have three Stored Procedures in DTS, in which first stored procedure is writing header row in destination file with four column. Second procedure...

Dipa

07-14-2006 04:47 AM
Dipa

SQL Mail Task - may run it by table trigger and send email with insert information? Is it possible? Are anywhere examples?

Dmitry N.Ananyev

07-14-2006 04:10 AM
Davide

I put a SQL Statement in my ActiveX and I can't get the correct Textbody to be sent. The Sql Statement returns a 1 in query analyzer. However, when...

javathehutt

07-14-2006 03:20 AM
Frans van Bree

Is it possible for a sql server 2000 DTS package to get data out of sql server 2005 database? When I specify the source database (which is SQL...

EroPro

07-13-2006 02:23 PM
EroPro

I'm trying to set up a dts package that will eventually run automatically every day. A sql query gets the data and formats it as a string and dumps...

AT

07-13-2006 01:45 PM
AT

I have created a DTS package which transform rows of one table from sql server to oracle. What happens is while transforming rows, if there is a...

mvp

07-13-2006 12:48 PM
mvp

Hi, I'm using a data flow task having a raw file destination in a foreach loop. Basically it looks like this: file system task: delete raw...

Gerald Aichholzer

07-13-2006 10:02 AM
Gerald Aichholzer

Hi, I've got a windows service that creates a DTS task at runtime to export data to textfiles. After a certain time the service always crashes and...

Natasja

07-13-2006 07:20 AM
Davide

Hi, I am able to execute a DTS package from a stored procedure just fine using the login credentials from SQL Server. How can I, in the stored...

Chris

07-13-2006 06:36 AM
Frans van Bree

Hi All, First of all I would like to say that these newgroups are brilliant for support, thanks to all that has contribute to any my previous...

Liam Mac

07-13-2006 05:51 AM
AT

Following the codes on http://www.sqldts.com/default.aspx?245 (Thank you Allan Mitchell!), I'm able to delete the default worksheet 'Sheet1' and...

Danny Tan

07-12-2006 11:55 PM
Danny Tan

I am using DTS from VB6 to transfer a table from an Oracle database into SQL Server. There are 17 tables, so I am looping to transfer the tables,...

WayneM

07-12-2006 10:38 PM
WayneM

Hi Folks I will be running my DTS program and calling Excel Macro functions and performing Excel Cell Value checking on a server that does not...

javathehutt

07-12-2006 07:13 PM
javathehutt

I want to import xml into varchar fields using SSIS, but the package designer does not allow me...I get an error... cannot convert between unicode...

forrestsjs

07-12-2006 05:30 PM
Hasan Quadri

I have a large text file (3.5GB) that I need to import. Each record is terminated with a CR/LF. However, the length of each record varies...

MikeV06

07-12-2006 05:18 PM
MikeV06

Is there a way to upload UTF-8 encoded Unicode files into SQL Server 2000 at all? I have seen the conversion tool...

Ben Rum

07-12-2006 03:34 PM
Ben Rum

Hi, I am pretty new at DTS development. I am using the logging feature to write the execution status to a text file. I then want to send mail with...

JennB

07-12-2006 10:23 AM
JennB

Problem: I need to provide an Excel spreadsheet to a partner. I export the data from SQL Server 2000 to the Excel spreadsheet, using DTS, without a...

AT

07-12-2006 09:16 AM
AT

All, I have a SQL Server dts package that I converted several months ago. The program basically takes paradox tables and moves them into a...

Rog

07-12-2006 07:58 AM
Rog

Hi, I have a small problem with tranformation. The code is: Function Main() a = DTSSource("ConfQuantity").value if ...

MacChojnacki (AT) googlemail (DOT) com

07-12-2006 07:20 AM
Davide

I am new to DTS. I have one table which has password column in it. I would like to create the password from username.I one function which depends on...

Monu

07-12-2006 02:26 AM
Davide

I need to create a DTS package that sends out an email based on a query. Query: SELECT @Count= count(*) FROM employee WHERE site = 1 If @Count=0...

ngorbunov

07-12-2006 01:55 AM
Davide

i want to make a package, that it can get how many rows in a table. when the table get a new record. the dts will send an alert to the admin, or the...

Mint

07-11-2006 10:04 PM
Mint

Hi I get a 'Object not supported error xl_app.Workbooks.Worksheets" when I add this line in the program: "If ...

javathehutt

07-11-2006 05:09 PM
javathehutt

Hello, Im trying to execute an XML Source task to SQL Server Destination. SSIS Creates a column _Id] and makes it a type of DT_Uint8 - an 8 byte...

Rob Schieber

07-11-2006 12:33 PM
Gerald Aichholzer

for example:get a rowcount to the DTSGlobalVariables and then check it in the ActiveX script. could any one help? thanx

Mint

07-11-2006 08:26 AM
Davide

Hi, My DTS has odbc connection pointing on DB2 UDB 7.2 and execute sql task with update query dts return error where is no rows updated db2...

AT

07-11-2006 08:21 AM
AT

We upgraded to SQL Server 2005. We are still running DTS packages from our SQL Server 2000 instance until we can rewrite them in SSIS. How do I view...

Arbeebee

07-11-2006 07:48 AM
Arbeebee

I tried adding a Data Flow Task control to my BI project and got this error when trying to rename it: TITLE: Microsoft Visual...

Jason

07-11-2006 03:35 AM
AT

SQL2K SP4. Howdy all. I've got a package that imports 7 .txt files into 7 different tables. When running the package, they say "Started" next to...

ChrisR

07-11-2006 02:27 AM
Davide

I'm doing something like this Executable e = MydataFlow.Executables.Add("STOCK:ScriptTask"); TaskHost th = (TaskHost)e; th.Properties.SetValue(th,...

Robert

07-10-2006 04:38 PM
Robert

Nob Hill Software, maker of several popular SQL Server tools, now have their own SQL Server schema comparison tool. It is Superior to other tools on...

AT

07-10-2006 04:34 PM
AT

Hi I am trying to import a Excel sheet into a table in SQL Serever 2005. The first row of the sheet contains the column names, and the columns match...

steveh

07-10-2006 04:15 PM
steveh

Hi I am trying to import a Excel sheet into a table in SQL Serever 2005. The first row of the sheet contains the column names, and the columns match...

steveh

07-10-2006 04:15 PM
steveh

I have successfully configured and tested database mail on a sql server 2005 instance. When I attempt to create an SSIS "Notify Operator" task...

SouthernPost

07-10-2006 03:36 PM
SouthernPost

Hi Everyone, Was wondering if there was a simple way to automatically download web log files? On our FTP site under Logs/W3SVC3 there is a new file...

AT

07-10-2006 12:45 PM
AT

Hi, we exports a DTS-Package as a VB-Script to change the some servernames with search and replace operations. Now we should import the...

Hans Glasbrenner

07-10-2006 12:06 PM
Hans Glasbrenner

I'm trying the RetainSameConnection property with a very simple scenario including two ExecuteSqlTasks: the first has Begin Transaction statement...

kalimi

07-10-2006 11:41 AM
kalimi

Is it possible to tweak any setting to display the full line of the task's text description in the DTS Designer? I saw it being done on sqldts.com...

CodeDigger

07-10-2006 10:48 AM
CodeDigger

Hi, I've set up a new server, win2003 + SQL2000 SP4. No way to create or edit a DTS, I've got an error in the MMC: 1'st pop up: error creating a DTS...

Bruno DUPUY

07-10-2006 10:42 AM
Bruno DUPUY

Hi all, I have a problem... I have two DTS packages that run fine, each one contains several steps all related to build shared dimensions and cubes...

Canadean

07-10-2006 09:27 AM
Canadean

Hi, I've got a SQL taks in DTS 2000 and a global var with a float number. I try to get the value of the parameter in the SQL task: declare @Total...

Philippe

07-10-2006 09:05 AM
Davide

Hello all! I am changing the collation on the database and doing a DTS package to copy all of the tables from one database to another. Can someone...

George

07-10-2006 07:59 AM
George