sqlnaive (12/4/2013)

---

Twin/Koen, It was a typo. It's infact dstx. I was just cleaning the official info from the logs....

Have you got...

You'd already written 99% of the required query:

MERGE dbo.tblcustomerTarget AS dd...

abhas (12/4/2013)

---

Yes,Thanks. the query is working fine but its taking time to execute a package. After lookup i am using conitionalsplit transformation and comparing sourceid with targetid and fetching...

suchitra.venkataramani (12/4/2013)

---

Hi,

I have created a package in ssis and i need to schedule it every week. How do i do that since i found out that there is no...

abhas (12/4/2013)

---

Thanks Koen,

But in the target table there is one extra column ISdelete. If record is deleted from source then i need toset value of this column is D. If...

Gustav_99 (12/3/2013)

---

steveb. (1/13/2011)

---

you can add a sort transformation and check the box to remove duplicates based upon the sort key,

or you could put the data as is in a...

Shadab Shah (12/3/2013)

---

Phil Parkin (12/3/2013)

---

Shadab Shah (12/3/2013)

---

I am trying this on SSMS 2008 . Since there was no group as SQL Server 2008 Integration Services , i am posting...

--Edit: comment removed.

While I...

Shadab Shah (12/3/2013)

---

I am trying this on SSMS 2008 . Since there was no group as SQL Server 2008 Integration Services , i am posting this question over here....

Here's some rough code - might get you started.

Public Sub Main()

Dim ErrorMsg as string = ""

If not (System.IO.File.Exists("C:\FileData\file1.txt")) Then ErrorMsg = ErrorMsg & "File1...

Jeff Moden (12/1/2013)

---

I don't use SSIS but, speaking from an old dude's perspective, I'd likely make the loading of each table a separate package for reusability and then have a...

Why are you doing this in script? Use a dataflow.

To do what, exactly?