I would like to run the SSIS package located on the 2005 sql server from my workstation on demand. The workstations do not have sql loaded. Is there...

Jack

04-18-2008 01:16 AM
Jack

Folks, We are now just embarking on our migration to 2005 from 2000. I have a server with 400 DTS pkgs. What happens to them after an in-place...

Scott H.

04-17-2008 09:37 PM
Scott H.

I am trying to take data from a table in one database and add it to an existing table in another database. The both use the same primary key. I set...

Sean Bolster

04-17-2008 04:35 PM
Sean Bolster

In my SSIS package, there is Execute DTS 2000 Task, the DTS packages called from Execute DTS 2000 Task have GLOBAL variables (Shown in Inner...

Vikranth

04-17-2008 02:51 AM
Vikranth

I'm looking for the actual files and not how to get to it in SQL 2000. I'm tyring to convert them to import them in SQL 2005 and it needs to know...

pvong

04-16-2008 10:58 AM
Bill_Orova

Hi gurus this is a problem that has just risen on a dts package My boss updated a dts package in sql server 2000 I created and he addded a custom...

Bill Orova

04-16-2008 10:14 AM
Bill Orova

I am having problems in transformation task. I am retrieving oracle data and loading into sql server table. Oracle retrieval works fine, at the time...

Ramu

04-16-2008 07:15 AM
jhofmeyr@googlemail.com

Hi all, I am kind of new in this topic and get stuck for awhile. I migrated DTS packages from SQL Server 2000 (Windows 2000) to be SSIS packages on...

Tanya

04-16-2008 01:42 AM
Tanya

I am using SQL Server 2000 DTS package. I am trying to re-define transformations between the source and destination tables while there are Temporary...

Justin Doh

04-15-2008 05:08 PM
Justin Doh

Hello, At my organization, a programmer who is no longer here created some DTS packages on our SQL Server 2000 installation. We need to update the...

Michael

04-14-2008 04:51 PM
Michael

Dear All i have table with 50 columns in which data is loaded from text files. now from recent up-gradation the one column has been added in the...

Jami

04-14-2008 04:14 AM
Jami

Can anyone refer me to official Microsoft documentation on how to dereference SSIS variables, and in what contexts they may be invoked? For example,...

Jay Way

04-11-2008 01:24 PM
Jay Way

Hello, I've been battling this issue since morning. Some Internet forums point out that it's some sort of a MS bug, but I couldn't find a definative...

sergei.sheinin@ru.nestle.com

04-11-2008 03:07 AM
sergei.sheinin@ru.nestle.com

Hi. I am using SQL 2000 and DTS package to transfer data between two databases. In my DTS package, I need to create a enumeration task with...

Drum

04-10-2008 08:16 PM
Drum

Hello, I have a SQL 2000 dts package with a transform data task that copies around 15million rows of data from a unix server. The db where the rows...

Mark

04-10-2008 07:09 PM
Mark

BIDS newbie pains. I created a staging database and a final dimensional store database in my local SS2K server. In BIDS I created two data sources,...

Jay Way

04-10-2008 10:02 AM
Jay Way

I have got a problem with SSIS logging. I set up logging for my package and its tasks separately so I can get details of the progress and errors. I...

York

04-10-2008 08:44 AM
York

Hi all, I have an dtsx (SSIS) for "clone" manually Sql server database to another. How I copy all stats from one database to another ? I have...

Alhambra Eidos Kiquenet

04-10-2008 04:31 AM
Alhambra Eidos Kiquenet

Hi, We have a new installation : SBS 2003, SQL 2005. this machine replaces a SQL 2000 installed machine. The problem we've got is that we need to...

Ian Oldbury

04-09-2008 04:37 PM
Izhar R Ab Rani

All, I would like to document all SQL 2000 DTS's...Is there software to do that? Or maybe I just use Word document… I appreciated your feed back.

hngo01

04-09-2008 04:07 PM
hngo01

Hi I have a about 200 Legacy DTS Packages in SQL 2005, I have migrated these packages to SSIS, Is it possible to delete all the Legacy DTS Packages...

Que

04-09-2008 09:33 AM
Que

I am transforming, INSERTing rows into a SQL Server Table from an Excel spreadsheet. I have two columns on my SQL Serve Table that I want to...

PSULionRP

04-08-2008 04:01 PM
PSULionRP

Hi, I want ro run a SSIS package on ASP NET but don't work. The datasorce are in other machine. I'm using Visual Fox database. I have the same...

Francisco

04-08-2008 12:16 PM
Francisco

Hello I have an ActiveX script which loops round a recordset and for every record calls another process. See...

allan.martin@gmail.com

04-08-2008 03:45 AM
allan.martin@gmail.com

Hello, we need to import data from AS400 to MS SQL 2000 via ODBC driver (iSeries ODBC by IBM). The trouble is with date format and using functions...

Tomas Cerny

04-07-2008 01:06 PM
Rick Brandt

I have a DTS package failing with the error log listed below. I've never seen this before so I am not sure where to start with this one. Any...

Rubens

04-07-2008 12:45 PM
Rubens

Hi, I'm getting following error while running SSIS package: Error: An error occurred while assigning a value to variable "variable_name":...

gojowy@gmail.com

04-07-2008 10:17 AM
gojowy@gmail.com

Hi , We are using SSIS 2005 and have a Flat File Connection in a package. The connection is pointing to a Mapped network drive (let...

Truc H.

04-07-2008 07:10 AM
jhofmeyr@googlemail.com

help,a text how to sql table code ? i have a text as follow, line with ¡°|¡±and...

agiler

04-05-2008 05:27 PM
agiler

Hi all, I am very new to sql server 2005. So please bear with me. I created a couple ssis package through import and export wizard for our current...

c676228

04-04-2008 04:26 AM
Charles Wang[MSFT]

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

Elise Johnson

04-04-2008 03:47 AM
Elise Johnson

I seem to have an oddity in importing an Excel file via DTS using SQL Server 2000. All of the information imports just fine (including 3 date...

Sean

04-03-2008 06:22 PM
Query Builder

I run several DTS packages each day, I would like to convert from an e-mail based export system where I save the exported file locally to the...

mts

04-03-2008 09:47 AM
Truc H.

Hi, i'm tried use parameters in a sql statement but don't work. I don't know what happen, anyone help me please. information DTS:

Francisco

04-03-2008 03:32 AM
jhofmeyr@googlemail.com

I need to load MSDE on a client computer to support an access databases that kicks off a DTS package. Since SQL Server 2005 does not directly...

Chris

04-02-2008 03:17 PM
Chris

Hi, We just migrated from SQL 2000 to 2005. We moved over the dts packages but they don't seem to work anymore. Do I need to do some editing to...

HappyOne

04-02-2008 11:23 AM
HappyOne

First, sorry about the cross post but I desperately need an answer. I have a VB.Net application which uses a SQLServer DTS package which I am trying...

Andrew Baker

04-01-2008 08:37 AM
Russell Fields

Hi, We get an error running a SSIS package which calls another package. Both packages execute Ok independently. Error: "The LoadFromSQLServer method...

Matt Frend

03-31-2008 08:52 PM
Matt Frend

It is possible to calculate the rough size of the database based: (the size of each row + size of each index row) * no of rows Maximum row size is...

ciaran.hudson@gmail.com

03-31-2008 11:53 AM
jhofmeyr@googlemail.com

Hi all, I am trying to manually import data manually from a txt file to a table in sql 2005 before I have a ssis package, is it possible like I did...

c676228

03-31-2008 12:16 AM
Charles Wang[MSFT]

Hi all, Our origianl sql server 2000 database was created with COLLATE Chinese_Taiwan_Stroke_CI_AS by someone, though we never store any...

c676228

03-31-2008 12:11 AM
Charles Wang[MSFT]

I'm having a difficult time trying to set up a Data Flow Task that will export data into a MYSQL database. After I create the OLD DB Destination...

SpankyATL

03-30-2008 10:46 AM
doug spencer

I need to check whithin an exists DTS source fild, i have the next code VB, but it made error message is " No match the types : 'exists' " Any help...

Fernando

03-28-2008 03:31 AM
jhofmeyr@googlemail.com

hi,I created a SISS package using import/export wizard. when I run the import manually, it was sucessful, but when I ran the package, I got error,...

Pingx

03-27-2008 09:08 PM
Pingx

Hi Sqlserver expert I created a package using import/export wizard in management studio. how can I run the package in a T-sql script? Please...

Pingx

03-27-2008 02:57 PM
Pingx

Hi Sql Server experts, in SSIS designer, how do I open/edit the package I saved using the export/import wizard in management studio? Please help....

Pingx

03-27-2008 12:17 PM
Pingx

I created a package using the import wizard in management studio. How do I modify/edit it? I read that the DTS designer need to do the job, but how...

Pingx

03-27-2008 11:03 AM
Pingx

I have been assigned to get an EDI written for enrollment of health insurance from my HR system to a major insurance carrier; in fact, I need to...

greenmtnsun

03-27-2008 08:57 AM
jeff

Does anyone have an example of prompting the user for a beginning and ending date when running a DTS package that doesn't involve input boxes?...

Matt Williamson

03-27-2008 07:21 AM
Matt Williamson

Hi friends, Is it possible to reference properties of other tasks in a package from a script task ? Any help will be much appreciated. Thanks Alex

Falconer

03-26-2008 03:57 PM
Falconer