I havs ssis who transfer data between two databases.
The process worked fine until i change the password on the destination
databasse.
Since then it won't work: after i set on Protection level: Service storage

I am trying to set up a DTS package that extracts all of Yesterdays
data.  The code that I am using works great in a view by converting a
DateTime stamp to just a short date, then displaying just the
GetDate() -1 (i.e., yesterday).  It does not work with DTS.  Any help

I have a problem accessing an open Textfile. I created a package to
Import Logfiles from an application which creates a new log every hour.
I can access the archived log-files without problems and I can preview
(!) the actual log in the SSIS-Designer, but I get an error that the

can u tell me how to fetch query from .sql file while working in DTS 2000?  
actually, I need to fetch query from . sql file(on local drive) and then
want to execute this query on a sql database to export that sql data to a
.txt file using dts 2000.......

OK, I give up.  Can not figure this out.
I have an Integration Services project which runs fine in VS 2005.   But
when I switch to the SQL server management and connect to Integration
services it gets "Connection Manager" errors.

Is there any way to transfer related tables in one Dataflow? I found a
couple of articles in Internet, but they recommend using 2 dataflows or raw
files. My dataload is within distributed transaction, so it can not be raw
files.

I have created a DTS package that exports to an excel file.
The problem I am getting is that this dts package need to runs once a day
and it appends the data each time it runs. I need it to Truncate the Data in
the excel file before copying the new data to it.

I have a problem with a clients station,  and don't really know enough about
SQL server.
Here's the issue.  
I would attach a screenshot,  but can't seem to find that option here...  

I am fairly new to SSIS, but am having loads of fun... but I've run into an
error that seems obvious, but I cannot seem to diagnose, and I have yet to
actually get a pivot to work.  I alway get the error 0xC0202090, "The pivot
key value "11" is invalid."

I am getting an error when running the package from cmd line using dtexec,
however, it rund fine using Execute Package Utility.
In the package I set the path of the checkpoint file dynamically from
variables.  When running from command line, I am getting this error "The file

Is there any Auto arrange feature or grid lines available within DTS so that
I can more easily line my steps up???
Thanks in advance.
PSULionRP

I have 2 database that perform activity then bulk insert into 1 table
in a 3rd database.  Is there anyway to make sure that thier is not
going to be a collsion.  I am wondering if I can check to see if a
bulk loading is occuring or not.

I have a DTS Package where there are 4 tasks all connected to each other with
OnSuccess flow , the first task is collecting all the files from FTP
and dumping in a STAGING area and then those files from STAGING area are
taken and processed with the next 3 remaining tasks.

I need to schedule a SQL Script to process and then EXPORT to .CSV
file.....and then....either EMAIL out the file...OR.... FTP it to a clients
site....?
Can I get some guidance on the best approach to accomplishing this..??

My apologies if this question is not suitable to be posted here..
We are facing an issue while moving a Sql 6.5 database to a Sql 2000
server using bcp out/bcp in.
We have moved several databases from Sql 6.5 to Sql 2000 earlier by