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 11: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 09: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 05: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 05: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 05: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 10: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 05: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 01: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 04: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 02: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 01: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 11: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 08: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 06: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 05: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 04: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 07: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 10: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 04: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 04: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 12:23 PM
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 09: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 09: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 12:53 PM
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 01: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 01: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 11: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 04: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 10: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 03: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 01: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 12:03 PM
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 09: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 08: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 04:57 PM
Falconer

I am using SSIS to import a CSV file into a SQL table. How do I strip the double quote marks surrounding the strings in the CSV file? This seems...

jmelkerson

03-26-2008 10:34 AM
jhofmeyr@googlemail.com

Hi, What rights does a user need to connect to the server (2005) and view/run packages from their client PC? Where are they configured? Thanks

£Jim

03-26-2008 09:08 AM
£Jim

Hi, Please tell me whether its possible to open dts package using activeX scripts(written in VB,js etc.) or by some other means but not thru...

manu

03-25-2008 01:31 PM
nite_eagle@hotmail.com

I have recently upgraded to SQL 2005 from 2000. I imported my existing tables and DTS/Stored procedures. When I attempt to run an import on new...

tgraessle@maine.rr.com

03-25-2008 09:26 AM
tgraessle@maine.rr.com

I've created a DTS package in SQL Server 2000 Enterprise Manager to export the data in a table that has datetime fields using Task->Export Data. ...

Andy

03-20-2008 11:01 AM
Andy

I have a simple DTS package that I need to insert records into an Excel file. I want to start with a blank worksheet every time. However, it is...

Rubens

03-20-2008 09:18 AM
Rubens

Ok I am trying to create a flat file connection manager using comma delimited and " as the text qualifier. The file imports into excel properly,...

mike.mcneer@gmail.com

03-20-2008 04:55 AM
jhofmeyr@googlemail.com

i am new to DTS. i want to clone a access database based on the value of a field that comes from the source table. Can some one provide me some Tips...

chris2383

03-20-2008 04:29 AM
chris2383

I'm fairly new to using SSIS, but I have learned how to download the contents of a custom database to a local development server (both with...

jrl

03-19-2008 10:57 PM
jrl

I have migrated the DTS packages to SQL server 2005(standard) from SQL2000 using the migration wizard. The packages are under integrarion...

art

03-18-2008 09:07 AM
art

Hi! I have a dts package that sends data to about 30 different external databases. This has ran just fine, but suddenly I get a problem...

jostein.solstad@gmail.com

03-18-2008 03:32 AM
jostein.solstad@gmail.com

Fri Feb 29 16:46:39 America/Los_Angeles 2008 Hi, I'd like to know how I can convert the above string to a date. Thanks in advance. Pingx

Pingx

03-16-2008 10:41 PM
lonnye

Hi, I have a DTS package. I need to debug it, ANy ideas how? Thanks,

Mecn

03-14-2008 10:31 AM
Mecn

Hi all, I have randomly this error on an SQL server 2005, when executing a DTS package, basically this package extracts data from a DB to another DB...

Greg

03-14-2008 07:17 AM
Greg

I just ran across an interesting problem, that makes no sense. I built an SSIS package that updates a column, using an transformation script. Testing...

awakin

03-14-2008 06:19 AM
jhofmeyr@googlemail.com