From 2005 I was able to connect to 2K but was not able to Connect 2K to 2005.  Not sure why

I am not to sure, but if the case does not work try three subqueries.  that may work.

Select Sum1,Sum2,Sum3,

From

(

(SELECT sum(LDGR_BAL_AM) as [Sum1] 

FROM DEVL8SGA.A_SGA_GRP_PSTN_SNP

WHERE  ACCT_GRP_NO                    = 2100099

 AND  ACCT_NO                        =...

I just found out how to do it.  When you create the first project it says Solution: and next to it you can select create a new solution.  Then when...

What you are saying is what I thought.  So you can manage it from SSMS but SSIS is really for developers on projects.  In my case I could have 3...

The connection manager is what connects to the file specified.  XX.xls  and the Server and DB needed. Then you would use a Data Flow Control.  Once you double click on...

I use the connection Manager.  Create a connection to the excel document.

When I went to the seminar MS said most of the ways the DB engine worked and the controls have been changed.  So it is a rewrite in a way.  It...

There is an old way in Visual Studio to create a database project under other projects.  Then it integrates with VSS.  That will allow you to have a central VSS...

That is weird.  I was looking at the data and it looked to be aggregating like you are saying that is what I thought.  Now skipping lines you may be...

Yea That sounds like fun.  I asked him to change it to a pipe delimiter.  Hopefully he is willing to play along with my testing

the file is fixed width so a designator is not needed.  I tell the process where the terminator is.

i did look at lines 90,91,92,93,94 and they are no different then...

Wow that is a real bummer.  Since it is the Default instance I will need to take the old machine down and bring the New SQL Server up.