I am having some OLAP cubes and it is refreshing using the DTS packages in sql server 2000. Now I am trying to run this dtspackages using DTSRUN...

ePD2010

09-10-2009 02:18 AM
ePD2010

I am trying to run the following statements from a stored procedure in SQL SERVER 2008 64 bit version. SELECT @cmd1 = 'DTSRUN /S ' + @serv + ' /U...

ePD2010

09-09-2009 01:41 PM
Gerald Aichholzer

Hi, I'm Jennifer Kenney, I'm mostly SQL/TSQL, but I'm using DTS for obvious DTS things, and I've got an issue with DTS respecting the Row Delimiters...

Jennifer Kenney

09-09-2009 03:34 AM
Shankar

I have two databases Frontend and backend. All data of years since the db started working is kept in Backend (you can say it as historical data...

Shamshad Ali

09-08-2009 10:42 PM
Shamshad Ali

How much of an impact does DTS Package Logging have on a SQL server's performance?

elpepe

09-04-2009 02:53 PM
Russell Fields

Hi, The environment is below:- SQL Server 2000 Enterprise Edition 8.00.2055 Windows Server – Windows 2000 Advanced Server and Windows 2003...

subi15

09-01-2009 04:25 PM
subi15

Currently receiving error for log file creation upon package start. Are environment variables supported for path determination of log file? Is there...

jsh02_nova

08-28-2009 08:53 AM
Todd C

First off, I apologize if I am posting to the wrong group. Also, I am not very familiar with work with different file source encoding, so...

Rubens

08-26-2009 01:26 PM
Rubens

We have moved our SQL server from one domain to another and, having changed the services login to the new domain, are having strange issues with DTS...

Dazza

08-25-2009 02:02 PM
Dazza

When executing a DTS package under SQL server 2000, for each step certain information is made available upon completion of each step. There are...

Leo

08-25-2009 10:17 AM
Leo

Hello, I'm using an Execute SQL Task that may or may not return a value that is assigned to a variable (via a signal result set). Now if it does not...

Fsb

08-21-2009 08:44 AM
Todd C

I have a DTS package that looks like it now is missing when looking at it the Management Studio (2005). I know it must be somewhere because the job...

Chris

08-19-2009 11:26 AM
Lucas Kartawidjaja

I have an linked server between and Oracle (OLE DB) and SQL Server 2005 database. When I try to insert data into SQL Server table I received the...

Joe K.

08-18-2009 07:51 PM
JPaul

Hi, I'd like to store the connection password in a variable (DB2 connection) and then use the variable for the connection in a VS2005 - SQL Server...

Screaming Eagles 101

08-14-2009 08:51 AM
Todd C

Hello. I have unicode data in a ntext field. I am attempting to use DTS to export the data to flat files. The table stores data in various...

ckdong

08-12-2009 10:10 AM
ckdong

Hello, I have 2 databases sources that have the same tables, columns and layouts. One database for Canada and one for USA. in both these databases...

Fsb

08-11-2009 08:45 AM
Todd C

I have 4 instances with DTS packages on each and I have to migrate everything, including DTS packages, to a single instance. What is the best way to...

Snake

08-07-2009 01:13 PM
Snake

Hi All, i have a tedious problem: I need to execute a remote DTS from a client machine(the application server), with DTSRun tool. The problem is...

Niki AU

08-06-2009 10:29 AM
Niki AU

I need to map correctly the SSIS variable datatype with the datatype of a column returned from a T-SQL query. Does exist a prospectus about...

Pasquale

08-05-2009 09:01 AM
Todd C

Jan: I'm no expert in performance stuff like this, so this bit of free advice may be worth exactly what you have paid for it ;-) Have you looked at...

Todd C

08-05-2009 08:44 AM
Todd C

We have several SSIS packages that use a third party ZIP component to unzip files that worked fine with SQL 2005 we recently upgraded to SQL 2008 and...

davids@thorntonsinc.com

08-04-2009 10:46 AM
davids@thorntonsinc.com

http://www.nanometer.ru/users/microsoft-lsd-tv.html doctor-lsd-tv (AT) yandex (DOT) com tel.8_9195265461 patent Japan

doctor-lsd-tv Google

07-31-2009 06:26 PM
doctor-lsd-tv Google

Hi, I'm running an execute sql task in DTS on SQL 2k, that executes a sproc*in a FOR loop. When there are no issues, the step executes, and the...

pchak

07-31-2009 02:27 PM
pchak

Hello, have a source table: Business Key Value 1 A

Fsb

07-31-2009 01:27 PM
Todd C

Hi, My Source DB is on a hosted remote sql server 2005. I created an exact database on my local SQL 2008 Developer. I use SSIS to import data...

Med

07-30-2009 01:00 AM
Andrew

Am using SSIS to create an excel file. It works fine the first time but later crashes as it ask to re creat the excel destination table. I found a...

SSIS_Beginner

07-29-2009 03:08 PM
Todd C

Gurus: is there a way to have a source column copied to several destination columns in a single destination table using ssis Wisord *** Sent via...

Bill_Orova

07-29-2009 02:57 PM
Todd C

Hi SQL Server experts: I'd like to transfer a table from one db to another. The export only transfer data, not index, constrain or triggers. Is...

Pingx

07-29-2009 01:53 PM
Bill_Orova

Gurus: This task ( from the previous post)should be done in as little steps as is possible I could use the primary load of four columns then update...

Bill Orova

07-29-2009 01:39 PM
Bill Orova

Hello, I have a conditional split that splits records into valid and invalid. How do i send an email of invalid records to the DBA?

Fsb

07-28-2009 11:01 AM
Russell Fields

When trying to convert a MSSQL (2008 Express) database to MySQL (5.1) My systems throws the following error: Messages Error 0xc020844b: Data Flow...

Luuk

07-24-2009 03:03 PM
Luuk

How can I determine what is causing the following package to fail? Error: Error 0xC0012050 while loading package file "C:\Documents...

Terry

07-24-2009 09:51 AM
Janthijs van Dam

Details are as follows: Package versions: Microsoft SQL Server Integration Services Designer Version 9.00.4035.00 Microsoft Visual Studio 2005...

Jude_44

07-24-2009 04:30 AM
Jude_44

My data source is an excel file. One column named should contain numeric data, however every month the excel file is received with about ten out of...

dbuchanan

07-23-2009 09:11 AM
Todd C

Hi, I´m trying to retrieve data in SSIS from DB2 server with OLE DB and the data access mode "SQL Command". The SQL query I am using works in SQL...

Philipp André

07-23-2009 08:44 AM
Philipp André

Here's a situation you won't find every day. I have a big database project that I am taking over. There is a set of 6 DTS Packages that import 6...

AT

07-17-2009 01:41 PM
CJ

Hi, I am sourcing data from an excel file using DTS and I get the following error message. "Error Source: Microsoft JET Database...

Socrates

07-15-2009 03:15 PM
Socrates

I’m running the Import/Export Wizard from SQL 2005 to export data from a SQL database to another SQL database on the same server. I select the...

marcolorado

07-13-2009 04:36 PM
marcolorado

Hi I have an XML file and I need to import this to sql tables using DTS (I did this using MSAccess and it had returned in 4 tables). But Im using...

EdSilva

07-13-2009 09:11 AM
EdSilva

Hi, I used to make DTS packages on the 'older' SQL server and then add it as a Job on the SQL Server Agent to copy data from the mainframe computer...

Screaming Eagles 101

07-09-2009 02:08 PM
Screaming Eagles 101

Is it possible to determine the name of the DTS package, from within the package that's running? I have a couple of email steps that send a status...

Andre

07-06-2009 10:28 PM
Andre

I have a simple ssis (it just creates a table). It has a variable tblName. When I give a valid variable name, the ssis works fine. In the orignial...

GE

07-02-2009 10:36 AM
GE

I have an activeX task that performs a loop and at the end of every loop i want it to execute the exec sql task. I have tried: Set objSQL...

Ben

06-26-2009 05:48 AM
matteog

Hi I confess I pretty much hate SQL Server 2005 now DTS tasks which were absolutely trivial in 2000 now have become nightmares. I create scripts...

Jonathan Crawford

06-25-2009 09:16 AM
Todd C

SQL 2k, sp4a (the latest sp) Is there a way to do a conditional step in DTS, like there is in SQL 2005? Basically I have a DTS package that does...

Andre

06-25-2009 12:54 AM
Andre

I am using Vista Ultimate 64 (8 GB memory), with SQL 2008 Developer Edition. I used SSIS import / Export wizard to create the package. (DTS). when I...

Kam

06-21-2009 09:48 AM
Kam

I am hoping this is the right forum as the title implies this is for the older DTS rather than the newer DTSX packages that are part of BIDS. ...

thejamie

06-21-2009 08:33 AM
thejamie

Does anyone know how to write to or modify the log output of dts? Currently the output looks something like this.. DTSRun: Loading... DTSRun: ...

Bill Swartz

06-19-2009 11:55 AM
Luis Gonzalez

I have converted a sql 2000 dts job to sql 2005 SSIS (64 bit). The package exports data to excel. I have the Run64BitRuntime project property set...

doug

06-19-2009 08:59 AM
Todd C

I have a SQL 2005 SSIS package that retrieves a file on a iSeries (AS400 v5r3) database and brings it to a SQL table. I use the IBMDASQL provider. ...

Jim Covington

06-17-2009 12:42 PM
Jim Covington