If your configured properly...

To answer your question, why not make an identity column on the destination table. That would make life too easy 😉

The data is a telephone activity going into a...

Trying to compare each value in every record to that currently in the table is agonizing for the cpu and extremely low performing. Instead try to identify something in the...

You might want to look at storing those username/password combos in an encrypted manner inside SQL to better protect the data. Of course you would need to include a script...

If your package is inserting the data into a staging area why not just add an identity column to the staging table for row number? You might also just insert...

What is the condition on which you want to split the column? You may use a derived column yes...

Go here: http://msdn.microsoft.com/en-us/library/ms141232.aspx for some details on the expression language...

Like so:

SELECT

CONVERT(CHAR(10), Title)

+CONVERT(CHAR(75), FirstName)

+CONVERT(CHAR(75), LastName)

+CONVERT(CHAR(100), EmailAddress)

FROM

AdventureWorks.Person.Contact

What I've done in the past to accomplish this is to concatenate all my fields in my select list together while converting to char values with hardcoded lengths. This way...

Use the same 'Execute SQL Task' I suggested for the Master package and add a condition to your precedence constraint that specifies @Exists =1 for example...

Might it make more sense to not hardcode the RecType in there?

Can you provide some additional details about exactly what you are trying to accomplish?

Underdog,

Have these packages been deployed to a production or are you just running them locally? Just a hunch but that may be why you're seeing such shotty performance...

Also, you said...

To thenepatsrule: You would never want to deploy a package to production that required user interaction such as a message box.

To Bindu: xp_cmdshell is dangerous which is why it is...

xp_cmdshell is disabled by default in SQL 2005 so unless you have had your administrators enable it (not recommended) you won't be able to use it. Like Lynn said, us...

If you are familiar with SSRS...

http://technet.microsoft.com/en-us/library/ms156012.aspx

If you are not, first get acquainted and build the simple report, then use the above link to create the data-driven subscription...