Loads of examples of this all over the Internet, but try this for starters & see whether it helps.

opc.three (2/18/2013)

---

Good to know you have a way forward but it seems like a Script Task would be a better choice here to save you a round-trip to the database...

And here's a really obvious (yeah right!) way of making Lynn's example work:

declare @DateVal datetime;

set dateformat mdy;

set @DateVal = '2013-02-14T00:00:00';

select @DateVal;

go

declare @DateVal datetime;

set dateformat dmy;

set @DateVal = '2013-02-14T00:00:00';

select @DateVal;

go

Are you sure that having a single flat file containing mixed data would be an acceptable solution? Sounds like a real mess to me, but, funnily enough, I had to...

Your ExecuteSQL task will have associated with it a system variable called ContainerStartTime, scoped only at the task level. Maybe that is worth a try.

I apologize once again if that will help.

I would have removed this post if it was in my hands, but please give me a chance to explain that I was...

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...