I created a package configuration and used the package installation wizard to deploy a package to my dev server. The package pulls data from Oracles...

mystical potato

04-03-2009 09:11 AM
frank lee

I am using DTSWizard Export in our SQL Server Standard 2005 to export data from six tables to another SQL Server Express 2005 outside our network. I...

Frank

04-02-2009 04:51 PM
Frank

Hi, I'm executing a package from VBA using WScript.Shell.Run. I'd like to know how to cancel the package if I've already started it. Thx in...

saul_margolis@hotmail.com

04-02-2009 06:55 AM
saul_margolis@hotmail.com

Hello all, Existing Server Environment: Windows Server 2003 32 bit SQL Server 2000 New Server Environment: Windows Server 2008 64 bit Web...

jcb

04-02-2009 05:56 AM
jcb

I need to create a remote connection to another server to get access to tables and views. Can someone help me by providing the steps to setup in...

Jay via SQLMonster.com

04-01-2009 03:33 PM
Jay via SQLMonster.com

I need to create a remote connection to another server to get access to tables and views. Can someone help me by providing the steps to setup in...

Jay via SQLMonster.com

04-01-2009 03:32 PM
Jay via SQLMonster.com

Hi, I am trying to import a CSV file from a HTTP location. Is there any sample or documentation that explains how to do that? Thank you,

Max2006

04-01-2009 11:14 AM
Max2006

Hi, I am trying to find the right usage for “HTTP Connection Manager”. After some research I found the following samples: SSIS: Downloading a...

Max2006

04-01-2009 04:57 AM
Charles Wang [MSFT]

Hi, I have a url to an html table that contains a table. The HTML table structure is well defined. I need to grab data from the html table...

Max2006

04-01-2009 04:54 AM
Charles Wang [MSFT]

I was wondering if anyone knew how to resolve a certain problem I have. When I set up a DTS package, and do straight column-copy transformations, I...

NewDBAGuy

03-30-2009 11:38 PM
amy

In an SSIS package, I have a For Loop Container task with the EvalExpression set to true (so that it runs forever). If any tasks inside the For...

CraigHB

03-30-2009 12:32 PM
CraigHB

SQL2k sp4a / Windows 2003 I have a DTS package that imports text files from a directory. These files are ftp'd to us by a customer, so we never...

Andre

03-30-2009 12:17 PM
Andre

Hi All, I’m working with a rather unpredictable client at present. They provide us CSV files from a Linux based platform, which sometimes conform...

John Rossitter

03-27-2009 09:14 PM
Atul Thakor

I'm trying to determine when my sql2000 DTS packages are scheduled. How can I turn the DTSRUN /!@#@#$blahblahblah into the package name? Someone...

SQLdba

03-26-2009 01:28 PM
Russell Fields

Hi All, After installing of SP3 for SQL 2005 "Stored Packages"/"File System" and "MSDB" entries/subfolders/templates (where you can import...

Eugen

03-26-2009 06:23 AM
Eugen

Hi i want to get all rows from 1 table (Dim Promotion) that has Start Date and End Date and retrive all rows from Dim Time that answer the condtion...

eyalso@gmail.com

03-25-2009 07:52 AM
Todd C

I am trying to build the below sql expression to store it in a variable but it is giving me cast error for the operands. "select * from OrclTbl...

Usha

03-24-2009 12:48 PM
Todd C

I have a requirement to import the data from an excel spreadsheet onto a sql table. I'd like to be able to delete the source after successfully...

Carlos

03-23-2009 04:17 PM
Carlos

Hi I am trying to copy DTS packages between servers using vbscript, and absolutely want to keep the text annotations, design, etc.... as documented...

Leo Matter

03-21-2009 05:29 AM
vinod agole

I am getting a strange error after some XP build updates on my machine. I have a MS Access application (Front End) and back end is SQL Server...

jimgeo

03-20-2009 10:10 PM
jimgeo

Hello, I have an SSIS package that has been running successfully for quite some time. It is a very simple package: prompts user for a filename...

cheri Reed

03-18-2009 12:27 PM
cheri Reed

I'm wondering if the construct of a DTO object from design patterns can also be applied to SSIS as well. I would like to pass a complex .Net object...

Alvin

03-17-2009 01:31 PM
Alvin

Hi, I have a customer for which I have to use an ODBC Driver for Accpac dataBase I have to import some data from one file and Import that data into...

GC

03-17-2009 01:28 PM
GC

I have a SSIS 2005 package with a dataflow that does a merge join between the source table on another server and the staging table to determine which...

tj_dc

03-17-2009 02:49 AM
tj_dc

I am using Data Flow task for the below query. I have a source connection as MyOrclConn which uses Oracle Provider for OLEDB. I am trying to write a...

Usha

03-16-2009 06:40 PM
Usha

Hi! I'm trying to execute a dts in sql server 2000, in my dts I'm openning a text file with Scripting.FileSystemObject, this is my function...

Ruben

03-16-2009 03:44 PM
Ruben

Hi All, Our organisation has a SQL Server 2000 SP4 which has a database of 35GB with around 75 DTS packages. Now we wanted to upgrade that one and...

Srikanth via SQLMonster.com

03-16-2009 09:42 AM
Alen Teplitsky

Anyone have a clue. Intel Xeon 2.8GHz, 3.75GB RAM, 1TB HD SQL Server 9.00.4035.00 SP3 Standard Edition ] Error: SSIS Error Code DTS_E_OLEDBERROR. ...

