Probably most of the people on this site have had a similar issue at least once.  Sometimes a major restructuring of a query does not fool the query optimizer at...

In general, it is NOT a good practice to add any kind of join or table hints to force the query to do things it normally wouldn't do.  In SOME...

SQL Server handles concurrent operations in whatever manner the developers choose to tell it.  It can enforce very strict table locking during some operations, which is good for speeding up...

To read that much data, adding in multirow requirements like incrementing the Row Number on rows that begin with 00, you might be better off writing your own code in...

I would use CONVERT(CHAR(4), GETDATE(), 12) to get the YYMM characters, then STUFF the middle part of the existing attribute value into it.  This avoids all those RIGHT() functions.

There is another way to do it by finding all the item nodes and using xpath expressions to navigate back to the grandparent salesOrder node. This is going to...

The design-time values in an SSIS package can be overridden by package configuration, so be sure you check all the package configuration settings and understand which order they are applied...

The original version of this package was in SQL 2008/VSDT 2010, and it had no problems with the SharePoint download.  It ran in Visual Studio, it ran under DTEXEC, it...

Thanks for your suggestions.  I tried adding the UseDefaultCredentials and PreAuthenticate settings suggested by your link, but I didn't check the IIS web pool configuration.  The code changes alone did...

I just ran some more tests and tried running the package on my laptop via DTEXEC.  It failed.  The same package and configuration runs successfully in Visual Studio on my...

Or NOT ( UPDATE(col19) OR UPDATE(col20) )

You can configure parameters to control how the job executes.

For an Execute SQL Task you want to use the parameters to define package variables with the database names. ...

The documentation for the command-line FTP in Windows does not show a parameter to specify passive mode.
You can set passive mode operation on an FTP task in an SSIS...

The standard flat file source can skip n rows and deal with a header row.  It can't skip rows 2, 3, n-1, and n.  There is one possible solution by...

How about changing your primary key to a unique index with (ignore_dup_key = ON) ?