Viewing 15 posts - 8,941 through 8,955 (of 9,725 total)
The most common function I use in a WHERE clause is a convert. Usually "WHERE Convert(char(10),ModifiedOn,101) = Convert(char(10),GetDate(),101)". Usually because I'm in the middle of a data update...
February 28, 2008 at 11:54 am
Hmm. The flaw with the variable idea is if there are no records yet, even if you use an isnull(max(customerkey),0), it will fail the task as unable to set...
February 28, 2008 at 8:26 am
The mainframe data for customer names is close. Firstname is 10 characters, LastName is 15 characters and they keep middle initials (1 character) that we don't track in SQL....
February 28, 2008 at 8:08 am
You've hit the nail pretty much on the head.
We have two OLTP systems where from our SQL Server we export the data to the mainframe. The mainframe system has...
February 27, 2008 at 6:45 am
Have you looked into transactional replication?
There's also database mirroring that might help you.
February 27, 2008 at 5:56 am
You're saying you got it to work finally?
February 27, 2008 at 4:32 am
Yes, that is correct.
And yes, a customer can have more than one contract.
February 27, 2008 at 4:21 am
Lynn,
That's the problem. The OLTP doesn't have a Customers or Address table. All the customer info is stored in the OLTPContract table.
If I had separate tables in the...
February 26, 2008 at 10:26 am
I should mention, I don't keep AddressKey in the fact table since people can have multiple addresses. Mailing address, street address, etc.
February 26, 2008 at 9:19 am
Lynn,
Here are the create statements (sanitzed). The OLTP table does contain more columns but I'm only concerned with a small few.
Create Table OLTPContracts (ContractID int identity(1,1), FirstName varchar(25), LastName...
February 26, 2008 at 9:16 am
The easiest way to find errors is while you're in BIDS. When you execute a package in BIDS, it throws you into Debug Mode. When you're in Debug...
February 26, 2008 at 8:37 am
That one is pretty simple. You're trying to create something on the 2000 db that 2000 doesn't support. It could be a data type of a column...
February 26, 2008 at 7:40 am
Thanks, Guys.
One of my coworkers found the issue by pulling the fields into a XML datatype variable. It was a hidden character with some bizarre value that...
February 25, 2008 at 7:25 am
And that might be true, but the OP might have meant something different too. So, I'd like to hear from him regarding what he's trying to accomplish to make...
February 22, 2008 at 4:23 am
Ed,
Let me guess. Readers were asking him how much the resource cost. @=)
February 22, 2008 at 4:20 am
Viewing 15 posts - 8,941 through 8,955 (of 9,725 total)