Ok I did get some work done.From flat file connection manager > output 1[Table A] > output 2[Scrpit Component] based on http://blogs.conchango.com/jamiethomson/archive/2005/08/08/1969.aspx.From Scrpt component > to ERROR table.Now when there...

To my thinking, if there is a mismatch of data type coming in from input table.The SSIS package would fail.Therefore I would need to just find a way to move...

Thank You Matt....Tried with "###,##0" & works fine....

Never thought of that:Wow:

My SELECT COUNT(*) does return a "0",when the column has no records.

Tested in SSRS[data tab] and Mng Studio.

Problem arises when the value of dataset is displayed in a textbox, where...

Thank You

Your explanation is very detail and I hope others can also benefit from it.

I am going to use the information to prepare for my 70-431.

Wish me all the...

Hi Jeff,

Thanks for your answer.Any reason why Bulk Insert ?

A friend of mine was asked a similar question on the choices made between [Bulk Insert & Flat File Connection Mng]...

Look for Microsoft Visual Studio 2005 in your Programs.Once opened.

1) Select File > New Project

2) Ensure Business Intelligence Projects is selected in Project Type.

3) Choose Integration Services Project in...

Thank You All for your response.

I am going to start preparing right away.No more wasting time. 😀

Anyone out there can answer this question for me ..Thank You !

1) I read about many comments on the flaws of MCTS_Self Paced Training Kit by Microsoft Press and purchasing...

I have added this code in report properties> code [to validate startdate > enddate]

Function CheckDateParameters(StartDate as Date, EndDate as Date) as Integer

Dim msg as String

msg...

Now I know what Execute Process Task does.Let me get my hands dirty with it.Shall post my ouput soon.Thanks

😀 -----SOLVED !

Hi ,

I wrote a sql query to replace Date records which are NULL and empty to a

default value.And then performed my data conversion on DT_Date in data...

Thanks for your reply. It really works well now. Thanks again:D

I have tried converting the column to

DT_DBDate / DT_Date / Dt_DBTimestamp.But no luck !

This is an example of the value of column Date in Table A > '11/20/2007' [varchar(50)]

I...

1.Is the original for this specific fields are empty in the source?

2.Why do you want it to NOT be Nulls?(most of us prefer Nulls in empty fields)

3.What do you want...