Create table #temp

(value int)

Insert into #temp

select 2

Union all

select 2

union all

select 0

it worked..sorry I made a mistake in my syntax.. Thanks!!

Thanks, I got error as

Query (1, 36) Parser: The syntax for '"[Date].[Date hierarchy].[Date].&["' is incorrect.

Cadavre thanks for your solution.. The solution you provided solved some of the conflicts that I'm getting now.. Thanks guys!!!

Thanks!! It worked for me

got solution. i added one more column in the flat source this eliminated the pipe.. now everything is importing without pipe at end

can you provide the solution, basically the incoming field has

0.0

25.0

and i want to replace it with NULL

...

yes i have addrid

Addrid Addr date

...

Thanks for your help i solved the issue..

here im entering dates manaully and i dont want to do that.. is there any solution to solve it?

First, your error message is wrong for your new code. You should be getting 2 errors, not just the 2003 error. And it should be 2009, not 2003, based on...

im sorry for my pervious posts here is what i tried

CREATE TABLE [dbo].[tblsample](

[EmailAddrID] [int] NOT NULL,

[SourceCode] [varchar](4) NOT NULL,

[RegisterTimestamp] [varchar](8) NOT NULL

)

--Data

Insert into tblsample

values('1023027','A','2009-12')

Insert into tblsample

values('1023027','A','2009-12')

Insert into tblsample

values('10230','B','2009-11')

Insert into...

It doesn't help basically i want it to be in.. wether im doing mistake some where in the script?

...

still getting Syntax error as

Msg 102, Level 15, State 1, Line 20

Incorrect syntax near '2003'.

i tried with below query i getting syntax error as

Msg 1033, Level 15, State 1, Line 19

The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and...

i tired in so many ways and im getting error, in my table there are 277 records with different dates like and in nset month i may have 300 records...