Viewing 15 posts - 9,436 through 9,450 (of 13,874 total)
If there is no problem,output would be
C1 C2 C3 C4 C5
NULLUSD1542.5214536xxxx
NULL NULL1542.5214536NULL
EUR NULL 1542.52 14536 xxxx
Great, that helps.
Now my question is: why in the above is there a NULL after...
January 12, 2014 at 11:16 am
sql crazy kid (1/12/2014)
Phil Parkin (1/12/2014)
Columns are not missing here . I have 5 column here ,looks like this.
[Just a sample data ,but this is the format we load]
col1...
January 12, 2014 at 10:57 am
Columns are not missing here . I have 5 column here ,looks like this.
[Just a sample data ,but this is the format we load]
col1 col2 col3 col4 col5
USD1542.5214536xxxx
1542.5214536
EUR 1542.5214536xxxx
What...
January 12, 2014 at 10:50 am
Here is few more details
Backend - SQL server 2008 R2,SSIS installed
OS - Unix Env
We have many process running on unix ,connecting to sql server , BCP into sql tables ,...
January 12, 2014 at 9:57 am
sql crazy kid (1/12/2014)
Phil Parkin (1/12/2014)
Is there any way we can use ssis ?
To do what, precisely?
As you have given no examples of the data which is giving you problems,...
January 12, 2014 at 9:00 am
Is there any way we can use ssis ?
To do what, precisely?
As you have given no examples of the data which is giving you problems, providing any sort of useful...
January 12, 2014 at 8:18 am
i couldn't seem to find a 2008 SSIS forum.
No, there isn't one - at least last time I checked. But there is a generic SSIS forum here which seems to...
January 11, 2014 at 6:16 am
Lowell (1/10/2014)
January 11, 2014 at 5:23 am
sharmili.net (1/10/2014)
why should not use OLEDB cmd since its processing each row..or any other specific reason is there?
That is the reason.
January 10, 2014 at 1:55 am
Inserts are best done using a dataflow.
Updates are best done as a set-based operation - meaning that the OLEDB command is NOT the way to go. One possibility is funneling...
January 10, 2014 at 1:40 am
sharmili.net (1/10/2014)
Hi Everyone,I want to update the table in a database, performance vice which transformation is best to use?
Thanks in advance.
sharmi
"Vice"? What is that?
January 10, 2014 at 1:10 am
harsimranjeetsinghwasson (1/9/2014)
and this result set is used to preparing...
January 10, 2014 at 12:24 am
What would the SSIS Syntax and could you tell me in a little more detail the steps that I take to accomplish this if not too much trouble?
Can you expand...
January 10, 2014 at 12:20 am
dwain.c (1/8/2014)
Phil Parkin (1/8/2014)
January 9, 2014 at 12:47 am
A few tasty techniques in that function Dwain. I have a quick follow-up question for you: as the function does not reference any external tables or views, does 'WITH SCHEMABINDING'...
January 8, 2014 at 10:59 pm
Viewing 15 posts - 9,436 through 9,450 (of 13,874 total)