Take a look at this MSDN blog post:

Calling SSIS Execute Process task from a remote batch file.

I forgot:

if the source and destination table are on the same server, you can replace the DELETE statement with a trigger as an alternative.

Don't forget to do the parameter mapping in the OLE DB source:

SSIS – Pass a variable to a OLE DB Source in a Data Flow

[/url]

This can be a bit buggy...

Charmer (4/19/2012)

---

Yeah, i get the same result with trim and without trim...

but some times i see the columns have spaces in front of the values.....in this case i hope i...

Stefan Krzywicki (4/19/2012)

---

LOL, SSMS! That shows how distracted I was when I posted. : -) Sorry about that.

I'll seek permission to get it installed. This is just development assistance, right?...

It's not really efficient to join on two different datatypes.

Ideally you would convert to char column to varchar or vice versa.

The behaviour of SQL Server and white space can depend...

Charmer (4/19/2012)

---

Koen Verbeeck (4/19/2012)

---

The problem is that MSDN is...

Mikalina (4/19/2012)

---

Ok, thank you for your help! I learned something new today

But how can one see the package process when running it with DTEXEC? I mean which task ended, which...

Mikalina (4/19/2012)

---

Are you saying it's not recommended to run ssis by clicking on "Execute package"?

I sure did run some selects, the main table seems fine and so is row...

suresh.arumugham (4/18/2012)

---

Hi,

I have to establish a VPN connection to a remote server first, then connect SFTP to transfer files from there. I am able to connect the VPN in SSIS...

Looking at the current score, certainly. 32% for Read Committed.

If Snapshot Isolation was one of the answers, I would understand a...

I wouldn't use a For Each, but a for loop, as you know upfront how many batches of 500 rows you need to transfer.

In the OLE DB Source, I would...

robsindle (4/18/2012)

---

I just downloaded the SQL Server Express 2012 with tools. It was a 686MB file called:

SQLEXPRWT_x64_ENU.exe

Does that contain all we need to install it on a 64-bit server...

Mikalina (4/19/2012)

---

I have no idea what DTEXEC is, and what do you mean by "run a package with production purposes"? Sorry i'm just a newbie at this.

I didn't build this...

The problem is that MSDN is not really explicit...