DTS Package - Global Paramter of type Date does not contain millliseconds

Question

Hi,

I have a DTS package. I read in a DateTime value from my database which I use to select the records to be transferred via a Transfom Data Task.

However the millisecond component of the DateTime is not stored. I need to store the exact DateTime including the millisecond component.

 

Does anyone know a way around this problem?

Answer 1

From where you are calling the data from VB Script or SQL Script Task.. need more info

 

Answer 2

Sorry I'm an SQL begginer.

 

I have a DTS pacakage I created in SQL Enterprise Manager.

The first step in the pacakge ia an Execute SQL Task.

The SQL code is a simple : SELECT [DateTime] FROM table1

This returns one DateTime value.

Column is  of Data Type : datetime,     length: 8

 

I store this DateTime in a Gloabl Variable.

 

I then use the value in the next step to step the records to import from another database.

 

What I am attempting to do is this:

In another database a record is stored with a DateTime value.

The first time I run this DTS package I  want to import all the records.

The next time I only want to import the new records - I was going to use the DateTime value to select which records to import.

 

The problem is though that the millisecond component of the DateTime value is not stored.

 

e.g.

 

The SELECT [DateTime] FROM table1 statement returns the value 2006-11-30 08:58:49.273

But when I  use the global variable its value is 2006-11-30 08:58:49

 

- it has lost the millisecond component causing records already transferred to be transferred again.

Answer 3

If you want simple solution then you can use the following query to store the datevalue into global variable..

SELECTConvert(Varchar,[DateTime],121) as  [DateTime] FROM table1

Answer 4

 

That works perfectly and is really simple.

 

Thanks a million for you help!