is  there a possibility to export several tables at once in csv -
files?
Regards
Falko

I have a few queries I use to locate specific text within job steps,
views and stored procedures. These come in handy if you need to do a
"find replace" type of operation (although the changes are done
manually). For example, our email domain recently changed, so I had to

How can I export data between databases with different collation order (sql
server 2000)??? I would like to export correctly characters such as 'ñ',
'é', 'á', ...
Thanks a lot.-

Hello, can someone please tell me how to set up flat file connection object
when the format of the file is as follows:
Date Record(s) -  Fixed Format Assumed Decimal
                                                      Starting

Hi gang,
I am having a problem and could also use some help understanding something...
We have a DB in MySQL (5.0.51) that I am transferring to SQL Server 2K5
using DTS.  I am going through the MySQL ODBC v3.51 driver, and bringing data

I have had this problem before and I cannot seem to fix it now. There is a
post with the same subject line to review.
I think the solution I used is method 3 from Article ID 918760 but now I am
not able to edit the Command line in the SQL server Agent Job I think I used

All,
    Using the Business Intelligence Development Studio, I migrated a
DTS package from SQL Server 2000. When I run the packaged from BIDS,
it worked beautifully.

Hello, I need to import zipped text files from an ftp site.  Can someone
please tell me how to go about doing this?  
I tried the ftp task, but was unable to connect to the server.  There is no
login needed to connect, and I am able to access the site just fine without

getting this nice thing in my user acceptance test environment.
The AcquireConnection method call to the connection manager "XYZ" failed
with error code 0xC0202009.  
component "OLE DB Source" (1) failed validation and returned error code

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 where
I can find the DTS files.

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 of
loading its giving some problem. It is pretty straight forward load to sql
server. When I switched on the logging, here is what ...

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 tables, and it is causing an error message.
Is there anyway I could do it like "at edit mode" or some other ways?

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 answer.
I'm trying to use SSIS OLE DB Source to get some data from remote

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 bring the SQL 2000 DTS packages to
the new SQL 2005 server.

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 such as NOW() or
GETDATE(). Using these function results in errors, because the ODBC driver