I need to encrypt and decrypt certain columns in certain tables inside a
stored proc. Can this be done and if so how? Thanks for any advice. This is
SQL Server 2005.

I am trying to move data from a flat text file to an Oracle database,
using a DTS (it's a long story).  I am using a DTS because some of our
servers are 2000 and some are 2005, so until everything is converted,
DTS is preferable to SSIS.

Oh great magi of Microsoft and Oracle, please help me!
I'm trying to get SSIS to connect to Oracle on 64-bit, but I'm having
trouble.
It's running Windows Server 2003 R2 (x64), SQL Server 2005 SP2 (x64),

Hi experts,
I have no idea why development of SSIS is easy but is hard when comes to
deployment with the wizard and copy the installation "deployment" folder on
the destination server..

We need to set up a monthly 'job' that reads and writes from our SQL Server
2005 database and creates FTP files. The logic is quite complex, its goes way
beyond a simple transfer of data. Would it be better to use SSIS or SQL
Server Agent to do this? What are the pros and cons? ...

I have an SSIS package that use a #temp table to store the list of ID to
compute in different DataFlows and SQL Tasks.
This package has 2 connection managers (OLE DB), Source and Destination.
In order to create the #temp table, RetainSameConnection is set to true on

I have a SSIS package that works fine when run inside Visual Studio.
It runs fine when run using the DTEXEC command in a cmd window.
It runs fine even when run in a powershell window using DTEXEC
It will NOT run as a job in SQL Server agent.  I get this mess shown below.

I've just begun working with SQL Server (2000) recently and have some
familiarity with setting up DTS packages.  I also have a lot of
experience with VBA, so ActiveX scripting should come easily to me.
Basically, I have a folder, let's say "V:\MyFolder\", and I would like

I am not sure what I am missing as far as the configuration but I can
not debug my SSIS package. I cna ste the breakpoints but the they are
never hit. I also donot see "Edit Breakpoint" when I am in the data
flow view. Can anybody tell me what I am missing?"

i need to take csv files to sql server 2000 on daily
basis..............can one help me how to do that....pls

I have 3 tables:
   Clientes
   Gerenciadoras
   ClientesGerenciadoras..

anyone knows how to setup the dts run options to:
Source:
   Server: remote
   auth Mode: SQL

SQL Server 2000 -- DTS Package Fails with error:  Invalid procedure
call or argument 'DATEDIFF'.  This works in a view.   Is there a
better way to do this?
What I am trying to do is transfer only yesterdays data (i.e., Now()

I have a SSIS package that runs fine in Visual Studio.   But if I put it in
a scheduled job in SQL Server agent,   it won't run.
Both VS and SA use the same account to run.
The error I get in the logs is an ODBC error.