I want to import on a scheduled, and it should ONLY import:

"WHERE trade_date >= '2009-03-18'

Is there a time stamp of some sort that says when the data in that table was imported?

I am importing the data from the MSDB table sysjobhistory, so yes, there...

DONE - Create you new CentralJobHistory table on server of your choice. (S1)

DONE - Create a new login on each of the instances that has read permissions to the history...

Brilliant guys!!!

Let me try!!

Il be back 😉

I have done the following:

Source Data --> DataConversion on Date from Four-byte Single Int (DT_I4) --> DataConversion to Date (DT_Date)

This fails.....Errors:

tblBook, Data Conversion 1 [281]: Data conversion failed while...

WooHoo thanks! I spent about 45minutes editing and messing around with and, and all I had to do was delete it...!! :w00t:

What I have done is import the data from...

OK thanks Guys.

My first import went fine.... It created a table called Query and inserted the data from my other DB.

Now, I want to run the SSIS again, so I...

1. SSIS packages imports data from a flat file into 3 tables

2. The table im interested in is tblClients, this contains 3 columns

Client_ID, Client_Name, Comments

I would like to send an...

Thanks Steve.

I used the import / export wizard and it worked well, BUT

this is somthing I want to run everyday, i.e. its basied on some SQL

Select * from clients

where newclients...

thanks you Sir

Thanks,

Can I put it anywhere at the top?The following is an example of the first few lines:

USE [bookV2]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER OFF

GO

ALTER PROCEDURE [dbo].[AllSector]

AS

DECLARE @FROM VARCHAR(12)

DECLARE @TO...

This did not work

collation is: SQL_Latin)General_CP1_CI_AS

Thanks all for your input.

1. No error messages but no results retuned...

2. The column is set as Trade_date (SmalldateTime,Null)

Yes that works, how do i get it working with:

WHERE trade_date = '2009-03-06'

The date format is the same on both Servers...