Elliott Berkihiser (10/29/2012)

---

Re: "OpenQuery does not accept variables" --

This runs fine in my set-up:

Select * from OpenQuery(MyLinkedServer,'Declare @name varchar(50) Set @name=''RemoteDB'' Select * from sys.databases where name=@name')

Note the declaration...

harri.reddy (10/25/2012)

---

my file is like this

TH*4.2*857463*01**20091015*1045*P**~~IS*7564*ORACLE~

i have two table

table : TH

ID TH1 TH2 TH3 ...

bobd125 (10/25/2012)

---

Thank you for advice. In this case it's a flat file. I could start a new thread but since I've got your ear, I ran into...

dwilliscp (10/23/2012)

---

When you run a sql statement, in Server Management Studio, it tells you how many rows and how long it took, how do you get a stored Proc to...

I...

Just a quick note on this. If you can avoid using the SORT transformation, I recommend that you do - it's a blocking component and...

sdhanpaul (10/22/2012)

---

Im doing it in sql server 2005...management studio express

I used the nested subquery method in ms access before and it was slow.

You need to post ddl ( create tables...

That's fine, glad to help. Good look with the automation.

Please help us by posting the info which Sean itemised.

If you take the time to do that, someone on this forum will post a working solution within an hour, I...

24 hours? Get some sleep!!

I think you can do this without using a cursor, but can't be sure without seeing more info about the source. Are you able to provide...

asita (10/22/2012)

---

Thanks phil,

i am also on the same way, i added pk (identity column name rowID1) and i can generate another column with "D:\ssis\" + rowID1 + ".txt"

then here my...

asita (10/22/2012)

---

hi phil

thanks for your response,

just assume

it is a variable or just static d:\ssis\master.txt is the file to update path to each row

and then D:\ssis\individuals is for all body...

Where does the target file name come from?

Yes it can be done. Have a look here for some pointers.

I'm assuming that you are using a flat file source and not SQL Server? Otherwise there may be a...

If you check BOL for BCP (see here), you'll see that it can take a table, a view or a query as an argument. But not a proc.