I was doing my case study and when I was about to print it, I got frustrated that I could only print a single copy at a time and I had to turn it off and on to print another one. I am using the Canon Images Class mf4270 s/cp/f. The trouble with this, is that the default setting is stuck to 2-sided printing. The field of Copy Setting default reads ''OFF'' for 2 – sided printing while the shortcut button constantly reads ''ON'', which means 2-sided printing is to be done.

I hope someone can help me out with this.

Hello there,

I have a SAS 9.2 OLAP installed on my Windows XP computer. I have an OLAP cube containing sales data of all sales agents in our company including me. When I was trying to access my user id, I get stuck into this error message.

The application encountered an error verifying the following statement:

CREATE SESSION SET

[TransactionsCube].TEMPORARYNAMEDSET AS

{[Dim SalesPerson].[All Sales People].[SUB::SAS.Userid]}

Hi friends,

I have tried to use Row Count Task in SSIS. I just want to count the incoming rows and to save the count value in a variable. I tried all the possible properties and options in this task.  It was hard for me to configure this task. It was always giving an error in the Editor page itself. Please help me to configure and get the desired results.

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,