Greg

03-13-2009 11:30 AM
Greg

Hi, I try to import data fron an excel file into a table in Sql 2005 Database I create an SSIS and export the SSIS on the server When I execute the...

GC

03-12-2009 02:21 PM
Todd C

I have 31 folders and each has 288 .txt files. I need to import them into SQL Server 2005. I have been using Access, but the process is slow. ...

John Renkar

03-12-2009 09:49 AM
John Renkar

HELP ! I am trying to get several developer workstations working with the follow setup... Windows XP (32-bit) SP2 SQL 2005 Developer - SP3 MS OLE...

Simon P

03-09-2009 05:20 PM
Simon P

hi, i am new to sql server, ............. i have 2 databases,i have to insert data from the old database to new database........ for example i have...

shravani

03-09-2009 03:38 PM
tbradshaw via SQLMonster.com

Hi all, I wanted to let you know about our training seminar on predictive analytics - coming April, May, Oct, and Nov in San Jose, NYC, Stockholm,...

Elise Johnson

03-07-2009 01:59 PM
Elise Johnson

Hi, I have a situation where a row added to a table in the application of one SQL Server 2000 database needs to have this data replicated...

Chakravarthy

03-07-2009 04:27 AM
tbradshaw via SQLMonster.com

I am modifying a DTS package that was built a few years back and trying to add a simple transform using ActiveX. The ActiveX code that I have...

Joe

03-04-2009 11:15 AM
Joe

Hi, I have a job that run a SSIS package When I run the SSIS package manually it works fine and I am login as the user da on the computer and also...

GC

03-03-2009 08:56 AM
Todd C

hi, i have a DTS with error´s and i dont be how to the problem. The message error is: "Error: "The Task "Message Stop" Cannot run on this edition...

ronhi

03-02-2009 02:34 PM
tbradshaw via SQLMonster.com

Hi, I create a package SSIS da is my domaine Administrator In Sql Server Managment Studio I execute the package and everything work find if i am...

GC

02-27-2009 11:44 AM
Todd C

Hello all, I've been asked to write a package that looks for a file in a certain directory- if the file is found, I need to treat it; if not I need...

Nieve

02-27-2009 08:51 AM
Nieve

Hello, I have built a master SSIS package that is configured to run numerous child packages. Based on a parameter that is passed to the master...

hfdev

02-26-2009 04:26 PM
hfdev

Hi, I have an SSIS Package imported into Integration Services Maintenance Plans folder. When I run the SSIS Package from Integration Services it...

C

02-26-2009 02:09 PM
hfdev

Hello guys, I have installed SQL server 2005 enterprise (evaluation). I developed some SSIS packages and wanted to run from a windows forms...

Ronaf

02-24-2009 09:01 AM
Todd C

Hi, I have just started working with SSIS and to say I find it complicated is an understatemnet but from what I have read a lot of other people are...

Phil

02-24-2009 06:39 AM
prakash gupta

Hi all, I have installed SQL server 2005 enterprise edition (evaluation), and I developed some SSIS packages with I wanted to run from a windows...

Ronaf

02-23-2009 01:17 PM
Ronaf

Good morning, I've got a DTS package that includes a single Data Driven Query whose purpose is to update address records in a SQL Server...

FiMac

02-23-2009 09:52 AM
FiMac

SQL2k sp4 Is it possible to determine when a DTS package was last run? We have a lot of packages, and we're sure some are no longer needed. But we...

Andre

02-20-2009 01:32 PM
Andre

Hello! I have following setup: SQL Server 2005 64-bit, 2-node cluster. Business Intelligence studio installed on both nodes. All SSIS packages are...

Igor Marchenko

02-19-2009 07:38 PM
Igor Marchenko

Hello, I have created a master SSIS package that is responsible for running numerous child packages based on configuration data stored in a SQL...

hfdev

02-19-2009 01:46 PM
hfdev

Hi! The workflow of my DTS is somewhat like this: --------------------------- An ExecuteSQLTask ---> An...

dashllh

02-18-2009 04:55 PM
tbradshaw via SQLMonster.com

Hi, For DB Upgradation, I took the job script from SQL 2000 and executed in SQL server 2005. One of my job fails and getting the below error. "...

anithagovindarajalu@gmail.com

02-18-2009 09:35 AM
tbradshaw via SQLMonster.com