That's a much better solution, thanks John. <Phil heads for coffee break>

You mean this column?

[datatype] [nvarchar](151) NULL,

Seems an odd choice. Also, this column is nullable and therefore cannot be a PK.

Here's a long-winded way - nothing better comes to mind right now.

Please provide set-up data in future - you'll find that people are more willing to help if you do...

What is the PK of this table?

I agree, and no setting that I can think of right now. Just goes to emphasize how important it is to get your pipeline data types in order.

And surely, if...

Using serializable should do the trick in your example, I agree.

OK, I might know what's happening.

Your screenshots are for the destination, not the source.

So your column comes in as string(100), goes through the SSIS pipeline unhindered and then out to...

If you add a data viewer after the source component in the DF, you should be able to verify whether the data has already been truncated (and therefore whether SSIS...

Is the data which you provided the desired output, or is it the base data?

Whichever it is, can you also provide the other part?

Apologies for not taking the time to read your original post thoroughly enough!

Can you not emulate exactly what the...

Why not use an IDENTITY column for this?

Or create a SEQUENCE and use that.

What are you displaying this in? Excel/SSRS and similar tools offer formatting options to take care of this for you.

SSMS is a query tool, not a presentation tool.

Is this what you're trying to do?

INSERT #RailCarCycle
(
    RailcarID
   ,StartDate
   ,StatusID
)
SELECT rccy.RailcarID
      ,rccy.LoadDate
  ...

My response was based on this comment by you:

I do have a work around,...

I do have a work around, from server S3 i am using a execute SQL task and passing net use along with user name and password, there on all the...

• This reply was modified 6 years, 10 months ago by Phil Parkin. Reason: Fix typo