Where, exactly, did you try to change change the codepage?

I'm not logged in to SSIS at the moment, so can't give you exact details, but you need to start off...

robinrai3 (6/28/2012)

---

hi All,

I am using a single dataflow that is populating OLE DB staging tables from respective OLE DB data sources. So they all run in parallel. My question is...

tush002sunny (7/2/2012)

---

Thanks,

I tried it & it's working .

I also have to check a particular character at an index no. 8 is blank/null/not specified .

If character is not present there then...

ChrisM@Work (6/29/2012)

---

If you'd said "less than 6" then you would have had alternatives options to a function. With a maximum of about 50 items in the list, then I reckon...

Hundreds of ways of skinning this cat.

Here's one:

declare @a table (PID int primary key clustered)

insert @a (PID) select 101 union select 103

--Obviously expand this / modify it as needed to...

What about this?

SELECT *

FROM dbo.Product_Test p

WHERE p.PID IN (101,103)

Do you want dynamic headers/footers, or just some static text?

Jeff Moden (6/28/2012)

---

Heh... "It Depends.":-P

What I'm really waiting for next if for Phil to answer the qauestion as to whether...

Is it perhaps importing a named range on the spreadsheet?

First of all, thanks Dwain for doing the testing & suggesting your own solution.

ChrisM - think you've got some tuning to do 🙂

just as a side dish ... why is...

Adi Cohn-120898 (6/25/2012)

---

Here is one more way:

;with MyCTE as (

select HotelId, RoomTypeId, cast (DateKey as char(8)) as DateKey, FreeCount,

row_number() over (partition by RoomTypeId, case when FreeCount = 0 then 0...

Jan.Sundbye (6/25/2012)

---

Jan.Sundbye (6/8/2012)

---

I have similarly need but in my case I just want to build and maintain one package and use a parameter as a variable in the package. Can...

Excellent, thanks guys. Both ways look good to me - as I expand the problem into the real world, I'll assess which fits best.

Apologies if this is obvious, but you're not looking for a full duplicate. Just a duplicate...

Koen Verbeeck (6/22/2012)

---

My guess is that you have duplicate rows in your source.

The first row inserts fine but at the second row you get the unique key violation error.

When you...