Is there any way to run OLE Automations SPs like sp_OACreate 'DTS.Package',... on the 64 bit server or they have to run from the 32 bit...

Froogle_dabs4work@dabs4work.com

03-14-2008 06:12 AM
Froogle_dabs4work@dabs4work.com

I swear there is a way in SQL 2000 to have a SQL Server Agent job (that runs a DTS) to stop running if it's been running for X minutes. I can't find...

Rich

03-13-2008 11:26 PM
lonnye

I have a flat file that needs to be imported. Each column is of the format: COLUMN_NAME = VALUE, e.g. c1= v1, c2=v2, c3=v3 c1= a1, c2=a2,...

Pingx

03-13-2008 04:19 PM
Pingx

Hi, I have a security problem calling a DTS from a store Proc If I launch the DTS manually no problem If I call the same DTS from a store Proc I...

GC

03-13-2008 02:37 PM
GC

On Mar 13, 1:48*pm, "Steen Schlüter Persson (DK)" <st... (AT) REMOVETHISasavaenget (DOT) dk> wrote: Aah - you're using an OUTPUT parameter :) I...

jhofmeyr@googlemail.com

03-13-2008 11:23 AM
jhofmeyr@googlemail.com

I'm using expressions for some of my error handling and I need help with syntax. I need to use the replace function to remove quotes from...

Rmoore

03-13-2008 07:14 AM
Charles Wang[MSFT]

Hi all I just ran sql upgrade advisor and got the following message: "You can use SQL Server 2005 tools to edit your existing DTS...

c676228

03-13-2008 06:38 AM
Charles Wang[MSFT]

Greetings I have a successful DTS (SQL 2000!) package which imports many Excel 2003 timesheets. The columns contain numbers, strings and a...

davemateer@gmail.com

03-13-2008 12:42 AM
davemateer@gmail.com

Hi, I'm trying to export a table to a flat file. the date column showed up like this in the flat file 2007-05-31 13:02:39.777000000 This caused a...

Pingx

03-12-2008 05:44 PM
lonnye

Error Source: Microsoft Data Transformation Services (DTS) Data Pump Error Description:Insert error, column 1 ('ID', DBTYPE_NUMERIC), status...

palemraju

03-12-2008 05:33 PM
lonnye

Everything was working fine with DTS. All of a sudden I got this error while trying to add another line to a large DTS package: Microsoft...

rmcompute

03-12-2008 02:51 PM
rmcompute

I am relatively new to SSIS and am trying to set up an FTP task. I have run into a twofold problem: 1. The password will not save in the FTP...

hedgracer

03-12-2008 09:49 AM
hedgracer

I have this SSIS Package that writes to an Exel datasheet. I need to delete its content before update it with new data. How can I delete the Excel...

Lina Manjarres

03-11-2008 05:22 PM
Lina Manjarres

Hello, I have a DTS package ("pkg1") on Server 1, and it's last task is an Execute Package Task. The package it executes ("pkg2") is on Server 2. ...

Eric Bragas

03-11-2008 12:47 PM
Eric Bragas

I have created an SQL stored procedure to execute a DTS package. I am looping through a table to obtain a branch number and then running the DTS...

rmcompute

03-11-2008 09:39 AM
Mike K

Hi, I was wondering if it is possible to use SSIS to automatically fetch a flat file from a webpage if so does anyone have a hint how to do...

matt

03-11-2008 09:36 AM
Mike K

Hi, I'm using SSIS on SQL2005 XP2. I've got an Oracle OLEDB connection. I've got a simple SQL Task on my Oracle DB (returning one field in...

oxiane@gmail.com

03-10-2008 11:32 AM
oxiane@gmail.com

Hello, I would need information about the different ways to load data in a SQL Server from a flat file. I am aware of: Integration Services Bulk...

dlf

03-07-2008 05:36 AM
Dinesh Asanka

My clients have an Parts Management application that sits on a SQL Server 2000 database. Every month they obtain a list of parts from another...

teddysnips@hotmail.com

03-06-2008 03:20 PM
Anith Sen

I am creating a DTS package and in the DTS package I am writing a VB scriprt, I have this procedure called 'IsAllDataDeleted' and it returns integer...

ttad

03-06-2008 02:26 PM
ttad

I have an additional comlpexity. I need to check within an existing DTS package on how to check if the source field exists before I map to a...

bl..@gmail.com

03-06-2008 02:24 PM
bl..@gmail.com

I have this store procedure called IsAllDataLoaded which returns intgere value,] I want to write a VBScript and invoke this stored procedure in my...

ttad

03-06-2008 02:16 PM
ttad

One of our business partners provides us with product price and inventory via a web page. To manually access this data we go...

bwallacejr

03-06-2008 02:05 PM
matt

Hello I need to migrate all my dts packages from sql server 2000 to sql server 2005 so I can access these packages under Legacy->DTS in Microsft sql...

Lena

03-05-2008 03:40 PM
Lena

