Here is the link which helped me to easily solve the CSV reading file and spliiting issue..using a simple RegEx solution 🙂

http://blog.offbeatmammal.com/post/2005/11/16/Using-a-RegEx-%28Regular-Expression%29-to-read-a-CSV-%28Comma-Seperated-Variable%29-file.aspx

Thanks in Advance 🙂

Any other CSV parser code specific to SSIS Script component ?

yeah, i'm working on that workaround also........

can you give me a script where i can split the input buffer string based on column delimiter [;] with giving preference to Text...

I tried with above mentioned setting and other possible different settings , but still i get the same error

Time Out.

any help is appreciated

Thanks for the info,

Do you know in any way can i specify the "Named Pipe' as the protocol for DTS migration wizard source connection in BIDS ?

Thanks for all your...

I assume you are connecting from SSMS 2005? Is TCP/IP enabled on this Server?

Yes i'm using SQL Server Management Studio 2005 for connecting to SQL 2000

No TCP/IP is not...

Here is the error message details:

TITLE: DTS Migration Wizard Error

------------------------------

Failed to connect to server 10.128.10.59. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

ADDITIONAL INFORMATION:

Timeout expired. The timeout period elapsed prior to completion of the operation or...

Here is one more update,

In SQL 2005 , if i choose "Named piper" as network protocol its successfully able to connect to the SQL 2000 server.

but if i choose "both...

Thanks a lot....

after setting ByPass Prepare to TRUE it worked exactly fine as you mentioned.

last time i missed that one..sorry it was my mistake.

and again thanks thanks a...

Yahoooooooooooooo !

After Setting "Bypass Prepare" property to "True" it executed succesfully....thanks a lot.

can anybody know why its happening? without that why it won't work?

after working for some time , i was able to find that

parameters passed to a query will work fine

but parameter passed to a Declared variable was giving syntax error...

After setting result set to None , the hard coded query worked fine but not variable mapped query.

any idea why variables are not mapping ?

Instead of Variable Mapping i tried with hard coded values like below, but still i got differenr error , :

IF (SELECT COUNT(*) FROM MASTER.DBO.SYSSERVERS WHERE SRVNAME = 'TEST') >...

I tried with the same with out success

Here is the result :

[Execute SQL Task] Error: Executing the query "DECLARE @LINKEDSERVERNAME VARCHAR(8000), @server VARCHAR(8000), @USER VARCHAR(8000), @PASSWORD VARCHAR(8000), @DATABASE...

I have followed the instructions as mentioned by you.

but now i'm getting error as "The EXEC SQL construct or statement is not supported."

when i click on the build query...