I don't care for it, it's too small and difficult to find your way around.

Yes, that's exactly what I was trying to achieve.

Thank you very much for your help.

That's the benefit of ignorance: It never even crossed my mind there might be a problem, I just went ahead and did it 🙂

Another way might be to partition the table - or index - switch out the desired partition(s) to a temp table and drop the temp table.

I'm doing this on 1BN...

Excellent article.

When somebody gets around to writing the VB code in C#, could you pls. post it?

Hi Lynn,

It looks like you got it right the first time - although I'm not sure I fully understand it (yet).

Unfortunately i haven't had time to provide you with a...

GSquared (12/6/2012)

---

Is there anything at all in your second table that indicates which customer the data is tied to? Also, anything that indicates sequence?

Honestly, the data looks poorly designed....

This is what I found:

Drop a script component onto your data-flow right after the flat-file component.

using System;

using System.Data;

using Microsoft.SqlServer.Dts.Pipeline.Wrapper;

using Microsoft.SqlServer.Dts.Runtime.Wrapper;

[Microsoft.SqlServer.Dts.Pipeline.SSISScriptComponentEntryPointAttribute]

public class ScriptMain : UserComponent

{

public override...

I suppose what you meant to say was the main idea is to remove the dependency?

Good ideas, thank´s.

I´m a bit uncertain about the "transformation script component".

What do you have in mind?

Most - if not all - security issues are supposedly resolved if Kerberos is implemented.

Which is not the case where I work.

I got your example to work when I'm physically on the server, but when I try it from my workstation, I get:

An error occurred while preparing the query "SELECT...

Handy article, thanks.

One cannot but admire all the brave DBA's out there who have to live with "a constant fear of losing data because of the mistakes of some developer...

Yes. I figured it out eventually.

Thanks & Cheers

PII

Works great, but...

I need to use it in a stored proc where it should look up the foreign keys from a twin DB, let's call it DB1 and create...