Hi, I have created a DTS Package in SQL Server 2000, is there any way that a different user can edit and execute that DTS WITHOUT having server roles...

Elidas

03-05-2008 04:28 AM
Elidas

I created a dts package to import data from an access database. I will need to do this nightly. I saved the packge, but when I try to run this with...

Dee

03-04-2008 01:03 PM
Russell Fields

I'm recovering data using WMI Data Reader. It can store the return as a Data table to a variable of type Object. For practical reasons, I am trying...

Keithr

03-04-2008 10:09 AM
Keithr

Hello all, Is there a way to process Analysis Services 2000 cube from SSIS 2005 package? Thanks for any help anyone can provide. ID

exkievan

02-29-2008 06:31 PM
exkievan

Hi! I have a scenario where I have to read about 40 MB of data from a database, transform this data into another format and write it then in...

Klaus Aschenbrenner

02-29-2008 05:25 PM
Klaus Aschenbrenner

Hello all! A couple of weeks ago, I was able to open a DTS package, right- click and see the VB Script code in a window... This past week, all I can...

hlafor@hotmail.com

02-29-2008 10:31 AM
hlafor@hotmail.com

Predictive Analytics for Business, Marketing and Web is a concentrated training program that includes interactive breakout sessions. Dates: April...

Elise Johnson

02-29-2008 02:50 AM
Elise Johnson

I'm having an Authentication issue. I have created a package to merge the data from two tables in Oracle to a single table in SQL Server. When...

Dave Hauze

02-28-2008 06:12 PM
Dave Hauze

Hi, I'm new to DTS so wondered if this was possible and if it is does anyone has any pointers on how to do it or good places where I can learn? I...

Jimbob666

02-28-2008 03:24 PM
Blue Sky

Hi One of our SQL 7 server has broken and down, and the tecnician made a new SQL 7 server, over one W2K3, and full restoring last back up's, our...

julio

02-28-2008 12:08 PM
julio

I received the following message from a DTS package that fails. 'Subquery returned more than 1 value. This is not permitted when the subquery follows...

Jay via SQLMonster.com

02-27-2008 11:28 AM
Jay via SQLMonster.com

I have a DTS package that is set up (as a recurring Job Schedule) to run every hour. I would like to "skip" the job during a small time frame, and...

Kirk

02-27-2008 09:16 AM
Kirk

hi, we are trying to build SSIS package that transfers records from SQL 2005 table to excel sheet. the table contains nvarchar fields with long...

Rafi

02-27-2008 03:41 AM
Rafi

Hi, In my source (text file connection) there is a date field but the date is stored yyyymmdd (20080226) I need to convert this into a real date...

Patrick Hill

02-26-2008 10:21 PM
Knowledgy

Hi, I have a DTS pack that polls for a particular file, and if the file exists continues to run. If the file isn't there, it simply sets...

PGP

02-26-2008 08:22 PM
PGP

Integrating AD Groups to manage SSIS packages, is this possible, we want to have several groups that have different levels of access for developers,...

dba

02-26-2008 03:56 PM
dba

When I transfer data from one server to local server to remore server I got intermittent failures with DTS packages eRROR AT DESTINATION FOR rOW...

NEWS

02-26-2008 05:55 AM
NEWS

Hello, I am new to DTS world , I know how to run the package stored in SQL server but not aware of how the script can be run that is generated from...

ankur.nagdeve@gmail.com

02-26-2008 04:33 AM
ankur.nagdeve@gmail.com

I set up an SQL stored procedure which executes a DTS package. The SQL stored procedure reads a table with 75 branch #s. It passes a...

rmcompute

02-25-2008 09:42 PM
rmcompute

Hello all, Some of our clients send us update data periodically (usually every 3 months, but sometimes every 6 months or every year), so I design...

Conan Kelly

02-25-2008 04:56 PM
Conan Kelly

The Management Studio behave quite strange - the message i frequently have making different tasks is something that ends...

pindev

02-25-2008 03:11 PM
pindev

Hi- I have a default SS 2000 database with multiple scheduled DTS packages that run daily. I need to install a SS 2005 instance on the same server...

wiseteufel via SQLMonster.com

02-25-2008 01:05 PM
wiseteufel via SQLMonster.com

Hi- I have a default SS 2000 database with multiple scheduled DTS packages that run daily. I need to install a SS 2005 instance on the same server...

wiseteufel via SQLMonster.com

02-25-2008 01:04 PM
wiseteufel via SQLMonster.com

Hi, I am somewhat new to using DTS packages. Generally, I want to know if it is possible to not only import data into an existing Excel...

psrd66

02-25-2008 12:55 PM
psrd66

Since getting an MSDN subscription a few months ago, I have made about 6 posts. I received one response from a Microsoft person telling me that...

walter1234

02-24-2008 06:29 PM
Dave Patrick

RE: XML Data source .. Expression? Variable? Connection? Error: unable to read the XML data. I want my XML Data source to be an expression as i will...

wildman@noclient.net

02-23-2008 01:25 PM
wildman@noclient.net