I need to setup a process that would pull data from different source, compare
it to "local" SQL Server 2005 database resolve and update data differences.
So, I started new SSIS project, hoping I can figure out things as I go,
that's how I learned DTS after all. But I am totally ...

I'm using SQL2000 DTS services to export stored procedure result to EXCEL
file.
When I open EXCEL file, all the data is prefixed with ' character like
'AAMURUSKO

The DTS package reaches out to another server on the network to pull in a
text file.  The DTS package runs fine when launched from Enterprise Manager
or if scheduled as a job.  It FAILS to import the file when launched from an
ASP page.  The other tasks in the job run fine ...

Today, I wasted six hours trying every way I could think of to transfer data between a remote SqlServer2000 server and a local
SqlServer2005 server.
Prior to "upgrading" to this ridiculously poorly designed piece of trash known as SqlServer2005 that process would've taken about 3

I made a batch file which runs an ftp script.  I'd like to put this either
into a sp.  Not sure how to go about this.
Here's the batch file:
ftp -i -s:c:\laufer.txt laufer.com > c:\laufer.log

I want to rename the db for the test db to the production db.
Russel Loski gave me this code:
Sub loadPackages()
Dim rs As Recordset

I think I have a problem with the transmission speed of data when doing a DTS
between two SQL 2000 SP3a server hosts running Win2K SP4.  They have the same
updated MDAC versions and I've conducted several tests, including running the
SQL Best Practices tool to check server ...

I have a column containing string data like the following:
CORP/EAST/TENNESSEE
And I need to transform this data to split out the names using the "/" as
the delimeter.  I was doing this in Excel using "Text to Columns".  Please

We have just upgraded our 3 main production servers to Windows Server
2003 from Windows Server 2000, these consist of a file server, SQL
server and exchange server.
We are having problems running SQL jobs that run DTS packages. The

Hey, I just installed sql server 2005 onto a new machine to play around
with it, having used client tools from sql server 2000 on an old machine.
I connect to a remote sql server 2000 database and pretty much all the
functionality is there using management studio - however I am ...

I'd like to be able to execute an SQL command automatically when the database
is brought online (or attached or the server starts).
I assume it'll require DTS, but I don't even know what to ask for in Help.
(SQL Server 2005 SP2)

Hello, everyone!
I'm attempting to develope an SSIS package that uses variables passed to
determine selected values.
I'm using an OLE DB Source, and passing the query in that source values from

This is a long explanation, so apologies in advance!!
In a Control Flow I can use precendence constraints to determine how and
when things run.
However, I've got a need to do something similar in a Data Flow.

I can't Copy a database from Sql Server 2000 to 2005. I am using the Copy
Database option from Management menu. I want to transfer all tables, and all
stored procedures. I've tried everything for the past 3 days, and it didn't
work. I always get the same error.

I have a pump that does one data pump and then runs a series of sprocs
(In Execute SQL tasks) on the data to transform. The transaction file
is growing quite large (I don't have access unfortunately to the
customer's production server). If the DTC service is not started, that