Sachin Vaidya (2/14/2013)

---

Hi Cadavre,

Your response definitely shows a path to move ahead, thanks a lot for that.

But on the other side, it was very rude. It will discourage people from...

subramani.rudrappa 78855 (2/15/2013)

---

Hi,

i have mapping table which holds codes in Sql and i need to get dat from oracle source based on this codes

please let me know how can we...

l.caufriez (2/7/2013)

---

i created a package following this http://stackoverflow.com/questions/140850/how-to-avoid-ssis-ftp-task-from-failing-when-there-are-no-files-to-download

it's working except that the ftp task will not go to the specified remote path, and i think it's because the remote path...

quillis131 (2/14/2013)

---

Goal : Need to pull data from XML file (800MB).

Note: I tried to do with XML task and XSLT but couldn't make it work, it gives me an...

Yes you are. Indexes do not have to contain unique values.

Here is one way, using running totals & an additional column.

1) Create a FamilyId column on Members_GD

alter table dbo.Members_GD

add FamilyId int

2) Populate the FamilyId column using grotty double quirky update...

Do you have an index on the 'server' column?

iamsql1 (2/14/2013)

---

i have a new problem .

i am writing ssis package having For Each Loop Container Which iterates through DropBox Folder ..

But when it iterates, it...

kingdonshel (2/13/2013)

---

Hi opc.three, the truth is your code makes no difference the code works in the same way with or without your code as long as the file path is...

Weird - have you tried stepping through your code in debug mode to verify exactly what is in your attachment variable?

The code provided looks like it should work.

You will find that people will respond better if you post error messages and what you have tried to resolve them.

Very...

This is a cross-post - no more answers here please - use this thread instead.

mister.magoo (2/12/2013)

---

dubem1-878067 (2/12/2013)

---

I have a varchar column containing dates (not my design) with this format 2013-02-12

I need to extract records between two dates

this code will do the job

where...

I can't really see what this has to do with SSIS, but here's one way.

declare @MyDate datetime

set @MyDate = '2012-12-29'

select DATEADD(dd, - (DAY(DATEADD(mm, 1, @MyDate )) - 1), DATEADD(mm, 1,...

athi_ssn (2/12/2013)

---

I have created a sample package for the first 5 scripts having 5 different sources,dataflow task and destination. I wanted to know if there is any other simple way...