|
|
|
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 SSIS subsystem appears to have been deleted Posted by Chris Wood at 1/31/2007 1:44:06 PM Hi,
We have a weird situation on an SQL2005 SP1 server. If we look in
sp_enum_sqlagent_subsystems we cannot see an entry for SSIS but we have SSIS
installed and running. Is there a way for us to get this subsystem entry
re-added or do we need to re-install SSIS?
Thanks
Chris
...more >>
Dtsx and Fuzzy Lookup Bug ? Posted by glovemtb at 1/31/2007 6:12:14 AM Tools : Sql Server Enterprise 2005 , Visual Studio 2005, SSIS/DTSX,
oledb datasouces SQL Server 2000.
Testing the new tools specifically Dtsx Fuzzy lookup tool here is I
think the bug.
Entering new values into the reference lookup table and even with the
"create new index" option selected in Fu...more >>
File specified in the connection was not valid Posted by Stephen at 1/31/2007 4:20:00 AM I have created a SSIS package in VS2005 that very loads a couple of CSV text
files as Flat File Connections and pumps the data into a SQL2005 table. I am
able to import the package into Integration Services as a Stored Package from
the file system and Run the Package without any problems.
...more >>
DTS and constraints Posted by Leo Selmani at 1/30/2007 2:25:01 PM Is there a way to force a DTS to move to a new record and attempt to insert
it in a table if it encounters records that violate a constraint? Or do not
fail it, instead just ignore all records that violate the constraint and
insert all other records that do not?
Thanks for your help,
Leo S...more >>
SSIS error: cannot convert between unicode and non-unicode data ty Posted by David at 1/30/2007 1:06:01 PM Hello,
In SSIS, I use the import/export wizard to import an Excel file into a
table. When executed, I received the following error: column "XXX" cannot
convert between unicode and non-unicode string data types.
The XXX column in Excel is a text type.
Any insight to this error will be ...more >>
Global Connections in DTS sql 2k Posted by Vick Shaw at 1/30/2007 9:26:27 AM Hi!
How can I use Global Connections in my DTS package.
When I move the package to production I end up changing connection
parameters for every individual tasks. I explored using an .ini file but
didn't quite get it right.
Any help is greatly appreciated.
Thanks a lot.
Vick
...more >>
how can I execute DTS(ssis) without SSIS install on server Posted by zhengj NO[at]SPAM ciac.sh.cn at 1/29/2007 11:56:58 PM I use
Microsoft.SqlServer.ManagedDTS;Package.LoadPackage;Package.Execute();to
load dts(ssis).The sqlserver&SSIS (on server1) not the same sever
with the application(on server2).I load from file type
Package(dtsx),because I want to outport data to a local access mdb(on
server2).
I install ...more >>
Import 2nd half of flat file Posted by Andy at 1/29/2007 1:06:01 PM I have a comma delimited file that has 200 columns in the first half of the
file and 226 in the 2nd half of the file. I need to find a good way of
splitting up the file. I am able to import the first half of the file just
fine by going into the properties and setting Last Row equal to the la...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Importing Into ntext loses data Posted by MattNC at 1/29/2007 11:03:01 AM I am importing a file into a database with a field that is ntext. (I can not
change the type of field in the destination.)The field I am having problems
with contains a lot of text. It keeps getting either truncated or is
completely missing, with no errors. I've tried using both Excel and Acce...more >>
DTS Package fails when Scheduled Posted by Chuck G. at 1/29/2007 6:27:00 AM I am running SQL 2000. I have a DTS that imports an Access database from a
remote source into my SQL server. When I excecute the DTS manually it runs
perfectly, but when run as a Scheduled job I get the following error:
Executed as user: SQLSERVER\SYSTEM. DTSRun: Loading... DTSRun:
Ex...more >>
Dynamically change connection Posted by Jaco at 1/29/2007 4:02:00 AM Hi
I have a DTS package with many Transform Data Tasks. I need to move this to
a new server. Is there any way I can dynamically change it all?
...more >>
DTS run on remote server consumes all CPU on local server Posted by Rea at 1/29/2007 3:13:02 AM Hello eb
I am running a job on one server, which launches a dts
package, that is defined on another server.
This second server hosts also Analysis services,
and that dts package is processing OLAP cubes on it.
This indeed should consume high cpu, but i'd expect it to be
where those cubes exist...more >>
Migrating BLOB and CLOB from Oracle to SQL Server Posted by Lyn Duong at 1/29/2007 2:56:01 AM Hi,
I have created a dts package to migrate some data from oracle to sql server
as part of a data migration project.
Some oracle tables contain BLOB and CLOB data. I created a datasource using
microsoft odbc for oracle and microsoft ole db for sql server as the
destination.
When i try ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |