Ben,

You are correct that the native FTP tools in SSIS will not support SFTP.  You'll need to look at a third party utility like /n software (

I just ran through creating some dummy data (numbers stored as text) in a text column and running Substring() as you described, then entering the result into an int column in...

Can you post some of the expressions you've tried, and the associated error message (or the output, if no error)

Is filecryptsb the name of the executable?  If so, you need to add this in the Executable field and the remainder of your command [--encrypt test.txt --user test] in the...

Pete,

I agree with the previous poster that more information would be helpful.  However, here's my crack at it, with the information in hand:

Members table: includes whatever information you intend to...

Ryan -

Use the Execute Process task to run pgp.exe (or whatever the PGP executable is called on your system).  You may have to tinker with the parameters you pass...

If you' re looking for a simple graphical tool to manage MSDE, you can download the SQL Server Management Studio Express from Microsoft.  This free tool is part of the SQL...

Your best route for this is to create a text file containing your backup command, and create a batch file that will call osql using your text file as an input...

Along with Mohammed's suggestion, take a peek at resource utilization on your db server, as well as your web server driving the client side (assuming they are two different boxes). ...

Depending on whom you ask, this is either a bug in SSIS or an incorrect installation of same.  Double check that you installed and are running the SSIS service, and...

Rudy hit the nail on the head with his first sentence - IT is viewed as a cost center.  In organizations that do not make money from their IT folks...

I agree with the first couple of posts.  After working in this business for the better part of a decade, I realize that mistakes happen - even a big company...

We install the management tools on all of our production machines.  We do so because there simply is no downside, and lots of potential benefits. 

Other than disk space, there...

Check into the BCP utility.  It should give you what you need.

hth

Tim

It depends - if you're doing a simple, one-time load from SQL2K to SQL2K5, it might be easier to use the Import/Export wizard.  If you need to do some transformations...