thanks a lot mtassin... I was doing this earlier little differently and was failing due to line comments (--comments)... but used it again using ur logic.. it works. This is...

Each line of sql text of Proc is in different row... sorry by master I meant main database and not master db

Sure Parthi. Thanks!

Thanks Parthi this is what I had planned to do... I convinced my lead that we do not have to use bitwise... I am on the track now. Thanks again.

Thanks for the response... I dont have code, but this is what I have to do...

Say I am createing a Proc with 5 input parameters

TestProc (@VendorName, @LoadDateStart, @LoadDateEnd, @FileType, @Database)

@VendorName,...

Anyone here has experience with bitwise operation? Thanks for the time.

Thanks Jeff I will check that option.

yes that we can do and I guess we can create the tables with relevant data also using the dynamic sql.... I have planned to do this, but was checking...

Is there a way through sql proc to script the table and db from original database and use that dynamically to create a database for the company using the new...

Nevermind guys.. this is fine now... I used an interim table to insert record in and then used that table to export. It worked fine.

Ok this is working fine now... the main issue was the WHILE loop... I constructed it wrong and it did not loop enough times to export all the files. THanks...

jeff.mason (7/19/2010)

---

If 7986011679 is an account number, then I think this may be your problem. Your input query is going end up being

SELECT * FROM Dev_Adhoc.dbo.Bank_Data_Source where ACCT_NBR=7986011679

and without...

All the data in tables are in varchar... seems like export is trying to change the varchar to int and the number is out of bound for int datatype... anyone...

But I am using varchar for every field... does the bcp try to export the data in int format if they numbers?

Gunjan check this out

http://www.sqlservercentral.com/articles/SSIS/68025/

You can use the script to get dynamic filename and use that in forloop... not exactly you are looking for but this can do the...