Viewing 15 posts - 2,521 through 2,535 (of 3,657 total)
Provided it precedes the tranformation into your txt/xls object it doesn't matter though personally I make it the first task in the DTS.
January 18, 2006 at 2:47 pm
I actually agree with most of the things you say, possibly with the exception of the separating out toilet paper from sewage.
When ever I see a badly designed database supplied...
January 18, 2006 at 2:28 am
In SQL2000 ROWCOUNT affects all actions, TOP only affects SELECT
In SQL2005 TOP can be used with UPDATEs etc.
Joe Celko has warned me that TOP is not valid ANSI SQL and...
January 18, 2006 at 1:23 am
Drag the ActiveX Script task onto your design pane then double-click it.
Copy and paste the code from the post into the resulting code panel and save it.
Select the ActiveX task...
January 17, 2006 at 11:08 am
I'm not talking about the infestation known to MS Access programmers as cascading.
I have inherrited a database whose lookup tables would give DCPeterson apoplexy. The design was done by...
January 17, 2006 at 9:29 am
In general I agree with this article but there is one massive BUT that has been overlooked here and that is performance.
I have a database where the design of the...
January 17, 2006 at 5:18 am
I have a similar requirement for a date changed Excel file. There are several ways of doing it but I put an ActiveX task as the first step...
January 17, 2006 at 2:13 am
Because of the limitations of the FTP task I resorted to using a Windows CMD file to execute the FTP commands I needed and called these using an Execute Process...
January 16, 2006 at 5:09 am
The idea is that you get a performance boost however in most small to medium installations the extra administrative hassle just isn't worth it.
The theory is that searching an index...
January 13, 2006 at 12:00 pm
Our apps are .NET and C++ based so we use NUNIT to devise a long list of test scripts. Come service pack time we simply rerun the NUNIT...
January 13, 2006 at 6:16 am
You should have
an Icon for a server that represents you connection to your SQL Server.
An Icon for your text file that represents you CSV file.
A connecting line between the...
January 12, 2006 at 10:39 am
Are you allowed to change your database recovery mode to BULK LOGGED?
January 12, 2006 at 4:33 am
DTS's can be as simple or as complex as you want.
You can import/export from/to a variety of different sources. For example, I had a datawarehouse that needed to almagamate...
January 11, 2006 at 12:29 pm
Just for the sake of testing change your INSERT INTO query to SELECT INTO TestTable
That way
INSERT INTO MarketRiskdev.dbo.Import_Argentina
SELECT * FROM TestTable
should work. If it doesn't you will be closer...
January 11, 2006 at 12:01 pm
bcp is very fast at extracting or importing data.
As Data Transformation Services suggest they can do just about anything you want to data. DTS includes a specific task that...
January 11, 2006 at 11:57 am
Viewing 15 posts - 2,521 through 2,535 (of 3,657 total)