This will give you a list of identity columns.

SELECT *

FROM

INFORMATION_SCHEMA.COLUMNS

WHERE

COLUMNPROPERTY -- get columns where is_identity = 1

(

OBJECT_ID(QUOTENAME(table_schema) + '.' + QUOTENAME(table_name)) -- table ID

...

I have both Professional SSIS (mentioned above) and Microsoft SQL Server 2005 Integration Services by Kirk Haselden.

Both are good. I'd say Professional SSIS is a better beginner book as it...

You might be able to take the opposite approach. Instead of resorting a full backup and then deleting all but 3 days of data, create an empty database and load...

While you are debugging you might want to set the flat file error outputs to redirect rows instead of fail on error. You can send them to a Row Count...

In the flat file source, is the output column width large enough for the row that is causing the failure?

Open the connection manager wizard for your flat file connection, go...

The attached script gives a little more column level detail. If you are comparing a prod database to a dev or QA database you could run the query in each...

Here is another quick and dirty way to compare if both databases are on the same server. You probably want to take a look at information_schema.columns and add a few...

A brief prose document along with inline comments provide a basic overview and aren’t too difficult to create and maintain.

Anything more detailed is not worthwhile unless an established process exists...

you might try this:

http://letmegooglethatforyou.com/?q=free+open+source+sql+schema+diff+tool

If the format is always 3 char followed by 5 numeric can you just get the right 5 characters?

DECLARE @tbSample TABLE(Code VARCHAR(10))

INSERT INTO @tbSample SELECT 'SDH00151'

INSERT INTO @tbSample SELECT 'SDH00152'

INSERT...

You can use a merge join transformation in a data flow. Both inputs to the merge join need to be sorted.

Create connection managers for DB1 and DB2 and create data...

A few things you might try:

If you will be doing a lot of transformations in the data flow pipeline in addition to adding the Imported column you could use a...

We use an approach similar to the following:

http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/62933/

From a technical standpoint it works well as a script distribution mechanism but I doubt we have realized much in the way...

One thing I do to test package configurations is to change the connection string property for every connection manager in the package. I usually replace the server name with “NoServer”...

Your approach should give you a passive deployment process if you use indirect configurations. See the attached screenshot.

Your environmental variable has the same name on your workstation and across environments...