saurabh.deshpande (10/6/2010)

---

1. I tried both the way, on performance front EXECUTE SQL Task is

good as compared to DATA Flow’s.

...

Grant Fritchey (10/6/2010)

---

That sentence is WAY too long:

Wow, loading data into Access is a Royal...

Look at the CHARINDEX function and combine it with the LEFT, or SUBSTRING, function.

LOL

I haven't had to face that yet so I can't comment, well, looks like I...

You can do it either way. I'd encourage you to try it both way just to see how well each one performs.

Also, ask yourself this question: "Why one...

Steve Jones - SSC Editor (10/6/2010)

---

I just checked. Almost everything in the db for forums is an int, so we're fine.

As an FYI, we have about 5GB of data in...

What myth? 😀

Hughesy (10/6/2010)

---

OK. Thanks guys for the posts, I meant bundled with Enterprise for example on the MSDN licence.

Do you happen to know if there are any changes to the Integration...

Steve, didn't you tell us a while back that it was a...

Stefan Krzywicki (10/6/2010)

---

Steve Jones - SSC Editor (10/6/2010)

---

Stefan Krzywicki (10/6/2010)

---

Alvin Ramard (10/6/2010)

---

Looks like the Thread hitting 20k and the forum hitting 1 million are going to happen fairly close to...

A task can only exist in one...

Soulfly73 (10/6/2010)

---

Hello all,

First of all I think this is one $%^of a forum, tons of information and I thank you for that 🙂

I have a question, I'm importing data from...

Look to the left of any post and...

Jim Covington (10/5/2010)

---

I need to get access to a package variable to use in the steps of my ssis package.

I have created the Variables as type String and a scope...

It's true that informatica comes with more built in features but, assuming you will be running SSIS on an existing SQL Server, it also comes with a much higher price...