Hi, I created a DTS package that migrates the data from a table on one server to another. (The DTS package contains a Connection1, the...

research_stuff

06-10-2008 06:16 AM
matteus

Hi, I am testing some import validations on dry run data that has been deliberately seeded with incorrect values to test the systems. The format...

billyfix

06-10-2008 05:58 AM
matteus

We have a web app that maintains data in a SQL server database. We need to run a monthly job that processes this data (complex logic) and then...

mscertified

06-10-2008 05:17 AM
matteus

I'm trying to bring over a text file into a SQL table, and the data has got what appears to be low values in a field on it. It's causing a problem...

Blasting Cap

06-09-2008 10:21 PM
JussiJ

I continue to get this message though there are no duplicate keys in the table/s I am transferring into the new table I am creating using DTS....

Jay via SQLMonster.com

06-06-2008 12:33 PM
Jay via SQLMonster.com

I just installed the AccessEngine.exe for dataconnection and as a result when i start the Studio Manager I get the "trial period is over" This is on...

mrrcomp

06-06-2008 05:40 AM
mrrcomp

I have a simple SSIS package that runs a sql query that exports to a flat file, then emails this flat file to an address. I built the package in...

Carl Henthorn

06-06-2008 03:10 AM
Antoon

I am trying to build a DTS package that exports data from SQL Server to a csv file. I am trying to use the Dynamic Properties Task to change...

Drew

06-05-2008 01:27 PM
Drew

Thanks in advance. I have just read a post on www.sqldts.com titled "How can I change the filename for a text file connection?". The example...

Mark

06-05-2008 12:03 PM
jhofmeyr@googlemail.com

I need help converting some existing ActiveX script to use either the Foreach or For loop task. I have a sproc that returns one row containing a...

=?Utf-8?B?Um1vb3Jl?=

06-05-2008 11:58 AM
jhofmeyr@googlemail.com

I need to do a partial fuzzy lookup in SSIS. This means that some columns need to match exactly, while others are fuzzy matched. Picture an...

dtbascent

06-04-2008 04:54 PM
dtbascent

I have 5 folders each having 2-3 text files. I have two DTS(SQL 2000) packages one which is having around 12 tasks which is getting processed based...

Nitin

06-03-2008 07:22 PM
Ed Enstrom

I set up a DTS package using an Oracle connection and a SQL Server connection. For the Oracle connection, I used the Microsoft OLE DB Provider for...

rmcompute

06-03-2008 03:40 PM
rmcompute

Hi All I have a DTS package which uses an "Execute Process Task" to run a BAT file which is on the server's C:\. What happens is I setup the task...

Bouce

06-03-2008 02:34 PM
PittsburghCodeMonkey

I am using an already developed DTS package that I created for a new database. Everything looks the same here. Except now I am getting this...

PSULionRP

06-03-2008 12:31 PM
jhofmeyr@googlemail.com

Hi, I've noticed that SSIS saves paths to configuration files as absolute paths. It does do that with the Execute Package task as well. This way...

Axel Dahmen

06-03-2008 08:08 AM
jhofmeyr@googlemail.com

Hi, I can't possibly find any information of actually how to use a data source object or a data source view object in a package. After I've added a...

Axel Dahmen

06-03-2008 08:02 AM
jhofmeyr@googlemail.com

Hi, I m facing the limitation of string variable (only max 4000 characters) to store my query that need > 4000+ characters. Any advice for...

Daniel

06-02-2008 10:42 AM
jhofmeyr@googlemail.com

Hi experts, I created one variable in SSIS package. The variable data type is Object and save lists of members name (string). now, another query...

Daniel

05-30-2008 02:02 PM
Daniel

i'm working on building a generic error handling routine for a package. I've googled my way to the point where i can iterate thru the input...

kent.eilers@res-direct.com

05-30-2008 01:39 PM
kent.eilers@res-direct.com

Trying in SSIS to do something which technically should be rather simple. 1) create a for each loop that contains as a variable the name of an...

thejamie

05-30-2008 04:46 AM
jhofmeyr@googlemail.com

Hello all. I am running a MSSQL2000 standard server. I want to export tables to a flat text file using DTS. The problem I have is that most french...

PComtois

05-29-2008 02:21 PM
PComtois

