|
|
|
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 DTS reports success but missing a record Posted by donsql22222 at 10/27/2006 10:57:01 AM Is it possible that a DTS job reports success, but isn't?
I created a DTS job and saved it. The query was:
select * from table where date >= '20061024' and insert the results to a
table on another server of identical stucture and name that had no records in
that date range.
I then went...more >>
Export to Excel - File not created Posted by Jeff Reese at 10/26/2006 6:31:02 PM I'm using SQL Server 2005. I've built a DTS. Essentially it does this:
Create a table and insert data
Delete an excel file
Export the table to Excel
In BI Dev studio, the package runs just fine and everything works perfectly.
However, when I run it with the SQL Server Agent, the table i...more >>
ActiveX Converting Zero Length Strings to Nulls Posted by rmcompute at 10/26/2006 4:33:01 PM In order to test the data from the source file, I changed the DTS load job to
use an ActiveX script instead of just a copy. I noticed that data with a
zero length string are getting converted to nulls and this is causing an
issue. There is nothing in the command which tells it to do a conve...more >>
SSIS slows to a crawl & thousands of processes still open Posted by John F. at 10/26/2006 1:18:02 PM Hi - I think that we may have an issue with our isolation level or
transaction commits in our main load package. Basically we get zipped flat
file extracts for 94 districts, then we enter a container that bulkloads
about 300 tables for each district received, loops back and then after all
d...more >>
How to identify the DTS package that is used in the SQL jobs Posted by John Jayaseelan at 10/26/2006 7:54:47 AM Hi,
How to identify the DTS package that is used in the SQL jobs?
Thanks
*** Sent via Developersdex http://www.developersdex.com ***...more >>
Passing Parameters to an Execute SQL Task in SSIS Posted by michael at 10/25/2006 1:31:03 PM I just can't seem to pass a parameter (or get one returned) from an Execute
SQL Task object (using an OLE DB connection).
I thought that it would be as simple as defining a variable at the User
level in the variable window. Then, map that User variable to another
variable in the properties ...more >>
Not Run Posted by The Other Mike at 10/25/2006 10:09:53 AM I have a DTS that is not executing any of the steps. They are not disabled
and checked to run on the main thread but they come up as not run. I
running Sql 2000 sp 4.
Thanks
Mike
...more >>
Importing Empty FIle Posted by Phil at 10/25/2006 1:14:01 AM Hi,
I wonder if there is a work around for the following problem, I have a DTS
pack that imports a number of uploaded files as well as files that show
errors that we have had in the files that we have uploaded. The DTS works
fine when there are errors listed in the Error file but wont work...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
SSIS and ODBC Connection Woes Posted by Dazza The Fat at 10/24/2006 9:03:32 PM Can anyone tell me how I can get an ODBC connection from the Connection
Manager window into the Control Flow or Data Flow windows?
I have 3rd party ODBC drivers that are essential to gaining information from
our non-SQL systems in order to create data warehouses for AS cubes. I can
create ...more >>
DTS Transfer Job Fails Posted by dondraper40 at 10/24/2006 4:58:02 PM I have an SA credentialed connection for both the source and destination
server. Both servers are SQL Server 2000 standard. The job fails with an
"unspecified error" which obviously is little help. I know it is connecting
to both servers as it even shows me which jobs are already present on th...more >>
Sybase/Sql server Outer Joins, nulls, and counts Posted by dba_222 NO[at]SPAM yahoo.com at 10/24/2006 1:33:43 PM Dear Experts,
I'm an Oracle guy, but I've been given an assignment to compare data in
two different Sybase "databases".
Given that I don't have the MINUS, or the INTERSECT command, and in
this Sybase version, not even the inline views, I am trying to use
Outer Joins.
Now, in Oracle, when...more >>
Primary key error handling SSIS Posted by PRW at 10/24/2006 3:11:02 AM Hi,
Attempting to load data from a flat file into a SQL Server 2005 db. using
the Data Flow Task.
However, some of the data contains duplicate records, throwing up an error
on the PK constraint.
I hoped that SSIS would be able to handle this using the new inbuilt Error
Handling.
However,...more >>
database refresh??? Posted by Barb at 10/23/2006 12:48:02 PM Hi,
I need to refresh the database1 in TEST. In an other word it has to be
restored. I have a database file database1.db. Do you know how a can proceed
from Enterprise Manager?
Thanks
Barb...more >>
Transfer data from DB2 to SQL Server Posted by taraernst NO[at]SPAM new.rr.com at 10/23/2006 11:57:04 AM Hello. What is the best way to transfer data from DB2 to SQL Server
2000? Any feedback is appreciated!
...more >>
Dynamically Export to Excel. Posted by dbhagwat NO[at]SPAM gmail.com at 10/23/2006 10:31:50 AM Hi,
I am trying to query the database and based upon which I have to
generate multiple excel files as per the number of users. I am planning
to use DTS...and I think activex scripting needs to be done. Does
anybody have any sample code which I can look at?
Also, the filename for the excel s...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |