Viewing 15 posts - 1 through 15 (of 16 total)
My company has a product called BI Documenter that will document your SSIS projects.
Check it out and let me know what you think
_______________
Convert DTS to SSIS | Database Documentation | SSIS Performance | SSIS Monitoring
August 26, 2010 at 8:52 pm
Is there any more information available about the error?
_______________
Convert DTS to SSIS | Database Documentation | SSIS Performance | SSIS Monitoring
July 6, 2006 at 9:37 am
The only problem with that plan is it's not a 2 hours drive. It's more like a 4-5 hour drive. Construction...
I do get what you're saying though.
Thanks for the...
_______________
Convert DTS to SSIS | Database Documentation | SSIS Performance | SSIS Monitoring
August 23, 2005 at 2:18 pm
That was actually something we were looking at. If replication wouldn't have succeeded, we were driving it down there. 🙂
Fortunately, in the end, everything worked out.
_______________
Convert DTS to SSIS | Database Documentation | SSIS Performance | SSIS Monitoring
August 22, 2005 at 10:40 am
Exactly! I'm hoping that others learn from my mistakes.
_______________
Convert DTS to SSIS | Database Documentation | SSIS Performance | SSIS Monitoring
August 22, 2005 at 7:47 am
An update on the article. When I wrote this I didn't know why the subscription became inactive. With a little search on google I think I located the problem.
In the...
_______________
Convert DTS to SSIS | Database Documentation | SSIS Performance | SSIS Monitoring
August 22, 2005 at 6:16 am
That's a design decision that should be thought of very carefully. Rolling your own may be the way to go if you do not have time to get to understand...
_______________
Convert DTS to SSIS | Database Documentation | SSIS Performance | SSIS Monitoring
August 22, 2005 at 5:23 am
We get a lot of blocking from one of our departments that manipulate data through access 2000. I believe that it's an application issue.
_______________
Convert DTS to SSIS | Database Documentation | SSIS Performance | SSIS Monitoring
August 2, 2005 at 7:26 pm
Something like this..
CREATE TABLE SSNTemp (
SSN char (10) NOT NULL
)
CREATE UNIQUE
INDEX [IX_SSNTemp] ON SSNTemp ([SSN])
WITH
IGNORE_DUP_KEY
insert into SSNTemp
select ssn from yourssntable
delete from yourssntable
insert into yourssntable
select ssn...
_______________
Convert DTS to SSIS | Database Documentation | SSIS Performance | SSIS Monitoring
August 12, 2004 at 3:53 pm
No problem.
_______________
Convert DTS to SSIS | Database Documentation | SSIS Performance | SSIS Monitoring
August 6, 2004 at 2:29 pm
SELECT @sqlstmt='SELECT * FROM ggg_emp WHERE date_join BETWEEN ' +CONVERT(varchar(10),@start_date-1,101) + ' AND ' +CONVERT(varchar(10),@end_Date+1,101)
should be
SELECT @sqlstmt='SELECT * FROM ggg_emp WHERE date_join BETWEEN ''' +CONVERT(varchar(10),@start_date-1,101) + ''' AND ''' +CONVERT(varchar(10),@end_Date+1,101)...
_______________
Convert DTS to SSIS | Database Documentation | SSIS Performance | SSIS Monitoring
August 6, 2004 at 1:33 pm
Show me your query.
_______________
Convert DTS to SSIS | Database Documentation | SSIS Performance | SSIS Monitoring
August 6, 2004 at 1:29 pm
select userid, max(lastlogin) from yoursimpletable
group by userid
_______________
Convert DTS to SSIS | Database Documentation | SSIS Performance | SSIS Monitoring
August 6, 2004 at 5:16 am
This is assuming that one row at a time is being inserted. If multiple rows are going in, you'll have to use a cursor
create trigger i_tblErrorLog on tblErrorLog
for insert
as
set nocount...
_______________
Convert DTS to SSIS | Database Documentation | SSIS Performance | SSIS Monitoring
August 5, 2004 at 7:17 pm
Have you looked at WITH ROLLUP? That may help..
_______________
Convert DTS to SSIS | Database Documentation | SSIS Performance | SSIS Monitoring
August 5, 2004 at 7:06 pm
Viewing 15 posts - 1 through 15 (of 16 total)