What can you tell us about the server that it does not work on and the one that does.  There must be a difference.  I have found that the lookup...

I have had a great deal of luck using the SCD wizard to both find and update records.  It is very data type sensitive, but it does a good job...

SQL has an input buffer limit.  I don't know if it is a set size or if it is based on the available server resources, but if the length of...

You can execute a shell command to run an executable from xp_CmdShell, but you cannot run something with a user interface.  SQL Server runs as a windows service - which...

I'll throw in a comment on this.  I have worked with SQL Server since SQL 6.5 and also worked several versions of Oracle for about 4 years.  With SQL 2005,...

The config files look like any well-formed XML file - a bunch of tags indicating rows, columns, values, and relationships.  XML Notepad (free from MS) opens and saves the configuration...

Jeff, the answer is yes.  You can save the errored rows or files anywhere you want.  The error handler is actually another complete data flow per error handler you create...

Click on the component you are receiving the error on (I think you said it was your data flow) and click the Error Handlers tab.  Create an error handler to...

If you wanted to avoid writing any code, you could dump the data into a single temporary file (XML or a database table would be even better).  Use another for...

Package configurations are the way to go.  Here is what we have done.

We use XML configuration files.  We have created a directory on our local development machines C:\DTS\SSIS\Configurations (the DTS...

Here is my thought on the why...I don't know if this is what the engineers at MS were thinking, so take this how you may.

In MSSQL 2000 (and 7), a...

With a 5gb data file that is only 6% full, you could use some shrinking.  The overkill of disk space can actually hurt your performance a bit because the OS...

There are some synchronization tools that are available.  Red-Gate has one that is pretty good, Quest software has a free one, but you get what you pay for, and there...

If the place that the VB code is running (your web server in this case) is also an SSIS server, just call DTExec through the shell from the VB code. ...

You have some options.  The simplest way to do this is to use shell and the DTExec command line utility.  Look for it in books online - it will...