July 13, 2010 at 5:19 am
Hi
i m runing error log-file(Text format),when i run the package the log event information storing in log file .ok
when run second time log information storing next to previous information.Now my requirements are
1) I want to truncate old log event information and store the latest one.
2)I want to create log file dynamically when ever i run the package it should be create new text error log file based on date wise.
How can i do this,any help that's great
Thank u very much
sank
July 14, 2010 at 1:54 am
Hi i have created second one( create log file dynamically by using script task date wise), now my problem is how to point the log file to txt file which was created by script task
any help thats gr8
sank
July 14, 2010 at 4:58 am
To create Dynamic txt file
"C:\Documents and Settings\projects\Desktop\logfile1"+right("0" +(dt_wstr,2)month(getdate(),2)+right("0"+(dt_wstr,2)day(getdate(),2)+(dt_wstr,4)year(getdate())+".txt"
any thing wrong this expression?,becoz when add this one to error log file connection manger it is throwing error like "property value is not valid"
plz help me
thanks in advance
sank
July 14, 2010 at 5:10 am
Hi,
Try Log event in SSIS...
u also use script component to write logs...
dim x(0) as byte
ME.LOG("MESSAGE",0,x)
Regards,
Gayathri 🙂
July 14, 2010 at 5:43 am
Could u plz give me steps how to do with script component,my requirement is to create new log file every day, for that i have write down above expression.
sank
July 14, 2010 at 5:54 am
Hi,
Try this link
http://www.sqlis.com/post/The-Script-Component-as-a-Transformation.aspx
in ssis, insert script component as transformation between ur source and destination.
if u know C# or vb.net/vb.. u can write ur own code...
Regards,
Gayathri 🙂
July 14, 2010 at 6:38 am
Sorry i never use script component, even i don't no the .net coding, any other why i can create?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply