Who is online?
0
guests and
0
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: NULL
324 results found
BULK INSERT - Format File (skip column)
« 1 |2| 3 » In my previous post I've shown how to bulk insert a csv file through T-SQL. In that example I've used the same structure to both csv file and destination table. In this post I'll show you how to bulk insert a file wich struture dif
Author:
marcoadf
Date: 1/18/2012 Section:
Blog
tags :
bulk
,
bulk insert
,
column
,
csv
,
fieldterminator
,
file
,
firstrow
,
flat
,
fmt
,
format
,
identity
,
identity column
,
insert
,
lastrow
,
rowterminator
,
Server
,
skip
,
txt
,
view
BULK INSERT - Identity Column
« 1 | 2 |3 » This is the 3rd and final post about BULK INSERT. In this one I want to show you how to bulk insert a file into a table with an identity column. Here is the script to create table: CREATE TABLE [dbo].[Users] ( [UserID] int IDENTIT
Author:
marcoadf
Date: 1/21/2012 Section:
Blog
tags :
bulk
,
bulk insert
,
column
,
csv
,
fieldterminator
,
file
,
firstrow
,
flat
,
fmt
,
format
,
identity
,
identity column
,
insert
,
lastrow
,
rowterminator
,
Server
,
skip
,
txt
,
view
Task Factory Null Transform
Nulls. Seems like they are the universal headache among all data based projects. Trying to clean up nulls in SSIS is certainly doable, but not without some work with expressions. An equal headache to null values are blank values. In most cases, you’ll eit
Author:
arcanecode
Date: 7/9/2011 Section:
Blog
tags :
Null Transform
,
SQL Server Integration Services
,
SSIS
,
Task Factory
SQL Server 2012 - SSIS - New functions
As in my previous blog posts, I've been posting some new features in SQL Server 2012. In today's post, I would like to show you new features in SSIS. One of them is the left function wich till now you had to use substring to achieve the same result. These
Author:
marcoadf
Date: 3/16/2012 Section:
Blog
tags :
2012
,
integration services
,
LEFT
,
new features
,
REPLACENULL
,
Server
,
TOKEN
,
TOKENCOUNT
MDX Handle Dividing by Null or 0 Gracefully
If you ever created any calculations in your cube or in an MDX query that uses division, you've probably run into the issue of dividing by zero (0) or NULL. Dividing by 0 or NULL will show the ugly -1.#INF when browsing your cube from Excel. But being the
Author:
DustinRyan
Date: 2/22/2010 Section:
Blog
tags :
-1.#INF
,
Divide by Null
,
Divide by zero
,
MDX NaN
,
MDX
Dealing with time duplicates
You could try something like this. First, let's set up a test table to look like the top 2 datetime values in your staging table: IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Datalog_stage]') AND type in (N'U')) DROP TABLE [db
Author:
KeithHyer
Date: 7/22/2011 Section:
Forum
tags :
duplicates
,
ranking
,
ssis
Suggested SSIS 2005 Transformations for Data Quality Auditing
CREATE TABLE [dbo].[EnctrAPR]( [EncounterNumber] [varchar](50) NOT NULL, [MedRec] [varchar](50) NULL, [AdmitDate ] [datetime] NULL, [DischargeDate ] [datetime] NULL, [Age ] [varchar](50) NULL, [Disposition ] [varchar](50) NULL, [DRG ] [varchar](50) NULL,
Author:
schilders
Date: 10/4/2012 Section:
Forum
a query to assign the condition
Asmi28, I too would need more information. From what you have so far, I think you're looking for a SELECT with CASE statements. My guess is something like the following. Without more information, I cannot say this is the answer for sure. SELECT CASE WHEN
Author:
KeithHyer
Date: 10/28/2011 Section:
Forum
tags :
case statement
,
NULL or Empty
,
query
Split Comma delimited column Problem
Hey Tooba, I think one of the issues is that you aren't handling NULLs. I also think that some preliminary "catches" would be useful to simplify your expressions. If I am understanding your goal correctly, you are trying to output something like this? (mi
Author:
kylewalker
Date: 3/16/2011 Section:
Forum
tags :
derived column
,
ssis expressions
The CASE of the missing non-
NULL
T-SQL Error: None of the result expressions in a CASE specification can be
NULL
.
Recently, while doing some data scrubbing for a customer I got an interesting error in SSMS with one of my CASE statements. The error received was: None of the result expressions in a CASE specification can be NULL. It was a long T-SQL script (and a long
Author:
JoseChinchilla_SQLJoe
Date: 11/16/2011 Section:
Blog
tags :
case
,
case statement
,
Error
,
sqlserver
,
syntax
,
T-SQL
SSRS Nulls in a Matrix
In a recent SSIS class one my students ask me, if you are reporting off a table and using it in a matrix, does the matrix show null rows. The answer is yes. Here is an example table and the resulting report. This is the table used. All rows were selected
Author:
MikeDavis
Date: 7/14/2010 Section:
Blog
tags :
Matrix
,
Null
,
SSRS
Replacing Null or Blank Values In SSIS With Task Factory
In my last blog post, I wrote about how easy it is to replace unwanted characters in ssis with task factory. This week, I'll be discussing another common request; replacing null or blank data from an SSIS source. Again, this task was built to save develop
Author:
ChrisRock
Date: 3/27/2011 Section:
Blog
tags :
replace empty strings ssis
,
replace null values ssis
Showing Measure values as either ‘0’ or ‘
NULL
’ in Cube ?
Hello BIDN Family, It been long time and I really miss BIDN family group network ,after a long time gap I would love to post this blog which might be helpful to the one who works in SSAS. While designing a cube everyone simply doesn’t care about the
Author:
Anil
Date: 4/9/2012 Section:
Blog
When
NULL
equals
NULL
Use the lookup transform to fill in NULL values
Author:
mcape
Date: 5/29/2012 Section:
Article
tags :
lookup transform
,
NULL
How nulls affect Data Mining
I recently wrote an Article on how to create a data mining Model and Structure. I wanted to show how nulls will affect the same mining models. This is using the identical mining model and data as my previous article except I have inserted nulls into the n
Author:
MikeDavis
Date: 10/1/2010 Section:
Blog
tags :
Null
,
Data Mining
SSIS Expression Help
tooba said: "NULL"? [COLUMN_B] : [COLUMN_A] ( still red on derived column ) Need help to fix this issue, I want to know where i am wrong. Tooba, I believe you are trying to check if the value is null, then use a or b, depending. You need the expression to
Author:
m3crast
Date: 3/29/2011 Section:
Forum
tags :
case
,
Derived Column Transformation
,
if
,
iif
,
derived column
Ignoring Zero Values When Finding an Average in SSRS
Last week, I was writing reports for a client who wanted to see averages for particular columns. The problem was that some of the rows contained zeros and he did not want that factored into the average. To fix this, I had to make a change to the query. I
Author:
ShawnHarrison
Date: 3/22/2011 Section:
Blog
tags :
Average
,
Expressions
,
NULL
,
SSRS
Properly Cast a Null String
There are a few circumstances in SSIS that you need to do some things that don’t really have a good explanation but are necessary to keep BIDS happy. For example, if you use the NULL function when creating a derived column, you must also CAST it even thou
Author:
timmurphy
Date: 7/11/2010 Section:
Blog
tags :
Null
,
Cast
Script transformation giving Object reference not set to an instance when it encounters a blank field from my flat file
Pragmatic Works also has a component for handling transforming NULLs columns in an SSIS data flow in their "Task Factory" product. Here is a link for more info: http://pragmaticworks.com/Products/Business-Intelligence/TaskFactory/Features.aspx#TSNull I've
Author:
KeithHyer
Date: 3/1/2012 Section:
Forum
tags :
NULL handling
,
pragmatic works
,
task factory
SSIS SQL Query for changing source table format
Hai guys, I need some help regarding Sql Server,i have a table like this in my database,the data from this table i need to load into fact lable. this is Staging table CREATE TABLE [dbo].[S_Fin_Spinning]( [Serial] [int] NULL, [Particulars] [varchar](255) C
Author:
Saraswathi.msbi
Date: 10/16/2010 Section:
Forum
tags :
SSIS
Alter table
If you script out your table, you should see your extended properties below the table creation portion. You should be fine by scripting table, dropping and recreating with the new column. I just tested it using the below script below. Added table with two
Author:
briankmcdonald
Date: 7/19/2011 Section:
Forum
tags :
Brian K McDonald
,
extended properties
,
sqlbigeek
,
TSQL
Different Results at each Package Execution
I'm getting mixed results at package execution and am wondering if you can shed light as to why... SSIS 2008/win 7 3 source files: FF_CSV 75000 rows, Access DB 74620 rows, Access DB 21,671 rows 3 data conversions all pipe into 1 Union all - total rows: 17
Author:
JohnG
Date: 1/3/2011 Section:
Forum
tags :
Access DB
,
Conditional Split
,
CSV
,
SSIS
SSRS Report Catalog Path
This has a few loops in it ( not cursor, but a WHILE loop ) - but it might do what you're after: NOTE: The contents of the ReportPaths table gets modified with this method - so make sure if you use this method, you're using a COPY of your report paths tab
Author:
KeithHyer
Date: 10/25/2011 Section:
Forum
tags :
CHARINDEX()
,
REVERSE()
,
SUBSTRING()
Cube Design
I am not sure I understand exactly what you are asking but I will try to answer. First, make sure there are no nulls in your data. If the value is zero make sure it is zero and not null. Second. Create all the dimensions and ensure they have the proper co
Author:
MikeDavis
Date: 2/2/2010 Section:
Forum
tags :
cube
,
dimension
,
fact
,
measure
SSIS Assistance using a conditional split operator to evaluate
NULL
's
CSV files can't recognize NULLs the same way SQL Server does so I'm pretty sure nulls are always going to appear in a CSV file as an empty string. All of the NULL functions I've tried to apply to a field coming out of a CSV file get an error. I think you'
Author:
kylewalker
Date: 8/16/2011 Section:
Forum
tags :
CSV
,
NULL handling
Page 1 of 13 (324 items)
<< Prev
1
2
3
4
5
6
7
8
9
10
11
...
Next >>
Go to page:
[Go]