MSSQLTips

Hi, I want to trnasfer data from one database to another at regular interval. This should be also automated. Example: Database A and Database B Both database are identical. I want to transfer data from Database A to Database B. So everytime if there is any entry in Database A it should also make that...

I have a scenario. I have an Oracle DB as source in whihc Employee table with 1 million records are there. Also there is another employee details table which stores the extra details about these 1 million employees. I already Have 10K employee records in the SQL DB (Destination DB) employees table. The...

So I have this package that I designed to import data from an Oracle Database to a SQL Server 2005 table to feed an HTTP Endpoint. I then follow the tip below which I believe will be a very elegant way of implimenting a "new" idea in the enterprise. SQL Server Integration Services SSIS Package...

BK, I would check out these tips: Deploying a SQL Server 2000 DTS Package vs. a SQL Server 2005 ... Deploying SSIS Packages tutorial and example Using XML Package Configurations with SQL Server Integration ... SQL Server Integration Services Tutorial - http://www.mssqltips.com/tutorial.asp?tutorial=200...

We currently have a development machine that is running developers enterprise edition and a production machine that is running standard edition. I have noticed that there are roles on the enterprise edition that allow me to run SSIS packages but they do not exist on the standard edition. Is there any...

One of my colleagues griped about SSIS Raw files recently, so I thought I'd quickly post the link to Simon Sabin's viewer for his and anyone elses benefit. http://sqlblogcasts.com/blogs/simons/archive/2007/01/11/SSIS-Rawfile-viewer---now-available.aspx Enjoy!

Hi, I have created one SSIS package, which is running fine in my local system. But when I am scheding the same package in production server. It is throwing "Login failed". It's not retaining the source and destination password. Please help me.

I am new to SSIS and I have been given the task as below and I was given 2 days to finish: I have scenario in this fashion: Import Excel sheet data to SQL Server database: - Create a Contact table with the same structure/ columns mentioned in the excel dotnet_consumer_workbook_v_6_0 - Create Contact_Modified...

I am facing a problem in MSSQL: - I have a table in MSSQL, which has 10 rows & 5 columns. In this table I am maintaining a numeric range in 2 columns. First one has starting number & second column has end number. All rows have unique values in these 2 columns. For Ex.: - In first row the value...

Hi All How do I convert the below code to work using VBscript in SQL 2005.Please help urgently if you can. This code was used in Access database and sometimes it was giving Errors. Function ImportFile() 'change the name of the constant to the report/table imported Const conINPUTTABLE = "TSM83D"...