Search results for query: *

My SSIS package has a Execute Process Task to unzip a file using WinZip This process has the following Executable: E:\Program Files (x86)\WinZip\WINZIP32.EXE Arguments: e -o -j E:\bi_loader_drop\myfile.zip E:\mydirectory This process has worked for years, now it hangs up. When I run the...

I am transferring a client to a new database server. I have reindexed the database. Is there a way to optimize the tables. Can I defrag the data pages some how?

I have a DTS package that use to display the raise error message when I double clicked on the failed step in the dialog box that displays when the job is executing This is a DTS package (not SSIS) that executes several stored procedures. Within these procedures, there are several custom...

I have no idea how to approach this problem I have. Basically, there are four files on a web site. Any time they are replaced with new files, I need to download the files, run an import program and update a table with the new modified dates. The modified dates are stored on the web site. Is...

I have googled and read all of the interview questions and answers posts. I have to take a written SQL test, that's all I have been told. It is for a job doing SQL/Server programming and some administration. I think they may be asking me to write stored procedures, functions and other types...

I cannot set up a data collector because I get an error after the screen were I select my database. The error is value was either too large or too small for a Uint64. The dialog box behind the error shows two logins ##MS_PolicyEventProcessingLogin## and ##MS_PolicyTsqlExecutionLogin## with the...

I am trying to copy agent jobs from one server to another with the schedule and then deactivate the jobs. Does anyone know of a solution or article that explains how to programatically copy agent jobs? Just as I would select multiple jobs then right click and script them out, I would like to...

I want to have a disaster recovery plan that will restore my SSIS and jobs as well. How can I get my SSIS and agent jobs synched up on my disaster recovery server?

I cannot find an example online for a reason WHY you would need a cursor instead of an update statement. Does anyone have an example of a problem that can only be solved by using a cursor?

I have… A iMac and the “Tv Kit” Ohh my! A friend of mine, whom is in the “Mac world”, wants to: 1) View the iTunes interface on his Sony Flat Screen (2 years old many inputs). 2) Listen to the iTunes sound via the Harmon and Kardon receiver (3 years old many inputs) The idea: …to run the...

I have AWE enabled on a SQL/Server. When I go into task manager, the majority of memory is free. Is there any way to make SQL Server utilize more available memory. I checked SP_CONFIG and the memory management tab in server properties. Both are configired correctly.

My servers Page Life Expectancy is frequently dipping below 300. Does anyone know a good strategy for diagnosing this issue?

I have a SQL database hosted through network solutions. I am designing a web site in expression web (next version of frontpage). I can make a form to SELECT data from the SQL database. I cannot find an example or a starting point to INSERT into my table. I simply want to INSERT a new...