Thats no problem at all, just adds a challenge 🙂

About the steps that you mentioned is that done with a sequence container?

If so does each package call need to be...

Hi Brandi,

I wanted to thank you a lot for going out of your way to help me on this 🙂

It was a great help 🙂

Thanks again

Chris

Thanks for the reply 🙂

You could use a union ALL

with out identity_Insert, I'm not 100% sure how to do it, sorry, I'm hoping someone else can help you 🙂

Are wanting to insert the values of Col1 & col2 or just col2 and then get new values for col1 upon insert?

Thanks

Chris

Is this done using a script?

If so then you could name all the columns you inserting into that way it won't try and insert into the identity column.

e.g

INSERT INTO table1

(col1,col2)

SELECT...

Thanks Chris

HI there,

Here is my solution but I have a feeling there is better one I'll keep working at it:

DECLARE @tmp VARCHAR(100)

SET @tmp = ',ad,af,ag,ah,bb,'

SELECT SUBSTRING(@tmp,LEN(@tmp) -

PATINDEX('%,%',REVERSE(LEFT(@tmp,LEN(@tmp)-1)))+1,

PATINDEX('%,%',REVERSE(LEFT(@tmp,LEN(@tmp)-1)))-1)

will you columns always end in ',' ?

Do I need to the create in the OLEDB DAtasource object as well as the EXEXUTION TASK, which is before the Dataflow?

Thanks

Chris

OK looks like it's falling like everyone else said cause one or more of your fields don't include date values.

I'm def gonna go with the fact that the execution plan...

Am I missing something?

when I run this I get not errors:

CREATE TABLE #test

(

Name char(10),

Value varchar(60)

)

INSERT INTO #test VALUES('DateTime', '8/29/2008 10:28:39 AM')

INSERT INTO #test VALUES('DateTime', '8/27/2008 11:40:39 AM')

INSERT INTO #test VALUES('DateTime',...

my two cents:

This is what I use:

/*

Specify values for template parameters

CTRL+SHIFT+M

*/

DECLARE @vcTableName VARCHAR(100)

SET @vcTableName = ' '

select '[' + name + '],' as [USED FOR SELECT/INSERT]

from syscolumns...

thanks for that. very interesting I must say.

The only time I can think that the view would be slower would be if you call a view with loads of underlying...