Viewing 12 posts - 16 through 27 (of 27 total)
Michael,
That worked beautifully. Thank you!
Michael
September 25, 2008 at 9:12 am
I will check that out. Thanks!
September 22, 2008 at 9:23 am
Worked! Thanks!!!!
July 31, 2008 at 9:07 am
OK ladies and gentlemen....a new directive from above.
What I need to do is, if there is an errored line, I need to write it out to a text file, but...
July 25, 2008 at 8:31 am
Michael Earl (7/22/2008)
1) Add two Connection Managers for connecting to your database. I am going to refer to them as "CMData" and...
July 22, 2008 at 8:31 am
Jez (7/18/2008)
You cannot create a workflow between a task and a connection. Select the task and then select (using ctrl) the data pump task to add the workflow.Jez
That did...
July 18, 2008 at 8:18 am
The table structures do match (except for indicies)....but I will try -c instead of -n
March 26, 2008 at 8:32 am
Ladies/Gentlemen,
I ran the following BCP commands this weekend
bcp "select AuditRecUID,TrackingUID,PolicySymbol,PolicyNumber,MasterCompany,Mod,LOB,ContractNumber,AuditType,AuditStep,null as AuditXml,ProcessingSecs,wUser,UserType,SystemTs from DB..PolicyProcessAudit2 (nolock) where systemts >= '1/1/2008'" queryout C:\PPA1\Table.out -T -S PRODDB -n
bcp DB_Archive..PolicyProcessAudit in C:\PPA1\Table.out -T...
March 26, 2008 at 7:25 am
I do not know a whole lot about BCP, can someone maybe give me some sample code that I could work with to accomplish what I need?
Thanks!!!!
Michael
P.S. I am not...
March 10, 2008 at 11:26 am
Thanks all...but it seems BCP and BULK INSERT require the data to come from data files, not an instance of SQL. Is there a way to copy it from SQLA...
March 10, 2008 at 6:38 am
Viewing 12 posts - 16 through 27 (of 27 total)