Does "'cause they couldn't be bothered to do t any other way" work for you?:w00t:

It's a by design feature. You'll have to do conversions on it to get it back...

Use an expression on...

ahh that's ok. The government looses CD's with our data on anyway. The details you posted are probably already floating around anyway... 😀

Good luck getting that to work well / reliably. Best bet is to ensure all updates are installed and, not what you wanted to hear, write code you don't need...

Have you tried using: Data flow, flat file source and the lookup component in SSIS?

Where's the screen shot?

ravirobin (1/29/2008)

At my work, other people write file parser in C# to parse this file. I am wondering if this file can be loaded into a...

All SSIS packages are purely XML. Do a text search in the folder or each file for your source table name.

The XML source allows for HTTP requests. Get the XML directly from the source.

There really are no real advantages to using MSDB as a store. Just the steps you laid out above say so.

The best way I find, and many others, is this:

D:

Some reading: A remove duplicates custom component and source code.

http://msdn2.microsoft.com/en-us/library/ms160916.aspx

Might be worth looking into.

Gone are the days of DTS. SSIS is here.

It is very easy to create a package to load Excel. See the Excel source adapter in your tool box. Create the...

I've actually found a much nicer way of doing it: Fuzzy Grouping.

You specify the columns you want checked. Downstream, you have a conditional split when _key_out = _Key_in, it is...

Another way would be to use a script comp. Have two outputs, one for insert rows and one for dups.

In the code, keep a list of rows sent for insert...

Doh. it's simple(ish)

Have two sources, both from the same table.

Under them, add a sort comp. For the left hand side, sort by your key, select Ignore Case and remove duplicates.

On...

Unfortunately not. Like most files created in a windows environment, they are locked once closed and can never be opened again. People have been complaining about this since windows...