The driver named as "SQL Server" was released with SQL Server 2000. It's best to use a driver version consistent with the version of the SQL Server instance, else you...

Approximately the same time every day? I get this in the current shop from monitoring software that uses an old driver against my 2008 R2 instances.

I have not seen that error before, but it does not sound good. Have you run DBCC CHECKDB(your_dbname) WITH NO_INFOMSGS on your database lately? If you run it and it...

The replication subsystem uses Linked Servers to communicate between Publishers and Subscribers.

What I think may be occurring:

The page splits caused by inserts can create less than full pages that are now out of physical order (external index fragmentation) and the deletes...

I suspect you're over engineering this a bit. A good cache manager will handle completely (or mostly facilitate) the monitoring and re-caching of data that has changed. In terms of...

You'll need to store it as a character type (e.g. VARCHAR OR CHAR) to maintain leading zeroes.

But why do you need leading zeroes? If it is a number then what...

Do all the tables have the same schema?

I successfully use the TeraData ODBC driver via an ADO NET Source in SSIS to retrieve data from a TeraData DB. Start by creating an ODBC Data Source in Windows....

komal145 (10/26/2012)

---

Hi friends ,

I have a variable called : Today .I am assigning...

You said it was stopping with an error, but also that it runs indefinitely. The pic says it is running the WMI task, what exactly are you trying to do?

When you see that useless error, is that in the Services MMC?

What do you see in the Widnows Application and System Event Logs when the service fails to start?

I am confident the Lookup Transform can be used to arrive at a solution but here are a couple more options:

1. Load the incoming file into a staging table and...

SSIS will attempt to commit as many rows as are specified in the Max Commit Size of the OLE DB Destination Component. Once you submit a batch to SQL Server...

You should likely have a lot less than 1976. It sounds like you may have let autogrow run wild in the database. Read the articles Gail posted and devise a...