|
|
|
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 SQL Server 2000 to Oracle IMPORTANT Posted by Ken at 9/7/2007 10:42:03 AM Hi Everyone -
I have the latest version of SSIS/SQL Server 2005. In my package, I have a
data flow task w/an OLEDB Source and an OLEDB destination. Nothing else.
The source is a table on a SQL Server 2000 database and the destination is a
table on a Oracle 9.11e database.
I have verif...more >>
Dynamic File Name for Email Attachment Posted by nemo at 9/7/2007 3:43:37 AM hi
I must send emails every month with dynamically named files as attachments.
The files are named according to the date on which they are generated.
For example on the first of November 2007, the file will be named myfile_1_11_2007.
I have created a variable called DynamicFileName with pack...more >>
Read the Registry in DTS Posted by simon NO[at]SPAM otr-tech.com at 9/7/2007 2:06:36 AM Hi
Can you use DTS to read the windows registry on a server via one of
the connection?
Thanks
Simon
...more >>
Importing Excel files with columns > 255 chars Posted by S.Kumar at 9/6/2007 1:24:00 PM I created a SSIS package that imports an Excel file that has columns with >
255 chars into a SQL table.
I am getting error "Text was truncated or one or more characters had no
match in the target code page"
For Excel Source Output I tried changing the type for External and output
columns to...more >>
SSIS use loop to set dynamic global variables Posted by Rmoore at 9/6/2007 8:30:03 AM I need help converting some existing ActiveX script to use either the Foreach
or For loop task. I have a sproc that returns one row containing a dynamic
list of column names and values. I want to use that resultset to create
global variables in the SSIS package with the assigned values. All of...more >>
Running DTS from SQL job fails Posted by jlmjr at 9/6/2007 8:28:02 AM I have a DTS package in SQL 2000. It executes a Microsoft Access file(mdb)
which moves some data into SQL for me. The package then does some other
stuff. When I execute this package from Enterprise Manager, it all works
great. I then made a SQL job to run the DTS package, and it won't run ...more >>
How to import if different lines hold different sorts of data? Posted by Stefan at 9/6/2007 7:38:01 AM I want to create a DTS package (SQL Server 2000) to import order data from
an external source. An order consists of Header data for the whole order
(OrderID, customer info, payment info, etc) and detail data for the purchased
items (OrderID, LineItemID, Sku, item name, price, quantiy, etc).
...more >>
Run DTS 2000 Package on a remote server Posted by Coop at 9/5/2007 5:44:02 PM I have a SSIS package on a SQL 2005 server. From within the SSIS package,
how do I trigger a DTS package on a remote SQL 2000 server to run on that
remote server, as oppossed to importing the 2000 package and executing it
locally on the 2005 server?
Thanks....more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Import to SQL Server 2000 using DTS via MS Access 2000 Posted by Roman Moore at 9/5/2007 3:30:00 PM Using a client/server setup with MS Access 2000 over SQL Server 2000, client
machines are unable to import. The error is "ActiveX component cannot create
object."
I have followed the instructions on "Enabling SQL DMO Clients Without
Installing the Client Side Utilities"
(http://support.m...more >>
Creating CLR Assembly to Execute SSIS Package from Stored Procedure Posted by George Durzi at 9/4/2007 4:27:22 PM Hi All,
I have a requirement to execute an SSIS package from within a stored
procedure. The package needs an incoming parameter, and from what I've
seen, I can't do this in T-SQL.
I wrote a simple c# class that uses the
Microsoft.SqlServer.Dts.Runtime objects to do this. I am able to
execute...more >>
Priamary keys missing after DTS from 7.0 to 2005 Posted by willjay at 9/4/2007 10:17:14 AM I am finally getting around to upgrading from sql 7.0. I installed a new
2005 express server for testing and am trying to use DTS wizard to move the
old 7.0 database to 2005, but when the tables transfer it strips out primary
keys and a few other things. Anyone know how to keep that from happen...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |