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.

Nothing built in.

But have a look here [/url]for a comparison of different ways to achieve this.

Your Excel column is holding mixed datatypes, so you'll need to bring in the column as string and add IMEX=1 to the Excel connection string (Google it for details).

sqlstud (10/10/2012)

---

Well it sort of depends on what you want. You currently have a datetime column but obviously "DECLINED" isn't going to work there. If you want to keep your...

Yes, this is harder than you might think. PSEXEC is what I have used in the past.

I would guess that the worksheet is called something other than 'sheet1'. Find out what that is and change the connection info.