Viewing 15 posts - 646 through 660 (of 1,082 total)
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 10, 2008 at 7:49 am
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
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 10, 2008 at 7:27 am
Thanks for the reply 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 9, 2008 at 7:57 am
You could use a union ALL
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 9, 2008 at 6:17 am
with out identity_Insert, I'm not 100% sure how to do it, sorry, I'm hoping someone else can help you 🙂
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 9, 2008 at 4:51 am
Are wanting to insert the values of Col1 & col2 or just col2 and then get new values for col1 upon insert?
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 9, 2008 at 4:39 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 9, 2008 at 4:14 am
Thanks Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 8, 2008 at 10:28 am
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)
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 8, 2008 at 10:02 am
will you columns always end in ',' ?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 8, 2008 at 9:56 am
Do I need to the create in the OLEDB DAtasource object as well as the EXEXUTION TASK, which is before the Dataflow?
Thanks
Chris
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 8, 2008 at 2:17 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 5, 2008 at 10:35 am
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',...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 5, 2008 at 10:31 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 5, 2008 at 9:45 am
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...
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
September 5, 2008 at 9:38 am
Viewing 15 posts - 646 through 660 (of 1,082 total)