I agree, there may be problems with mapping your datatypes.

Please provide a more detailed example (i.e. keyfield, full datatype on textfile, full datatype on database)

~PD

Hi,

The For Each Loop Container in SSIS is actually reaaaaally simple.

Here is a simple guide:

a) Create a dataflow task.

Specifiy any one of the excel files you...

Hey Matt,

Having delivered my very first end-to-end SSIS component, a lot of things I would have thought there would be tons of readups on simply do not exist.

I had issues...

I just got the book by Brian Knight and it is extremely helpful with the more advanced stuff.

I havent gotten to the building custom components step yet, but from what...

Hey,

What I meant is the actual type(i.e char(200) or varchar(200), is it nullable, is it unicode)?

Can I make a small suggestion? Why dont you set your SQL side to be...

Hey,

I found a posting on Conchango explaining when the mail task simply wouldnt suffice, with a valid alternative.

http://blogs.conchango.com/jamiethomson/archive/2006/07/03/SSIS_3A00_-Sending-SMTP-mail-from-the-Script-Task.aspx

Hope this helps

~PD

I found a great posting while working on something irrelevant, and immediately thought about your posting on Nulls.

http://ssisblog.replicationanswers.com/2007/11/24/retain-null-values-vs-keep-nulls--which-to-use.aspx

This may provide you with a little assistance as to which...

Buwahahahahaha

Imagine selling csv burgers at the next microsoft launch....

c - chips

s - soda

v - viennas

Maybe we have a hit here that will feed a lot of developers and make them...

Hey Jan,

Anything you can do in vb .net you can invariably do in SSIS vb .net, all about importing the correct library (or so my resident .net guru assures me...

Does your destination field allow nulls?

There was a posting not so long ago on if you get blanks, that SQL uses the default (I think something like 1900/01/01).

You need to...

Hi,

Dont quite understand your question?

You want to check for the date in a string in the database? Why dont you strip out the date prior to doing this in SSIS?...

What are the datatypes on your source and destination, and what are the datatypes you are using in SSIS?

SSIS is very finicky about datatypes

Hey Satish,

On the job history, click on the expand (+) button, and look at the history for the specific step.

Looking at the history for the job isnt going to give...

What you may also consider doing, is as following.

In BIDS, right click on your project name and select properties.

You will notice there is a Deployment utility section. On this section,...

Great posting Michael.

Quick question though, is a column derivation a lot slower than T-SQL when comparing for changes?

For example, I have a table with about 15 fields that I am...