Recent content by dmando84

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