|
|
|
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 Transformation Rollback Posted by Peps at 5/28/2007 6:02:47 PM If I'm importing from a .CSV file into a table and it gets interrupted
or fails to complete the import for any reason, is it possible to
rollback any changes that occured so the table goes back to its
original state? Thanks!
...more >>
VB Script Error Code Posted by Peps at 5/28/2007 5:45:39 PM Hello,
I'm trying to write a vbscript that checks to see if a file exist
before kicking-off a DTS import and I wanted to know the following:
How can I have the script return a Successful or Failure execution?
This will help me determine whether the rest of the DTS continue or
stop immediate...more >>
DTS - SQL Task "Recive" 2 event isn't running Posted by pelegk1 at 5/27/2007 3:39:00 AM have a dts which has 2 path's that come to the same "Sql Task".
i dont know why but when i remove one of the arrow's with event
like success/completion everything works great!
but when i have 2 "event" that come to this "SQL TASK" they sql like skip it
and all the step's that follows!!! (i see...more >>
DTS via ASP page (passing global variables) Posted by Red at 5/25/2007 1:47:50 AM Hi,
Im trying to set up an ASP that will trigger a DTS package. Have seen
the example on sqldts.com:
http://www.sqldts.com/207.aspx
And I can get his working OK. How would one alter this code to
include any globals variables that I want to pass to the DTS package?
Thanks,
Red.
...more >>
DTS Package and Blocking Posted by jdaly NO[at]SPAM brickmua.com at 5/24/2007 6:19:50 AM We have a DTS package that runs twice a day. this package gathers data from an AS400, FoxPro for DOS, and 2 other sql server instances and the data is used for reporting purposes through Crystal Reports.
If a report is requested with invalid parameters, a Lock Mode of IS (Shared Intent) is made ...more >>
success, failure, completion constraints on data flow task don't w Posted by Steven at 5/23/2007 12:01:01 PM i've got an ssis package that includes a data flow task that runs
successfully. however, none of the subsequent tasks will fire, no matter what
kind of value i attach to it (ie success, failure, completion).
i've even tried changing the evalution operation from constraint to
evalution and e...more >>
SS Import/Export Posted by JesusLuvr at 5/23/2007 11:45:01 AM Hello, I need to export data from one database to another. One of the tables
in the destination has an extra column which is a identity column. How can i
inset an incrementing value into this column. This column does NOT exist on
the source side.
Thank you,
David...more >>
DTExec slow Posted by DC at 5/23/2007 7:02:47 AM Good day,
when I execute a simple DTS package from DTS Designer in Visual
Studio, it takes 5 Seconds to execute. The same package lasts about 50
seconds when I start it via DTExec in a stored procedure. I can see in
the verbose output of the package, that it must have done nothing most
of the...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
ActiveX Script Task Properties window not showing properly Posted by CAD Paul at 5/23/2007 2:36:04 AM I have been using dts packages for some years then suddenly, yesterday, the
ActiveX Script Task properties window changed. I can no longer see the code.
This page does not allow me to paste a pic so I will try to describe what I
see.
Normally there is a top line showing the ActiveX task icon ...more >>
SQL Job owner Posted by Jack at 5/23/2007 12:41:01 AM Which login runs the sql server jobs: Is it the login defined as owner on the
job or is it the login defined on sql server agent. Thanks
Jack...more >>
Conditional WorkFlow Posted by Bob McClellan at 5/23/2007 12:00:00 AM I have an SSIS package that emails a spreadsheet exception report.
Naturally, I only want to send it, if there are exceptions.
What can I use to query for the exception and only allow the workflow if
Count(exception) > 0
thanks in advance,
bob....more >>
unable to send excel file as attachment Posted by idelsoq NO[at]SPAM gmail.com at 5/22/2007 5:57:17 PM I have this package that exports data to an excel file. At the end of
it I have an On Success workflow leading to a Send Mail task that is
supposed to send the excel file as an attachment. I keep getting a
message saying that the Mail is unable to open file. Apparently the
connection stays open ...more >>
DTS and process task - doesn't wait my called exe application finish completely Posted by teixeira1985 NO[at]SPAM gmail.com at 5/22/2007 8:50:28 AM Hi,
I need to execute a DTS that have a couple of steps and one of them is
a process task that simply call an exe file i made that will send an
email to warn the user.
What happens here is that the process task executes my exe file but it
doesn't wait for it to compete and fires the next ta...more >>
DTSInstall.exe Posted by C at 5/22/2007 7:34:00 AM I have used above exe to Install my DTS Package in SQL Server 2005.
An entry is created in the sysdtspackages90 table.
2 Questions:
1)Where in SQL Server 2005 should I be able to see the Package itself?
2) If I want to run it manually, when I double click on the dtsx file on the
Database S...more >>
OLEDB Destination Error Posted by F_clef at 5/22/2007 7:23:04 AM Hi
I'm using SSIS to bring data from one SQL 2005 db table to another. They
both have SP2 installed. The destination table has six nvarchar(max) fields
which are converted from nvarchar(4000). When I run the package in debug
mode I get the following error: "Expected the TEXT token in da...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |