Thank you!

Also I cannot find a way to use select distict in flat file source, is there a way to do that?

Thanks

sam.dahl (11/20/2011)

---

Just a thought, but you could just load the data from the file, multicast it to two streams, sort each stream on the required keys removing duplicates, and send...

Thanks, if BIDS installed, they develop some ssis package, it cannot be run if I havenot installed ssis service on the computer, correct?

And if integration service is listed here in...

SSIS do you mean both intergration service? How about BIDs?

[for client tools all you need to...

How about business intelligence development managment studio?

And also how about other items in the shared features in my previous post?

Thanks a lot.

I have noticed that before but thought that is for server only.

In our enviorment we often have people to request to install SQL server client tools on their...

Never mind, I felt it is so hard to describe it.

Yes, it is the correct server.

Thanks, for this one actually I do want to generate multiple insert statements for another production enviroment for release. And it's a delta data script.

Thanks a lot, will look into it.

Thank you, that helps a lot.

Thanks, so above statement, for inner join it doesn't...

so if I change the join to cross join and take off 1=1, it will be the same, correct?

But I read somewhere if a cross join have a where clause,...

Jack Corbett (11/7/2011)

---

sqlfriends (11/7/2011)

---

Ninja's_RGR'us (11/7/2011)

---

So when you rebuild you need AT LEAST another 4.8 GB of free space (unless doing it in tempdb). Since you only have 3.7GB left...

Ninja's_RGR'us (11/7/2011)

---

So when you rebuild you need AT LEAST another 4.8 GB of free space (unless doing it in tempdb). Since you only have 3.7GB left you have this...