Good intro. Thanks. 

I've got a question, though.  Given this statement from your article:

INSERT INTO SalesByPerson

SELECT SalesPersonID, [2002],[2003],[2004] FROM Sales.SalesSummarry

PIVOT(SUM(SubTotal) FOR OrderYear IN

([2002],[2003],[2004])) as SalesPivot

is the IN (.....) required?  What...

Why?

Case was designed to do this.  Anything else would be much more complicated.

Maybe in part because the oil and car industries put more money in their pockets campaign funds than do the people. 

Basic syntax:

if x

begin

--do what you want here

end

else if y

begin

--do what you want here

end

else

begin

--do what you want here

end

More importantly, what are you trying to accomplish?  As far as I know...

Well, if you want to use DTS you could use a VB script.

You could also potentially do this with a T-SQL statement / stored procedure.

Have a look here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_fa-fz_2c1f.asp

for date...

You're welcome. 

Let us know if you have any further questions / problems.

Since Subversion is essentially a file management system, all you have to do is generate the appropriate files and then import those files into Subversion.  For tables, stored procs, views,...

If they are both indeed datetime, then datepart should work.

WHERE   (DATEPART(mm,src_terrier.datadate) = DATEPART(mm,@dt_src_date) AND

DATEPART(yyyy,src_terrier.datadate) = DATEPART(yyyy,@dt_src_date))

AND

    (src_terrier.Areacode = @chr_div) AND

    (src_centre_list.Portfolio_no = @vch_portfolio_no) AND

    (src_centre_list.propcat =...

SQL Profiler is your friend.

Is this a remote server?  When you "executed the package" did you do so from your machine or from the server?

Also, check the file path.

I had a similar situation and used a table in the database.  I found it quite handy for troubleshooting at times.

Right click in EM and you should see a task for generating scripts.  (It might be under all tasks.)

I have plenty of friends and a very rich and active social life that has absolutely nothing to do with work.

My work associates are strictly that.  I'm cordial but it...

You're probably better off to post this to the Access forum.

I can think of three different ways:

1) run a script before loading to fill in the data.

2) load the data into a staging table (probably one with an identity column), then...