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,

Hi mates,

In OLEDB Source task, I have tried to use the Stored Procedures in the SQL source command. But the task is not producing the expected results in the SQL table. I have tried the same SP in SSMS. It was producing the results as expected. I am not aware of using the SP in OLEDB source command.

There must be some tactic to do this. Can anyone give some ideas as to how to handle the Stored Procedure in the OLEDB Source task?

Thank you.

Hi everyone,

I am trying to perform Merge Join using OLE DB source task in SSIS package. I am trying to process millions of records in the package. But I don’t know why it was taking so much time to do this simple task. Then I checked the log file and noted that it was taking so much time to sort the incoming data. But, I have already used “order by” clause in the SQL source statement for the sorting purpose. Can anyone tell how to improve the performance in this task and reduce the processing time?

Thanks!

Hi,

I am having a problem with my query to the database.

I was using ISQL to do some queries,

When I got this error that says Invalid password: Password is not long enough.

I pasted below the complete screen shot.

Hi,

I was reformatting a computer due to numerous virus. After the operating system was installed successfully, I installed the accounting application. When I try connecting to the database server, an error message appeared. It said unable to connect to server.

Hi all,

There was a catastrophic event that happened in our system. Almost all of our system was down due to infiltration of virus, when the system is up and running.

As I am working with the database for some queries, I meet this error that pop-up my screen, that said table or view not found.

Hi,

I am in our remote office to install a database similar to head office. My installation of Microsoft SQL ended successfully.

I restored the  database into the server.

When I was about to do some queries to input some branch identity, an error message box was displayed in my screen that tells me I don't have any rights.

Microsoft SQL Server Management Studio Express

Cannot show requested dialog.

Additional information:

Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)