Viewing 15 posts - 9,436 through 9,450 (of 13,876 total)
You've been a member of this forum long enough to know that you need to provide DDL, sample data and desired results in a consumable format in order to get...
January 13, 2014 at 2:27 pm
Lempster (1/13/2014)
Phil Parkin (1/12/2014)
Your error message suggests that you do not have the correct (or any) version of SQL Server Data Tools (SSDT) installed - please check that. It's not...
January 13, 2014 at 10:05 am
ducon (1/13/2014)
January 13, 2014 at 8:42 am
polkadot (1/12/2014)
January 12, 2014 at 10:43 pm
Thanks for getting into deeper
Few of the rows , first column coming as empty . But do you think in SSIS or Excel this will be a issue as there...
January 12, 2014 at 11:47 am
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
Viewing 15 posts - 9,436 through 9,450 (of 13,876 total)