|
|
|
June 2003 July 2003 August 2003 September 2003 October 2003 November 2003 December 2003 January 2004 February 2004 March 2004 April 2004 May 2004 June 2004 July 2004 August 2004 September 2004 October 2004 November 2004 December 2004 January 2005 February 2005 March 2005 April 2005 May 2005 June 2005 July 2005 August 2005 September 2005 October 2005 November 2005 December 2005 January 2006 February 2006 March 2006 April 2006 May 2006 June 2006 July 2006 August 2006 September 2006 October 2006 November 2006 December 2006 January 2007 February 2007 March 2007 April 2007 May 2007 June 2007 July 2007 August 2007 September 2007 October 2007 November 2007 |
Filter by week: 1 2 3 4 5 Cannot debug script tasks in event handlers Posted by Florence at 5/31/2006 7:01:01 PM We have this issue and have found that we're not the only ones; here is a
quick description from http://www.developerdotstar.com/community/node/334:
This appears to be a bug. I can't get the debugger to stop on a line of code
in a script task in an event handler. Strangely, if I set a break p...more >>
DTS package won't run Posted by David at 5/31/2006 2:44:01 PM Within Enterprise Manager, I created a DTS package on our database server and
it runs fine from computer 'A'. I then went to computer 'B' to run the same
DTS package that is located on the same database server and only half of the
DTS package runs successfully. 5 of my 10 steps get the messa...more >>
DTS truncates Column names to 64 Posted by MDPILWL at 5/31/2006 2:21:02 PM I was told the max column name length for SQL 2000 was 128.
I am trying to create a DTS package to create a table and import data from
an excel spreadsheet where some of the column names are over 64 but under 100
in length but when finished creating the table and importing the data, I look
at...more >>
DTS error-- The system cannot find the file specified Posted by Lynn at 5/31/2006 12:39:02 PM Hi,
I am trying to setup an DTS for other region to run the loading job. From
that user's machine, I can expplor to that directorty (I even use
\\servername\path formoat) and open the file from command line or explore.
But, when I try to open that DTS from Enterprise Manager at that user'...more >>
How many exceptions did I get? Posted by jxstern at 5/31/2006 11:27:03 AM How can I programmatically get a count of exceptions after the data
pump has finished?
Thanks.
Josh...more >>
Row Count task Error forbidden the requested Posted by luna.dave NO[at]SPAM gmail.com at 5/31/2006 5:53:06 AM When I try to use the rowcount component with SSIS I'm getting the
following error message:
Error at Data Flow Task [Row Count [205]]: The component "Row Count"
(205) has forbidden the requested use of the input column with lineage
ID 320
Any help would be appreciated. I have been trying ma...more >>
Usage question Posted by Roy Goldhammer at 5/31/2006 12:00:00 AM Hello there
I have 2 servers.
On server1 there is huge file with approx 100,000,000 records.
On server3 database exist that should get the file.
On server2 the dts with fast load that load the file from server1 and place
it on Server3
on this method, which server do what, and which ...more >>
problem importing a fixed field flat file Posted by Carlos at 5/30/2006 4:16:38 PM Hi all,
I just ran into some problems trying to import different
text files using the fixed field file format tool.
Some of the files get their records truncated. That is
if the first record is shorter than any other records in the file, Teh limit
is set at the end of the first record inste...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SSIS - Flag which processors to use like the database engine? Posted by sqlboy2000 at 5/30/2006 11:45:01 AM We have a 2 processor box that we'd like to install SQL 2005 on. The question
is if we buy a single processor license, can we specify that integration
services use only one processor? I know you can tell the database engine
which processors to use, but I don't see anywhere in ssis to specify
...more >>
SSIS - Preview Derived Column Posted by Jeff at 5/30/2006 11:11:35 AM Hi,
I was wondering if anyone knew a way to "preview" the results of a
derived column in SSIS, similar to how you could preview a transform in
DTS, without actually running the package.
Thanks,
Jeff
...more >>
SSIS creates a crash dump during execution Posted by Sue at 5/30/2006 8:15:02 AM We are having an issue where SSIS dumps during execution. It creates a crash
dump file on the C:\Program Files\Microsoft SQL Server\90\Shared\ErrorDumps
directory. Is there a way to read this dump or figure out why it is
happening? It seems to be intermittent. It happens to me once in a w...more >>
SSIS book Posted by farshad at 5/30/2006 7:53:01 AM It seems that there are only two books on SSIS
The Rational Guide to Scripting SQL Server 2005 - BETA preview
Professional SQL Server 2005 Integration Services by wrox
Has anyone read these or any other ones out there?
Any thoughts on which to get?
I am very new to SSIS.
Thanks
...more >>
SQL 2000 DTS's running via a Scheuled Job Posted by Jon Derbyshire at 5/30/2006 2:11:01 AM Hi,
I have a number of DTS's that are executed each morning via a Scheduled Job.
Sometimes I find that the Job has got "stuck" on a Step (DTS) and does not
"stop" until I manually stop the job myself through EM.
Question is: How can I give my DTS's a Maximum Expected Run Time?
e.g. Job...more >>
Some queries regarding SSIS ETL Development Posted by AMAN at 5/30/2006 12:59:57 AM Hi all,
I am a newbie to SSIS.Need a solution to couple of issues I am
currently facing while developing ETL in SSIS
1) Under SSIS Package Folder I have defined mappings for 17 dimensions.
1st Dimension say Account has been Set up as a startup object.
Now when I run the package ir runs only...more >>
Data Transformation. Posted by Sami at 5/29/2006 4:41:02 PM Hello,
I want to do some data transformation from one Database to another.
My source DB is a MS SQLServer to which I can connect using OLEDB/SQLnative.
My destination DB is a different type of database to which I can connect
using Connection Manager. But for data transformation I need a dest...more >>
Problem with numeric parameter in DATEADD with DTS Posted by EzBulka NO[at]SPAM gmail.com at 5/29/2006 10:29:16 AM I am trying to construct a DTS task which will purge data that is more
than X months old.
So, I have a line in my query that looks like this:
DELETE...
WHERE [dateObj] < DATEADD (month,?,getDate())
I am trying to use a parameter so I can simply set a Global variable to
determine the number of ...more >>
DTS within DTS scheduled job problem Posted by caroline.howe NO[at]SPAM equitant.com at 5/29/2006 9:46:50 AM Hi all,
I'm having a problem with my DTS packages when they are run as
scheduled jobs.
Basically, I have a DTS that calls other DTS packages from within. When
run through enterprise manager, it all runs fine, all internal DTS
packages are called and run successfully.
However, when I set up a...more >>
Organizing Business Rules in SSIS Posted by sebnunes NO[at]SPAM hotmail.com at 5/29/2006 8:41:23 AM Hi All,
I'm pretty new to SQL Server 2005 and I'm wondering how to organize my
business rules efficiently.
I'm willing to create a Package with several Data Flow Task in my
Control Flow, each Business Rule will be encapsulated in a Data Flow
task. I guess this is possible in SSIS but I can'...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |