Hi, I encounter a problem when doing some data transition work from excel to sql server, there is a column in the excel sheet in which most contents...

fairyvoice

06-17-2009 08:29 AM
Todd C

I'm really confused about the functionality of SQL (and files) configurations in SSIS packages. Unless everything is configured exactly perfectly,...

dwaine

06-17-2009 08:20 AM
Todd C

I have a text file to import to sql server 2005. The fields were separated by ~ when I use the import from management studio, I specified the...

Pingx

06-16-2009 05:47 PM
Pingx

it seems that when a configuration is defined at design time as integrated security there is no simple way to change that setting using configs at...

dwaine

06-16-2009 03:14 AM
Charles Wang [MSFT]

Sorry about that, this got a subject that was mixed with another post. The correct subject appears here.

dwaine

06-15-2009 07:49 PM
dwaine

HI, I have a problem while transferring XML file data into SQL DATABASE 2005 using SSIS package. 1. My XML file having multiple tags (<parent...

vinnakanna

06-12-2009 01:27 AM
vinnakanna

hi i'm trying to get sql server integration services installed, so i can use sql server 2005's version of data transformation services. i have sql...

sean_walsh

06-11-2009 12:27 PM
Todd C

The Case Sesetivity server setting may be the issue, but I think that is geared more toward data comparison than object names. Try using a SELECT...

Todd C

06-11-2009 12:24 PM
Todd C

On 4 Giu, 16:51, TheEvilDonut <TheEvilDo... (AT) discussions (DOT) microsoft.com> wrote: Hi, i think you're misunderstanding DTS variables with...

matteog

06-11-2009 09:49 AM
matteog

Hi all, I am new to SSIS, my source system is Mainframe DB2 and target is SQL Server2005. How to transform data from Mainframe DB2 to Sql server? Can...

Sudha

06-10-2009 08:46 AM
Todd C

Hi all, About a year ago when I upgrade our server from sql 2000 to 2005. I created a coupld ssis packages via SQL Server 2005 Import and Export...

c676228

05-27-2009 06:22 AM
Mark Han[MSFT]

Hello, I need to import some tables to SQL Compact Edition file (.sdf). I've created new SSIS package but when I'm trying to create Connection...

eXavier

05-22-2009 05:21 AM
eXavier

Our client is a world class experienced team of Western and Asian professionals, industry leading technical capability and excellent provider with...

Admin IndoGawe

05-22-2009 03:16 AM
Admin IndoGawe

Honeywell HC-14 Replacement Filter for Holmes Cool Moisture Humidifier Price:$9.99 Image: http://bestdeallocator.info/image.php?id=B000AO1G72 Best...

Andersen@lakisha.com

05-20-2009 11:50 PM
Andersen@lakisha.com

DC07/14 Dyson Vacuum Cleaner Replacement Filter Price:$1.99 Image: http://bestdeallocator.info/image.php?id=B0009H7D3Q Best deal:...

Anagnos@valeria.com

05-20-2009 11:48 PM
Anagnos@valeria.com

K2 1/4 Karat Ski Poles - Girls - 90cm Price:$23.99 Image: http://bestdeallocator.info/image.php?id=B001OHY8KG Best deal:...

Allwardt@milton.com

05-20-2009 11:45 PM
Allwardt@milton.com

Braywick Headboard - Light Oak (Full/Queen) Price:$299.99 Image: http://bestdeallocator.info/image.php?id=B000WNJ8XK Best deal:...

Alawdi@gloria.com

05-20-2009 11:14 PM
Alawdi@gloria.com

Lowepro Cirrus TLZ 25 Holster Style Case For Digital SLR &amp; Telephoto Zoom Lens (Black) Price:$43.99 Image:...

Asley@louise.com

05-20-2009 09:11 PM
Asley@louise.com

Source is a datareader, destination is a OLEDB table, the connection manager is ODBC type. It was running fine on all the 2005 servers previously,...

vicky

05-20-2009 07:18 AM
eprobst

Hi sql server expert, I created an export package with a customized select query. but once the package was created, I was not able to see the query...

Pingx

05-19-2009 03:23 PM
Pingx

TechPower Premium Battery for Casio Exilim Zoom EX-Z850 EX-Z1000 EX-Z1000 EX-Z1050 Digital Camera Price:$3.03 Image:...

Arehano@zelda.com

05-19-2009 07:59 AM
Arehano@zelda.com

Is there a way to call a web service via a trigger in SQL Server, passing certain info (like name and address) to it? If so, is there an article...

Gerhard

05-18-2009 04:19 AM
Mark Han[MSFT]

I need to control the column mappings inside a dtsx package without using BIDS (that I cannot to install). Is it possible?

Pasquale

05-16-2009 06:33 PM
Pasquale

Hello, I have many text files on a folder with the same metadata and I need to import each one into a separate table. 1. Is it possible to do this...

Alain

05-15-2009 06:16 PM
Alain

Hi, I don't think it's possible but I just want to make sure. i have a bunch of dts packags files (.dts file ) in a directory , it's sql 2000...

Kevin

05-13-2009 05:38 PM
Kevin

Hello! I've got a problem with a ForEach FileEnumerator in SSIS/SQL2005. To import some CSV-files I do a loop in a specified directory. Everythings...

Dominik

05-13-2009 07:53 AM
Todd C

I have imported a large number of SQL 2000 DTS packages from SQL 2000 to SQL 2005. Many of these packages have a VB script step that renames a file....

Zack G

05-12-2009 05:28 PM
Zack G

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

Elise Johnson

05-10-2009 02:29 AM
Elise Johnson

This is on SQL 2005, btw, say it's on an instance that is in full recovery mode. Check constraints on, table lock off. Thanks. Josh

JRStern

05-07-2009 05:54 PM
JRStern

Does a DTS transformation (importing from another database) log if "fast load" option is selected, or is that a bulk load? Thanks. Josh

JRStern

05-07-2009 05:40 PM
JRStern

Hello I have a problem. I want to transfer data from a Table from one machine M1 to another machine M2 table Now the script to transfer must take...

Horatiu POPOVICI

05-07-2009 11:42 AM
Horatiu POPOVICI

I am using SQL 2005, and need to set up a SSIS ftp task to transfer files from remote ftp server. Everyday, and a file is posted in a folder in ...

qjlee

05-05-2009 02:55 PM
Todd C

Could not connect source component. Error 0xc0202009: Source - T002IDERNETO : SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error...

MarioC

05-05-2009 08:16 AM
MarioC

Hi I have (what i believe) is a Sybase database file *.db. I do not have a Server but the file came with dbeng9.exe I would like to convert this...

grahamdick77@gmail.com

04-30-2009 08:05 AM
grahamdick77@gmail.com

Hi, SQL Server 2000 Professional SP4 Windows Server 2003 What I'm doing: I have one dts package that generically pushes data from one db table to...

georgejetson

04-29-2009 08:37 AM
Charles Wang [MSFT]

Hi all, I have a ton of SSIS packagest that I've created which point to an Oracle Database; and sometimes SQL Server and Oracle at the same time. ...

greenmtnsun

04-24-2009 09:49 AM
Todd C

I have an SSIS 2008 package that takes ~1.5h to run on a 2 x Quad core Opteron server with 16Gb ram. The issue is whether there are some settings so...

Minas Papageorgiou

04-23-2009 07:39 AM
Todd C

that my doubt, when I export a file using UNICODE for a third party tool, it fails, if I open it with notepad and I save it as UTF-8, it works so -...

msnews.microsoft.com

04-23-2009 05:13 AM
msnews.microsoft.com

Hi, I have sql2000 server, there are a lot of DTS packages. I would like to upgrade sql 2000 to sql 2008, what is the best way to migrate the...

SarahG

04-22-2009 11:48 PM
SarahG

Hi All, I'm trying to do something that would seem easy, but I'm stuck. Help would be appreciated; I'm a nub to SSIS. I have written an import...

randy.buchholz

04-16-2009 03:29 PM
randy.buchholz

Hello - I am planning on using MS DTC for managing distributed transactions between two SQL Server databases. The organization that hosts one of...

kathymmm

04-16-2009 11:55 AM
kathymmm

Is * the only pattern matching character that can be used in the value definition of SSIS variables. Can other pattern matching characters such...

Ulysses

04-13-2009 03:53 PM
Ulysses

Hi there, having some issues with the above scenario... 64bit sql 2005 std edition. A control package is running in 64bit mode to execute a large...

Mike

04-10-2009 08:27 AM
Mike

Hi all, I am getting following error when executing dts package in msdb or structured file from command line using dtsrun.exe. The package runs...

sqldba

04-09-2009 01:11 PM
sqldba

DTS pacakage has Transfer Data Task using SQL query option, that writes to Text File (destination). DTS package is scheduled to run through SQL...

pn

04-08-2009 02:59 PM
Ilya Margolin

Hi All, I need to implement an SSIS package wherein during the run time (i.e. during the data load), the package should check / match the fact data...

Bhushan

04-08-2009 06:20 AM
Bhushan

1. How can you shedule DTS-Packages in SQL2005? 2. When you have created dtsx packages on a server, is it possible for a user to run that package...

amac

04-07-2009 05:26 PM
Artemakis Artemiou

Hi, I have a SSIS package that contains a DTS 2000 package in it. The DTS 2000 package imports data from an accpac file into several tables from an...

GC

04-07-2009 04:55 AM
itsdeshpande via SQLMonster.com

Hi, I have a source-Oracle-database in which I want to retrieve data and store those data in a SQL-database. Which data need to be retrieved from the...

amac

04-07-2009 03:57 AM
amac

HI, I have a DTS package SQL Server 2000 that I have convert into SSIS for SQL Server 2005. The conversion have Embedded my DTS into a package I...

GC

04-03-2009 11:11 AM
GC