Search results for query: *

That's the problem I am not really sure. I will have to ask around... Thanks

Thank you for your respone... I need to basically find all of the objects that my companies web site is not using. We are upgrading from SQL 2K to 2K5. So , if a table is not being used at all by the web site, then I need to drop it. Same goes for procs, functions, trigger, etc. I hope this is...

Hello, I need to find all of the SQL Server objects, (tables, procs, functions, etc.) in my database, that my application is no longer using so they can be removed from the system. Does anyone know how to accomplish this? Thank you, Dave

Hello, I wrote a stored procedure in SQL 2K5, and I would like to write to the sql log file when certain steps have succeeded. The only way I know how to do this is by using the raiseerror command, but I am not looking to exit the proc after writing to the log file. Any help would be...

Hello, Does anyone know how to disable or set the timeout option in XP_CMDSHELL? Any help would be appreciated. Thanks, Dave

How do I connect to SSIS through management studio? I was looking for that folder, (or a similar one) in the heirarchy but could not find it... Thanks, David

Hello, I created an SSIS package in Microsoft's BIDS studio and I need to load the SSIS package into the SQL Server. Currently, I have the package saved locally on my HD and when I need to execute it, I either execute it in BIDS or just click the executable package. However, I need the package...

Hello, I am not using Data Flow, I am using Control Flow. Is there a difference in performance? David

Hello, I have an SSIS package that basically truncates all tables in a destination database, (over 250 tables) and reloads the same tables from a different, (yet identical) database. The database size is approximately 8GB. This process is taking over an hour to run. Does anyone know if there is...

Thanks for your response, Where would this "New SSIS forum" be? I cannot find it...

Hello, I have an SSIS package that basically truncates all tables in a destination database, (over 250 tables) and reloads the same tables from a different, (yet identical) database. The database size is approximately 8GB. This process is taking over an hour to run. Does anyone know if there is...

Hello, I have a question... I am using BIDS to create a project that refreshes a test database with production data, and it seems that SSIS has a fundamental problem with dropping and recreating tables in a database, or deleting the rows in a table. Whenever I select drop and recreate tables...

Thanks for your time...

Thanks for your response, Denny. I was afraid of that. The other downfall is that you cannot even use temp tables within a view. I assume you could execute a stored proc through a function?

Hello, Does anyone know how to execute a stored procedure within a sql view, or if it is even possible? Any help would be appreciated. Thank you, David

Hello all, I created a batch file that runs sql scripts in a specific order. The only problem is that the scripts continue to run even after it encounters and error in SQL. Does anyone know how I can stop the script from running when it encounters any errors? Any help would be appreciated...

Thanks to everyone who responded. I created a test database on another server and I loaded 2 packages no problem. I was able to use the same connection and just change the database name. My packageds ran smooth as silk! I do not understand why. We decided to go with BCP anyway. Any ideas as to...

I assume a configuration file, because I am not using variables. Here are the steps I took... 1. I created a new project in BIDS. 2. In the solution explorer I right clicked and added an existing package. 3. instanciated the package and clicked on the Data connection int the data flow task...

Of course. I went through the proper steps of changing the database and the flat file it was pointing to. I am doing this in microsofts BIDS environment. Is there a way to refresh the database connection? It doesn't seem to be picking up the change, and we are looking right at it! VERY...

Thanks for your quick response. I am an admin on both.