As I said earlier, if you want to do this dynamically in SSIS it will require a level beyond basic skills. This can be done in .NET using a Script...

A format file is more than just a command line. Its a separate file you have to Create manually.

lakshyanda (5/30/2013)

---

thanks for the options but what if in future the number of files increase

with increase of files the data flow tasks would look messy with individual source -destination...

You posted in the SQL 7,2000 Forum but I assume you're on a later version if you're using Database Mail. Please confirm.

If in fact you are using Database Mail I...

Windows does not know what to do with a file with a .jar extension by default. You will need to pass the path to the .jar into the JRE using...

Your plan looks good. You'll need two different Connection Managers, one for your SQL Server and one for your Oracle instance. You could use OLE DB or ADO.NET to talk...

sqlfriends (5/28/2013)

---

Sure. Your package would have a Data Flow containing an OLE DB Source and a Recordset Destination (really it is an ADO.NET DataSet under the covers) to capture the...

Great news. There a lot of these connectivity issues but not a lot of solutions that detail renaming a security certificate. It might be extremely helpful to others that find...

Somewhere in your process you need to define the format of your files, I.e. to specify the metadata of your files. You can do this in SSIS with Flat File...

Get Sysinternals Process Explorer and see what dtexec has references too when it hangs. It may give some clues as to what might be going on.

AD supports 15 character computer names so this sounds like a bug in the cmdlet that would have surfaced pretty quick and been fixed, but maybe not. I don't have...

Ola's solution takes all of that into account. You can have it backup only certain databases, and it supports full, differential and log backups too. Have a look and post...

Instead of using a cursor directly against sys.databases, try putting the rows into a #temp table first. Also, try adding FAST_FORWARD option to the cursor just to be sure.

If you...

Could be lots of things. Try some of the basic troubleshooting articles, see if you can narrow it down.

http://blogs.msdn.com/b/sql_protocols/archive/2008/04/30/steps-to-troubleshoot-connectivity-issues.aspx

What is the difference from your perspective of creating 25 XML format files and creating 25 Source-to-Destination pairs in an SSIS Data Flow? Just curious.