Hi All,

Thanks for your response. As a developer, i would like get the metrics for stored procedure execution.

SQL profiler and other stuff mentioned above replies are not accessible for...

Thanks for your response..

msdb.dbo.sysjobsteps & msdb.dbo.sysjobs is able to access only by administrators and not by developers. Could you please give me some hints to check the procedures dependencies in...

Yes its correct. Job triggerrs the SSIS package and it is scheduled to run every 5 min. For loop task is used in the package to iterate the .dat files...

Currently we are using SSIS 2005 and currently share your thoughts on 2008 as well. Please help me to process the SSIS data files in best way.

Yes , am able to open and save the script .

But not able to build the SSIS package because the below script validation failure.

"Validation error. The task is configured to...

Thanks for your response. .If the string positions are wrong.. It should face this issue always.But am facing this issue inconsistently.. Please advise.

Hi Phil,

Thanks for your quick response.

Similar Data issue am facing in another SSIS package which has Data File Connection with default Header row delimiter (CR-LF) with column delimiter (LF)....

Scenario:

multiple .dat files are placed in the shared location. In my SSIS package, looped the files in the directory and read the files with the data file source and hold...

I would like confirm one more clarification. Actually in my scenario, multiple .dat files are read in fraction of seconds.Is there any possibility of timing issues, which would cause the...

Thanks for your response.

Its is fixed length file and am splitting the data using subString(), to map the data from .dat file to database table columns. Since position of the...