Data diiferentator tools

Hi All,
We have a kiosk application which will be distributed across the states
and connected to network on a cellular broadband connection. Kiosks
transmit records to our central server on a periodic basis.
We use a 3rd party vendor database in kiosks which needs to be updated
once a month. Vendor is not ready to give us a differential database so
we have to write our own utility to do this.
Are there any 3rd party tools available to this or any other
suggestions will be greatly appreciated.
Regards,
SobhanRed-Gate SQL Data Compare (www.red-gate.com)
Amos.
<Sobhan.Vezzu@.gmail.com> wrote in message
news:1150928122.648282.308070@.p79g2000cwp.googlegroups.com...
> Hi All,
> We have a kiosk application which will be distributed across the states
> and connected to network on a cellular broadband connection. Kiosks
> transmit records to our central server on a periodic basis.
> We use a 3rd party vendor database in kiosks which needs to be updated
> once a month. Vendor is not ready to give us a differential database so
> we have to write our own utility to do this.
> Are there any 3rd party tools available to this or any other
> suggestions will be greatly appreciated.
> Regards,
> Sobhan
>|||Red-Gate SQL Data Compare (www.red-gate.com)
Amos.
<Sobhan.Vezzu@.gmail.com> wrote in message
news:1150928122.648282.308070@.p79g2000cwp.googlegroups.com...
> Hi All,
> We have a kiosk application which will be distributed across the states
> and connected to network on a cellular broadband connection. Kiosks
> transmit records to our central server on a periodic basis.
> We use a 3rd party vendor database in kiosks which needs to be updated
> once a month. Vendor is not ready to give us a differential database so
> we have to write our own utility to do this.
> Are there any 3rd party tools available to this or any other
> suggestions will be greatly appreciated.
> Regards,
> Sobhan
>

Data diiferentator tools

Hi All,
We have a kiosk application which will be distributed across the states
and connected to network on a cellular broadband connection. Kiosks
transmit records to our central server on a periodic basis.
We use a 3rd party vendor database in kiosks which needs to be updated
once a month. Vendor is not ready to give us a differential database so
we have to write our own utility to do this.
Are there any 3rd party tools available to this or any other
suggestions will be greatly appreciated.
Regards,
SobhanRed-Gate SQL Data Compare (www.red-gate.com)
Amos.
<Sobhan.Vezzu@.gmail.com> wrote in message
news:1150928122.648282.308070@.p79g2000cwp.googlegroups.com...
> Hi All,
> We have a kiosk application which will be distributed across the states
> and connected to network on a cellular broadband connection. Kiosks
> transmit records to our central server on a periodic basis.
> We use a 3rd party vendor database in kiosks which needs to be updated
> once a month. Vendor is not ready to give us a differential database so
> we have to write our own utility to do this.
> Are there any 3rd party tools available to this or any other
> suggestions will be greatly appreciated.
> Regards,
> Sobhan
>

Data Conversion - NULL datetime causes failure

Hi,

I have a flat file source and am bringing it into an OLE DB Destination connected to a SQL Server 2005 database. Since I am bringing in the data via a flat file, I have a conversion step in the data flow, which uses a "Data Conversion" transformation to convert each column to the appropriate destination data type.

When I run my SSIS package, if the datetime column in the flatfile is NULL, then the Data Conversion step fails. I have my Data COnversion step set to redirect error rows to an error output. So, I get all the rows with populated datetime values in the intended destination, and none of the rows with null datetime values (these go to the error destination.)

This is a problem! I need to make sure all valid rows fall through. It seems very odd to me that a NULL datetime could not be converted to a datetime data type. This makes no sense, since a datetime column can naturally hold NULL, just like any other type. So, my question is: is this a bug? It seems to me it is. I can't believe this would be the desired behavior?!

Microsoft: please let us know whether this is expected behavior. If so, then what would the desired workaround be?

Thanks

Do you have the retain nulls option checked in the Flat File Source?

If you are treating the column as a string in your flat file source, you may need to use a Derived Column transform to handle the conversion. Use an expression like:

Code Snippet

([YourDateColumn]=="")|| (ISNULL([YourDateColumn])) ? NULL(DT_DBTIMESTAMP) : (DT_DBTIMESTAMP)[YourDateColumn]

|||Thanks much - the checkbox in the flatfile source did the trick. Never noticed that before, but it worked great. Thanks again.