hi vasant,

try execute this command from the query analyser

Select * from linkedserver..databasename.table_name

or linked servername.databasename.dbo.tablename.

if u able to get the result set, then u can use the same in the stored...

Hi Vasant

You can try using linked server concept.

i.e., create the list of servers which you want to access in the linked server and then you can pass that server name...

Thanks for your reply.

I want to know how SQL server internally handling this number, does they have any system table? (like sysobjects,sysindexes,etc.,)

Hi,

Try this

EXEC master..xp_regread

N'HKEY_LOCAL_MACHINE',

N'Software\Microsoft\DataAccess',

N'Version'

Thanx for your inputs.

Hi,

You can use the dynamic properties task to define the txt file dynamically?

check this out!

http://support.microsoft.com/default.aspx?scid=kb;en-us;280102&Product=sql

Thanx for ur suggestions. Let me check with him.

Hi,

I feel the answer should be :

BCP reports no errors but the data is not loaded.

because we never mentioned -Sservername while loading the data.

bcp.exe accounting..Accounttmp c:\input.txt -n -Uusername -Ppassword...

Arhens,

Sorry i made a mistake, forget to save the changes after following ur instructions. Now it is working perfect. Thanx again.

Arhens,

Thanx a lot for your reply. I tried the way u asked to add the parameter in Execute SQL Task, but still i'm facing the same problem. Trying running the...

Thanx for the article. But when i tried to create this template, the table created in master database instead of DEMO_DB. Could u explain abt that in detail?

Thanx again.

Thanx

The answer what mentioned is wrong, when i tried creating database with autoclose turned on, i'm able to create the database(thro' EM).

when transaction opened in model, then i can't...

Good One. I learned new stuff. thanx a lot

balaji