Viewing 15 posts - 10,366 through 10,380 (of 13,879 total)
...readily consumable data as I've suggested a couple of times now
"Head banging" and "brick wall" come to mind.
November 12, 2012 at 1:42 am
krypto69 (11/8/2012)
Thanks Phil..This is what I have so far...
Is this going to copy only the changed (updated/inserted) record?
CREATE TRIGGER update_delete ON dbo.WSI_T_CUSTOM_BENFIT_RATES
FOR INSERT, UPDATE
AS
UPDATE WSI_T_CUSTOM_BENFIT_RATES_HIST
FROM WSI_T_CUSTOM_BENFIT_RATES
No. Did you read the...
November 8, 2012 at 10:54 am
I did a quick search and found this[/url]. Looks good enough to point you in the right direction, but there are loads of easy-to-find resources out there courtesy of Google.
November 8, 2012 at 10:20 am
farooq.hbs (11/8/2012)
Dyanmic...If it was fixed then i wud have hardcore the table name and insert but it is dynamic
Hardcore table names? I'm thinking your mind isn't 100% focused on ETL...
November 8, 2012 at 7:59 am
Here's another possibility:
declare @t1 table (Id int)
insert into @t1 (Id)
select 1 union
select 2 union
select 3
declare @t2 table (Id int, X int)
insert into @t2 (Id, X)
select 1, 10 union
select...
November 8, 2012 at 2:24 am
justforgroups2004 (11/5/2012)
We ship books - no more than 10 books per box. And Other items (toys, etc.) – no more than 15 pounds per box. Books are...
November 5, 2012 at 11:04 pm
What I would recommend is that you get your package working with a simple design and then just add the rest of the features and refinements one by one, testing...
November 2, 2012 at 9:35 am
Seems like you are maybe not the first to experience this. Have a look here and maybe you'll find some clues.
Was an eval version ever installed on this server?
November 1, 2012 at 3:32 pm
OK, I doubled up on the slashes within the path, and put four slashes at the beginning to indicate the UNC path. My expression evaluates to this.
\\johnson\clientFTP\users\UBM\ATOM\GEN_V2_DAT_ENT_IUXA9_PRE_20121101_888888.txt
I set the connection...
November 1, 2012 at 2:15 pm
SQLCrazyCertified (11/1/2012)
Please let me know if you could help.
Error: 2012-10-31 01:00:14.73
Code: 0xC0000033
Source:...
November 1, 2012 at 2:08 pm
cmcc (11/1/2012)
Didn't work.
Getting this
...is too long. Maximum length is 128.
I use a view for the data, which is short enough.
It's getting the column names output that is causing me...
November 1, 2012 at 9:51 am
dwain.c (10/31/2012)
28.kanikasoni (10/31/2012)
Hi,Thanks 4 ur solution but I am getting error in order clause
Incorrect syntax near the keyword 'order'.
Incorrect syntax near the keyword 'ELSE'.
Incorrect syntax near the keyword 'ELSE'.
Try removing...
November 1, 2012 at 1:58 am
Not that I've tried, but it looks like this will work:
1) Create a File System Task.
2) Change Operation to 'Create directory'
3) Change Use Directory If Exists to true.
4) Set the...
October 31, 2012 at 10:13 am
A very simple Script Task could check whether the folder exists and if not, create it.
Then do your file copy.
October 31, 2012 at 9:35 am
Viewing 15 posts - 10,366 through 10,380 (of 13,879 total)