I've done the same as Grant and Steve, although with a different source control tool. You have to build processes around your change control that everyone follows. Document...

Given the new sample data that you've shown, what would you expect the results to look like?

Ha, good one Seth!

This is a simple LEFT OUTER JOIN:

DECLARE @tableA TABLE (DealerId varchar(10), ISCI varchar(10))

DECLARE @tableB TABLE (DealerId varchar(10), ISCI varchar(10))

INSERT INTO @tableA

SELECT 's021','1234' UNION ALL

SELECT 's021','2354' UNION ALL

SELECT 's021','2564'

INSERT INTO @TableB

SELECT...

What data source are you using to the the XML column into the pipeline?

For the config file, only check the boxes of the items/variables that you want to be able to change from outside the package. I would imagine that most of...

If you've set up the script task inside the...

I am stuck with the event handler part and send mail task !

Why the event handler has execute SQL task with a dummy statement ?

Also the variables you mentioned...

First off, thanks for the detailed post. It is most helpful to know where you are at so we can make the appropriate adjustments and get you moving in...

Sorry for the delay on this, it kind of fell off my radar. The intent of my last question was to learn which control/data flow tasks you've used to...

It was the correct answer for a question that was never asked. Based on your original post, how can we tell what you've already tried, where your problem lies,...

Go to the Master database, under Programmability>>System Stored Procedures and find sys.sp_who2. You can review the code.

Once converted, it would not need done again. Just curious, why would this be something that...

From SSMS, run sp_who2. This will show all connections to the SQL instance, which DB they are connected to, the host ID, application name, and all other connection related...

In addition to what Sabya has said, maybe try to do this yourself and let us know where you need help. We're not here to do the work for...