|
|
|
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 can't import from XML schema Posted by zk_ at 10/12/2007 4:23:00 PM I am trying to import XML data trough external XML schema file. The schema is
valid and I was able to create relational database based on it.
When importing XML data through SSIS, I get an error message saying that
schema contains invalid characters /, \, . etc. The reason, my schema has
dot...more >>
Customized Message on DTS schedule Posted by Kayda at 10/12/2007 12:00:00 AM Hi:
I have scheduled a DTS package (SQL Server 2000) and it is able to
send an email upon completion. However, I would like to customize the
subject and message body of that email. For example:
MyDTSPackageName Failed at 10/8/2007 9:43 a.m.
Body:
MyDTSPackageName Failed at 10/8/2007 9:43...more >>
PInvokeStackImbalance in Custom Component UI Posted by Jason at 10/11/2007 11:06:01 PM Hi,
I am developing a number of SSIS Source, Task and Destination Components and
have just started adding custom UI's to them. The UI's work as expected
accept in one way. While debugging if I right mouse on the component the
debugger pops up and I get the following error.
PInvokeStackIm...more >>
Running two Steps at the same time Posted by Chris at 10/11/2007 8:36:00 PM Is there a way to run two DTS steps at the same time? I need to speed a job
up that kicks off a DTS package and in the DTS package there are many steps.
None of them rely on each other to finish, except for one at the very end,
but I can speed it up if I branch off a few steps to run at the sa...more >>
Dynamic config files in SSIS Posted by Stephanie at 10/11/2007 2:44:02 PM OK, my frustration level is extremely high right now. I have a package that
is reading a .dtsConfig file. When I use the wizard it puts the entire path
of the config file in the property i.e. c:\demo\demo.dtsConfig. To make this
more dynamic I went in to the XML view of the dtsx package and...more >>
Data Transformation to Excel Posted by Rob at 10/11/2007 10:44:49 AM I have an existing dts package that exports some data to an excel file.
In the transform task, I had "created" the destination table structure (it
creates it as tablename$).
Now I want to change it. But when I try to change it by Creating it again.
I get a message stating that it already...more >>
Using (local) in dts connection string Posted by binder at 10/11/2007 5:21:03 AM I have a number of dts packages that were developed on a test server
and I need to move to the live server to execute. They all reference
the server in the connection string as (local). I get "access denied"
errors when trying to run on the live server. I have to change (local)
to the actual ser...more >>
DTS SQL 2000 Global Variable initialization problem - please help Posted by jason.essebag NO[at]SPAM gmail.com at 10/10/2007 9:12:37 PM Hi, I have an issue with my DTS and I need some help.
My global variables seem to keep the same value since the last
execution.
This is a problem for me because I need to rename a part of the file,
so the part that is not changed from the original still remains in the
new name.
Example
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
How to change the owner of the source/destination tables within a preexisting DTS package Posted by Alex Castillo at 10/10/2007 5:14:07 PM Hello.
Running MS SQL 2000, we designed time ago a couple of DTS packages to move a
lot of data from one database to another. Later after, we had to change the
ownership of those tables, and we changed Servers (also ServerNames) as
well.
Is there an easy way to move the DTS packages to t...more >>
Skipping bad data? Posted by lwidjaya at 10/10/2007 2:59:01 PM I'm trying to import data from a Lotus Notes database (*.nsf). In the middle
of importing I got this error:
Error at Source for Row number 3333. Error encountered so far in this task:
1. [Lotus][ODBC Lotus Notes]Data value is not a valid date, time or timestamp.
Is there a way to skip the ba...more >>
State Machine - how to jump/GoTo various tasks/scripts? Posted by Todd Beaulieu at 10/10/2007 10:27:05 AM In the old days, I'd disbale tasks up front and then at runtime decide which
task to "goto" and enable it and then mark it for execution. This allowed me
to maintain a "state machine" wherein even a restart could determine where
the package left off and continue execution at the right "branch"...more >>
SSIS Configuration Password issues Posted by Cillian at 10/10/2007 8:13:01 AM Hi there
I'm hoping someone can give a pointer as to issues I am having regarding
SSIS configuration. I have developed an SSIS package which extracts data
from an iSeries IBM machine. The configurations I am storing in a SQL table.
I have loaded the package into the MSDB on Development w...more >>
Scheduling a DTS job Posted by ¤j¬Ó at 10/10/2007 12:00:00 AM Hi,
I have migrated some DTS jobs from SQL2000 to SQL2005, migration was easy
and straight forward but I can't schedule it to run.
Can someone pls show me how to do that.
Thanks in advance!!
...more >>
Export logic from integration services to stored procedures Posted by david.leiva NO[at]SPAM gmail.com at 10/9/2007 4:16:13 PM Hi,
I'm involved in a project working in a SQL Environment, let's call it
SQLDB. We have to integrate in a single database data extracted from
two different sources: Source1 and Source2.
We don't have direct access to manage the execution environment and we
have been told that we cannot use...more >>
Access to connection manager Posted by ktrock at 10/9/2007 9:44:08 AM Hello, I have a very simple situation where I want to pump data from a source
SQL Server to another. If the data isn't available in the source then try
another source which has the same exact structure. This code from SQL 2005
BOL is supposed to allow me internal access to my connection manage...more >>
SSIS Task development. Updating VS2005 GUI Posted by Jason at 10/8/2007 11:34:01 PM Hi,
I am developing custom SSIS tasks and components. One of my tasks create
Global Variables, Connections and a Log provider. When the code in the Task
creates these they are available but the IDE does not display them. If I save
the package and re-open, sure enough they appear exactly as ...more >>
How to schedule a SSIS job, dynamically? Posted by B NO[at]SPAM ns at 10/8/2007 9:48:00 PM Hi,
We are trying to schedule a SSIS package as a job in the SQL Agent.
However, we need to schedule the job dynamically.
There is no fixed date (or period) when this job runs.
Is it possible to dynamically schedule the job?
The next execution date can be stored in a databas...more >>
Import CSV and update existing conflicting existing record(s) Posted by Eugene at 10/8/2007 12:54:01 AM Hi all, I am new to DTS and I need to import a CSV and save the data to and
existing table. Based on primary key, I would need to filter/update any
existing records. How can I do this?
Many thanks in advance.
Eugene...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |