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?

hardikr (11/28/2013)

---

Thanks for reply.

yes, Path and file both are exists when package runs.

OS installed on server is Windows Server 2008 R2.

My package runs under user SQLServices and I have...

hardikr (11/28/2013)

---

I am having the opposite issue. I am trying to execute SSIS package using xp_cmdshell.

Can anyone please help me?

I have created SSIS package which exports data into excel file....

Remove the line

Private Const Location As String = "User::VarLocation" // declared as variable

And then ...

Dim var1 As String = DirectCast(Location, String)

should become something like

Dim var1 As String = Dts.Variables("Location").Value

I...

I can't think of a neat and tidy way of doing this without scripting. But with a script task, not difficult at all.

Koen Verbeeck (11/27/2013)

---

Phil Parkin (11/27/2013)

---

You should bear in mind what the...

You should bear in mind what the packages are doing when...