@ S.K , WayneS

Thanks for replies.

@S.K

I am quite new to this backup setups...I don't know I decided right or not, but problem is I need to have...

Hi again,

I have some problems in settings now.

I have tested log shipping on same domain and it did work.

Bur for Live I need to setup in different domains and I...

Thanks Ki Chiang & Drawlings,

Drawlings,

Thanks for information and explaining, in my case I am gonna put complete live solution including DSN, Application setup everything will be up but just not...

Thanks..thats what I am looking for , we need to create a passive backup solution so I think log shipping will work.

Thanks again for help

Regards

Thanks for reply!

After reading a lot about everything I am thinking to go with Log Shipping? Can you give me suggestion on that?

Regards

Hi,

Thanks for reply!

No I did not see any other information, when the page open , on which I rendered the report as PDF, it shows this line nothing else.

But same...

anyone have experience about that???

Thanks

Regards

Hi,

Thanks for reply!

I read that article before thanks!...

I am using format file, I did fix it but that's very strange. I did two things, one changed datatypes of fields from...

Hi,,

Are you still there?

I have the same problem now and cannot find solution anywhere. But my problem is I have to use bCP and while BCP it puts the same...

thanks very much,, it did solve the problem,,,I was actually trying only format file to create fixed-width....

Thankyou again....!

Hi,,

This is the command which I am using...with -C switch..which creates

EXEC master..xp_cmdshell 'bcp "select LastName,FirstName,FullName,CareOf,StreetAddress,City,ZipCode,Country from tstDB..tmpperson" queryout F:\Temp\SPAR.dat -f F:\Temp\FormatFileName.txt -C RAW -T'

and this is...

Thanks!

I tried already SQLNCHAR then it puts spaces in between characters but the file still is not unicode..

Regards

Thanks brad.mason5!

I tried by creating proxy which has access to both servers and it worked 🙂

Thanks very much:)

thanks!

Yes I can log in by that user and if I run package from Management Studio it runs.

But when it run as job on specified time it give login error.

And...

I dont know exactly I am new to SSIS and trying to learn.;-)

But it can be problem of credentials but in my case as i said before that I just...