Thx All..

This makes whole lot sense

Jay

Hi, Guys..

U guys are really GURUS.....

I have huge data set.. I will test both ways and I will let U know..

And I have a q for 5409045121009.

Would U explain this...

Thx.Markus

That works..

Jay

ThX davidT

It is working..

I used Convert text format..

Jay

Hi, All..

I used this script and worked...

/*****************************

RESTORE FILELISTONLY

FROM DISK = 'f:\test\110602USA.bak'

RESTORE DATABASE USA

FROM DISK = 'f:\test\110602USA.bak'

WITH RECOVERY,

MOVE '"409_dat"' TO 'E:\SQLData\USA.mdf',...

Hi, James

Here is an error message that I got from 'step detail'

What do U think..

Looks like package doesnt make connection..

Jay

DTSRun: Loading... DTSRun: Executing... ...

Hi, James

Thx for advise.. Actually history error didnt help to do troubleshooting...So I set up the schedule again and I got error message saying that This job is invoked by...

OK..

1. Source is SQL Server which is SQL7.0 SP2.

Destination is also SQL server 7.0 SP2.

I created Tb in destination and insert data into that tbl.

2. I used right-click in EM...

Hi,,

I am getting similar error message.. Works fine with manual run but job fails.

I have SQL7.0 SP2 in server as well as my workstation. I read about article that I...

Hi,Matt

I was reading this discussion.. I have a q for U.

Where do U need to get this SSmsLPCn.dll file?

Does setup ask U to replace into Ur BINN folder or U...

Thx..

That really works...

In the code, U missed END after 0 :-)))

Anyway..Thx

Jay

Hi, Andy..

Thx.. it works for this ID but not other ID who doesnt have DA or DB..

I got Null return..

Any other way?

Jay

Here is script.

Basically I create Header first and add Data text file to it. After that I add Trailer info again to that text file.

Here is script..

/*************************************/

Const ForReading=1, ForWriting=2, ForAppending=8

Dim...

Hey..hey..hey

U guys are having a ball without me..

Fill me in.. Kidding..

U know what.. I really grad that I can participate this discussion and I give my thanks to sqlservercentral and...

Mannnn..U are great...

It works liek charm.. :-)))

How did U think about this? I was thinking more like putting some charater string instead of looping through..

Thx

Jay