Hi guys, M. Smith here.

I have two questions, please help me.

(a) Tell me What is the difference between THROUGHPUT and TURNAROUND TIME?

(b) Also tell me that What is the difference between statically linked and Dynamically Linked executable files?

Thanks.

Hi,

My name is B.Lie and I am a student. I am a bit confused and mixing the concepts this question. Is it possible that, I have downloaded and installed it, but it is simply giving me command prompt like interface where I can run my commands. But I don't know where to write my c program in Cygwin?

Tell me that Turn around time of a process = waiting time of a process + process CPU bursts Is it right? So please help me in to solve this question. I shall be very thankful to you.

Hi,

My name is M.Smith and doing job in I.T department. But I am a bit confused and mixing the concepts that I had read in the handouts.  To run compiled program, a. out command is used, but if there are multiple programs, then all of them will be stored in a.out file? And how can we run a particular program out of them?

And also tell me that what is the difference between SURE KILL and KILL command?

If anybody understand my question than please solve my problem.

Thanks.

Hi mates,

The Bulk Insert Task in the SSIS is not getting executed and it's displaying an error regarding the execution. I have checked the configurations, it is correct. I have tried many times, but it was giving different errors during each time of execution. I don’t know what is happening with this Bulk Insert Task in SSIS. Please help…..

Thanks.

Hi fellows,

I have an excel file which consist of file name and location path. I want to take those two values for variables in SSIS. For example, in the excel sheet, in the first row, I have entered “file_a” in the first cell and the “c:aa.txt” the file location path. I have created two variables “file_name” and “file_path”. I want those two values in the excel to be assigned to these two variables.

Variable          Value
File_name        file_a
File_path         “c:aa.txt”

Hi,

I have a comma separated data file (csv). I have to load this file to a SQL table using Data Flow task in SSIS. Below is the sample data from the source file.

Id, name, city
1, A, NY
2, B, LA
3, C, NY
4, D, NY
5, E, LA

I want the data where the city is equal to “NY” only to be inserted. Like this,

Id, name, city
1, A, NY
3, C, NY
4, D, NY

I have tried writing a SQL query, but I can’t. One way is dumping all the data into one table and again inserting into a new table using conditions. But the data size is around 20 GB. So it takes more time and large space. Is there any alternate way?

Thanks.

Hi all,

It is a dynamic process in SSIS. I have designed an SSIS package, where it picks up flat files dynamically from a directory and it dumps those source data into the dynamic SQL tables. I passed the SQL table names as variables in the OLEDB destination component. But it was showing the error “task cannot find the target SQL table” something. It is not the exact error message. How can I resolve this issue?

Thank you.

Hi friends,

I have an SSIS package, which consists of a Bulk Insert task. I was trying to pass the source file path as variable in Expression. Actually the source file is located in a server. The path is as follows,

“\servernameab” + @[user::file_name]

I have entered the above string as it is in the Expression page. The string validation is passed in the Expression. But, while executing the Bulk Insert task, it was displaying an error. The error was “The Bulk Insert task cannot find the mentioned path”. I have tried a lot of ways. No luck. Anyone please help.

Thank you.

Hi,

In the Execute SQL task in SSIS, I have written the following insertion SQL statement as the direct input:

Insert into Emp_new(E_Id, E_date, E_time) select E_id,E_date,E_time from Emp_old
where E_date between (start_date) ? and (end_date) ?

I have declared the start_data and end_date as variables with the data type “datetime” in the package. And I have called the variables in the task while running. But it was giving a syntax error while trying to run the task in SSIS. Please help to solve the error.

Thanks.

Hi,