Athar

You can use an expression to set the connection string for the file connection manager.

John

No. Both outputs look exactly the same to me. Most people don't have the time or patience...

So that we don't have to guess, please explain exactly what you are trying to do. Phil has already asked one question. What are your source and destination,...

We don't have all the information we need. If the source and destination were both tables in databases on the same server, then that's exactly how I'd do it....

If you only ever will have the three account types, then you can do this in the code:

INSERT INTO MTable (Account_Code, Account-type)

SELECT Account_Code,

CASE LEFT(Account_Code,1)

WHEN '1' THEN 'Asset'

...

I'm not sure I understand. What difference does it make to the app owner how you get the database to the new server?

John

You should consider using the MERGE statement. The syntax is complicated, but it removes the danger of cardinality errors that can occur (unreported) with the UPDATE...FROM construction. These...

I don't know of a way to do it in T-SQL without modifying the definition of the procedure, but I think you can do it in SSIS with an ADO...

In the editor for the OLE DB Source, choose SQL command for your access mode, and simply type in the query that will filter out the rows you don't want.

John

Damn! I always try to remember to read through before posting, but usually fail.

John

Mahesh

This will provide a starting point for getting the definition of your table:

SELECT * FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = 'MyTable'

ORDER BY ORDINAL_POSITION ASC

You should be table to build a CREATE TABLE...

Thanks Paul. Seems to be a very partisan discussion. I think I'm on...

Point taken, but however the database engine handles it internally, it's the physically last value that persists. That's what I was trying to get across.

John

This is because you're trying to access a variable called "E:\BINDU\TEST.NEW1.20110707.txt". Surely that is the value of the variable, not its name? I need to see how you're...

I prefer to use standard SQL if everything else is equal. I'm not so bothered about whether it's portable, but it's easier to maintain and less likely to be...