Hey,

You may want to post this in the SQL2005>Development forum, as I am not sure that this is a SSIS related question.

From my limited (and I mean extremely limited) knowledge...

What happens when you use numeric and date types?

hey,

Apologies for the short reply yesterday (my bad, had a deadline and one very irate client to deal with...)

Here is a posting which looks similar to the problems you are...

try sp_helptext, this will give you the procedure as it is on the database

A little bit off the cuff, but BIDS may be able to assist you with this one.

Create a for each file enumerator, and increment a count variable with 1 each...

Maybe your new procedures arent compiled?

I havent executed batch files in SQL 2005 using the SQL server agent from the job scheduler yet, but surely it should wait for the completion of the step before...

As long as you keey on posting on this forum, these pros will sure go a long way towards making it easier than before...

Even if the data is large, a subquery might do the trick for you

Select view1.date, view1.column1, view2.column2, view3.column3

from

(select date, column1 from table1) as view1

left join

...

Uli,

Look at this article:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

This will tell you what you get with your edition of SQL.

From what I can see at a glance, you get the basic transforms, but not the...

Hey,

I dont quite understand what the problem is?

You want to populate the destination table with a bunch of sources. Merge join would suffice. Lookups will suffice as well.

Depends on...

No idea, but my first stop would be to try and re-install BIDS

Good luck

~PD

Hey,

Uhmmm, dont you mean Windows Server 2003 x64 with SQL Server 2005.

What version of SQL server do you have installed, and have you installed the latest service packs?

~PD

Hey,

Yes you can, but it will return slightly more than what you are bargaining on

select

W.WOMAN, G.GUY

from Guys as G

inner join Women as W

on G.Desired = W.Desired

This will return any matches...

Hey,

happy to assist...

As indicated before, this forum is more for the database development in SQL (you will find some pretty hardcode Transact SQL here with some really...