This project is read-only.

import log into the database

Topics: Developer Forum, Project Management Forum, User Forum
May 5, 2010 at 8:10 AM

Hi

What i have to follow for importing the logs into the database.

 

Regards

Karthikeyan.T

May 5, 2010 at 12:15 PM

Hi.

i have executing the batch file in the import_dataflowprofile.bat it is unable to read the "dtsdataflowprofile flow" file located in the same location.

Log file is given below.


D:\DTLoggedExec_v.0.2.3.0\DataFlowProfile>sqlcmd -S HAD20008 -E -b -i "..\DTLog
edExec.Database\import-profile-data.sql" -v dataflowprofile_path="" dataflowpro
ile_file=""
Changed database context to 'DTLoggedExecDB'.
Reading file ""
Using format file "formatheader.fmt"
Msg 4861, Level 16, State 1, Server HAD20008, Line 5
Cannot bulk load because the file "" could not be opened. Operating system erro
 code 3(The system cannot find the path specified.).
Press any key to continue . . .

Please help.

 

Regards

Karthikeyan.T

May 10, 2010 at 9:55 AM

Hi Karthikeyan

do you already checked this page?

http://dtloggedexec.davidemauri.it/Consuming%20profiled%20data.ashx

You should have the *.dtsDataFlowProfile files to import in the DataFlowProfile directory.