I have two SSIS packages that import from the same flat file into the same SQL 2005 table. I have one flat file connection (to a pipe delimited...

Ulysses

05-28-2008 05:01 AM
Charles Wang [MSFT]

Hope I'm in the right Newsgroup for this question. I'm sure someone will put me right if I'm not :) I'm trying to build a SQL Server 2005 SSIS...

YaHozna

05-27-2008 03:38 PM
alex

Hi, I have a couples of DTS jobs set up for data import from Oracle to SQL server. They all appear to run fine when triggered manually....

Walty

05-27-2008 01:18 PM
Caoimhgh

Hello - I have an SSIS package that runs perfectly in BIDS but when I try to schedule it as a job, it fails. Can anyone give me a place to start to...

Sheldon

05-27-2008 10:07 AM
Sheldon

I created a SSIS package that imports an Excel file that has columns with > 255 chars into a SQL table. I am getting error "Text was truncated or one...

=?Utf-8?B?Uy5LdW1hcg==?=

05-27-2008 09:00 AM
jhofmeyr@googlemail.com

Hi I have a local development machine running on Windows Vista SP 1. My package ( in SSIS 2005 ) conncets to a local DB ( in dBase ) and derives a...

Webs

05-27-2008 08:58 AM
jhofmeyr@googlemail.com

I have a csv file with first 2 lines having less columns than all the rest of the lines. The first line has 6 columns, the second line has 4...

Aki Noriko

05-27-2008 08:57 AM
jhofmeyr@googlemail.com

Hello. I have an SSIS package, which runs fine in Visual Studio. I create and deploy the package to the SQL Server set all the connection...

KDM

05-27-2008 08:53 AM
jhofmeyr@googlemail.com

Hi, Any idea on casting the Object type to String type in ScriptTask's Design Script area. Thank you in advance. Daniel.

Daniel

05-22-2008 07:15 PM
Matthew Roche

hello all, i know ssis allows to insert from a csv file into sqlserver (2005) tables but is it possible to either update and/or delete records with...

lark

05-22-2008 07:14 PM
Matthew Roche

I have a DTS package that copies contents from an Excel spreadsheet. In the spreadsheet all columns are formatted as "text." One column consists of...

WhiskeyRomeo

05-22-2008 10:40 AM
WhiskeyRomeo

Hi guys, I'm using Firebird 2.0 database, some of the table fields are using charset UNICODE_FSS because it consists of chinese characters. I want...

Halim S

05-22-2008 05:46 AM
Halim S

I have an OLE DB Source control that I am using to collect data from a stored procedure. THhe stored procedure first assembles the data in a #Temp...

sorourke1@hotmail.com

05-21-2008 04:44 AM
jhofmeyr@googlemail.com

Greetings, We have a new SQL 2005 x64 sever that runs an export which uses DTS (from 2000). One of the steps in an ActiveX script which is failing...

Tony Skalski

05-20-2008 06:02 PM
Tony Skalski

I'm running SQL 2005 sp2 on a Windows 2003 active/passive cluster. We have some legacy DTS packages that are being called directly from a scheduled...

Jason

05-20-2008 06:26 AM
Charles Wang [MSFT]

I am able to FTP to PC based servers, but other FTP servers do not work, giving this message: Error at FTP Task : Remote path doesn't start with...

Stu

05-19-2008 12:36 PM
Stu

To backup my database, I transfer it first with DTS from the operational server to my in-house server. This procedure has worked for...

Roger Withnell

05-19-2008 09:15 AM
Roger Withnell

Hi, I've created my own custom data flow transformation task (using C#) that will parse a name and output the various name parts. In...

Marshall

05-16-2008 12:41 PM
Marshall

Hi, I execute a SSIS package on a SQL Server Standard 2005 (64 bits) machine. Most of the time, it succeeds without any problem. But sometimes, I...

stijn.calders@gmail.com

05-15-2008 09:51 AM
stijn.calders@gmail.com

I have two SSIS packages that import from the same flat file into the same SQL 2005 table. Both packages use the same Connection Managers. The...

Ulysses

05-13-2008 04:51 PM
Ulysses

Recently my version of SQL Server 2005 has stopped making the truncate statements when I use the DTS Import/Export wizard. If I save the DTS package...

Dwight

05-13-2008 04:05 PM
Dwight

Hello - I am new to SSIS and quite overwhelmed at the complexity of the product. I have six text files to be imported into six Sql Server tables...

Sheldon

05-13-2008 12:44 PM
Sheldon

Does anyone know of a good book on DTS and ActiveX programming? I have the following books, Professional SQL Server 2000 Programming by Robert Vieira...

Terry

05-13-2008 11:04 AM
Terry

I am working on extracting data from one table to a text file. 1. I need to count the number of rows I get after the extraction (not during) 2. ...

Roosevelt

05-11-2008 04:00 PM
Roosevelt

I have a legncy DTS package when upgrading to SQL 2005, I used "SQL Business Intelligence Development Studio" to create a project, the control flow...

Lisa2004

05-08-2008 09:41 AM
Lisa2004

I have a DTS package in SQL Server 2000 which brings together data from different sources, including from an Analysis Services cube, and compares...

Rachel

05-08-2008 06:42 AM
Rachel

I have two DTS local packages that have been running fine as scheduled jobs for years. Suddenly one of them is creating an empty output file while...

Art Cabot

05-07-2008 12:30 PM
jhofmeyr@googlemail.com

Hi Hugo, I think the following action plan may help you out on this problem.Please understand that this is what I think might help the situation and...

Subhen Kar [MSFT]

05-06-2008 04:56 PM
Subhen Kar [MSFT]