No. I just wrote an update query.That's all

Perhaps header row is also inserted as data row into tables.As that C# program begins from -1 there'll be 1 row difference.

Excel 12.0 ACE can handle both .xls and .xlsx files

you can use script component instead. I think that is next better option to script task based on what you said.

what is that validation you are using? you can use derived column transformation to perform some validations like length of column, likewise.. More info can help

Use SQL task Expressions to run your sql statement within foreach loop.

Eg:

Insert into "DestServer."+"DestDBName."+@User::EachTableName values select * from "SrcServer."+"SrcDBName."+@User::EachTableName

You can use unpivot transformation and row count transformation to get this done.

Perhaps you can try using open DTS Package Task in SSIS to edit. I'm not sure though.

That idea by Dan should work.

Just create one column in flat file and use script component to split each row based on column delimiter. That should work.

Thanks folks. I used Excel Interop dll reference and read each excel cell to get this done.

Well, I cannot save it into other file formats. I know, if I have fixed column names(Headers) in excel file then that would work. My file has no columns(Header). That's...

Exactly!! That's what I've done for Flat File and CSV File, putting all columns data under one column and split using a script component. However, I do not have an...

you can also try an else instead of another "When" clause, with a proper cast

Ok. Here it is

CREATE TABLE [dbo].[test](

[a] [numeric] NULL,

[date] NULL

) ON [PRIMARY]

GO

ab

11981-08-14

21985-10-03

32012-04-13

select SUM(a) from test group by b having b=CONVERT(date,GETDATE())--This returns nothing

select SUM(a) from test where b=CONVERT(date,GETDATE())--This returns NULL

Pls...