Steve,

Thank You for your reply. The purpose for this task is the user can run SSIS Package without any problem or ask IT. SSIS Package is reading the data from...

Thanks ALL for the input and help.

Luis I really apreciate your help. I am sure I am missing something. After I running Sample Query I am getting Error "Invalid Object Name dbo.Tally"

Can You Please guide me...

It's a good question why. Couple of things

1) This is Ad hoc request

2) The system we are using is calculating per visit and a lot of other logics.

I agree...

Sorry for the confusion.

Let me try to explain what I am trying accomplish.

Here is my source data that I am receiving from customer every day in .txt

ID,Fname,Lname,Amount,Visit

1,Smith,D,125,1

2,James,C,145,3

3,Norman,S,121,1

4,Sam,P,111,2

In above data,...

Does this path look good to you?

HKEY_LOCAL_MACHINE==>SOFTWARE==>WOW6432NODE==>MICROSFT==>OFFICE=>12.0==>ACCESS CONNECTIVITY ENGINE ==>ENGINES==>EXCEL==>TYPEGUESSROWS

Thank You.

Thank you for prompt reply, Could you please help me where I can find ACE OLE DB provider?

One more quick question, do I have to change on my local computer...

Set the TypeGuessRows registry setting for the ACE OLE DB provider to 0. It will scan more rows to determine the data type.

Also, make 100% sure IMEX=1 is included in...

Thanks for reply and telling me yes there is a way. Is it possible can you help me to with Query?

and what you mean by make sure about Table and...

Wayn, appreciate your help, quick question

UPDATE MYTABLE

SET INVOICE = WITH cte AS

(

SELECT RowID,

Col1,

RN = ROW_NUMBER()...

if there is third, it should be value-C, if there is fourth, it should be value-D,

and i want to update MY INVOICE FIELD

UPDATE MY TABLE

SET INVOICE = (YOUR CODE)

I...

THANKS FOR YOUR REPLY, I am sorry i didn't understand very well what you trying to say, It would be awesome if you type a sql syntax for me. Appreciate...

Thanks for your reply, I have 60k records or more in my source file, Here is the solution that i just find out through ssis.

ADDR1 = UPPER(SUBSTRING(Address,1,3)) == "C/O"...

Here is the information that i have in my target table

Client_ID, Address,Phone

121,223 Main Street, 451-869

145,458 Jonson Ave, 284-897

121,224 MILLER AVE, 623-3125

Here is the information that i am getting from client...

I am 100% agree with you, My source file doesn't have any Primary Key or unique identifier (It’s a flat file ) but my target table has Primary Key, I...