Can you explain what you mean by putting it in the Q statement?

Maybe I did not explain everything.....if I remove the "Where clause" the script works. It is the where...

Thanks All. I am planning on going with the truncation in a view but just wanted to make sure I was not overlooking something in SSIS.

Thanks again, as always, this...

Thanks Steve - You lost me a little:

In the derived column, instead of entering a name, selected the 'replace Name with' option (where Name is my field name) and in...

So the output column was set to 2 for example and it just truncated the names?

Thanks. I just tried this and it seems that regardless I get an error about truncating data. I just want to ignore the truncation. For example if input last name...

Bummer.....I was hoping people would have 'some' ideas.......

Anyone have any thoughts on using 'Control Server' for the user? Pros/cons??

Hi Wayne -

This is the full code with your changes

-- drop the table if it already exists

IF object_id('evCreateUser') IS NOT NULL DROP TABLE evCreateUser

-- create a...

Hi Wayne -no worries, everyone needs weekends away from the pc for sanity reasons! That explanation makes perfect sense.

I posted this to another post but I duplicated a different...

No this did not return any rows either....this is csv from event viewer....I attached the file I use. I just do a bulk import and then the code I am...

THanks Lowell. I ran the code and it does not return any rows. Could it be anythign else?

Hi Wayne -

I also get an error about length passed to substring too long? COuld it be that for a different record type the records are longer?

I was also...

Wayne --

I am stuck!

Here is the code I am running:

-- drop the table if it already exists

IF object_id('EVCreatedUsers') IS NOT NULL DROP TABLE EVCreatedUsers

-- create a temp...

Hi Wayne - I am trying to set up the other record types.

Can you explain what this field does "Pos3-Pos2-15"

SubString(c1.Field9, Pos2 + 14, Pos3-Pos2-15 ----I understand this means start in...

Sorry I realize the forum is removing my formatting......All I want is the 3 fields to return in a fixed length so they line up....... each field (regardless of the...

So no one knows a simple way to do this? All I want is the output to look be lined up:

OUTPUT:

12345 Allen ...