This article should give you the info you need.

http://qa.sqlservercentral.com/articles/Test+Data/61572/

Some source test data, for anyone else who might want to play.

INSERT INTO dbo.Source (

FirstName,

LastName,

Phone,

Address,

Address2,

City,

State,

ZipCode

)

SELECT 'Joe','Smith',NULL,'123 Spruce Street','Apt #1','Madison','WI','12345' UNION ALL

SELECT 'Sally','Smith',NULL,'123 Spruce Street','Apt #1','Madison','WI','12345' UNION ALL

SELECT 'Bill','Jones',NULL,'789 5th...

First, insert into the address table any addresses from the source table that aren't already in the address table. Now everyone in your source table will have a row in...

We chose to deploy packages to MSDB. It was the best fit since we already had a substantial number of DTS packages deployed there along with processes in place to...

I’m making some assumptions about your request, hope this helps.

Seems like you are manually running some queries each day, probably copying and pasting the results from Management Studio into something...

There are a few reasons an interviewer might ask these kinds of questions.

They might have a tool that is an integral part of their process. If they deploy code...

Any task that is repetitive, complex or error prone would probably be a good candidate to automate. It really depends on the complexity of your environment and what you need...

You can’t do this directly but by adding a dummy column to both data sources you should be able to accomplish it with a Merge Join transform.

If both of your...

You can do this with an Execute SQL task and a Data Flow task. You will also need two connection managers, one for the database your stroed proc is in...

You might be best off pushing the logging into the VBA macro. The macro could call a stored proc that logs user and time then starts the job via sp_start_job.

How are your users executing the job? If it is through a web interface or application you might be able to capture the user at that point. If they are...

Does the spInsert stored procedure do anything except insert a row? Does it do any data cleansing or dupe checking?

You might be better off loading the file into a staging...

The OLE DB command will run an update for every row. So if you have 50 reversal rows that’s 50 individual updates.

If it is permissible to add a staging table...

This might not be as easy as copying the data.

You could use a For Each loop to run an Execute SQL task that does something like:

Select * into SqlServerTable...

You might want to try tablediff. It is a SQL Server utility used to support replication. In a default install you should be able to find it at: C:\Program Files\Microsoft...