|
|
|
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 report cause of failure in SSIS Package to event log Posted by urs.eichmann NO[at]SPAM gmail.com at 6/14/2006 11:46:20 PM Hello,
I'm running SSIS packages in the night with the Sql Server 2005 Agent.
If my SSIS package fails, e.g. because the credentials to the database
are wrong or there are duplicate keys, there will just be an unspecific
error message being reported to the event log. Is it possible to tell
the ...more >>
Create Global variable from striped file name Posted by Tom DBD at 6/14/2006 2:01:01 PM Hello, My first post here.
first I'll explain what I have, then I'll explain what I want to do
I have a package that
1. Deletes all data from a holding table.
2. imports a cvs text source file (holds monthly data) as is from a
network directory to re-populate the holding table (all colum...more >>
Persist SSIS vaiable as XML document Posted by emailwaste NO[at]SPAM gmail.com at 6/14/2006 1:55:46 PM Here is what I am trying to do:
I build an xml document by running a couple SQL tasks and store the
nested XML document into variables.
I assemble them using a script task.
The XML is now a valid XML document containing all my recursive XML
elements.
I now want to persist this as a physical ...more >>
Any idea why this won't loop? Posted by amyathome NO[at]SPAM comcast.net at 6/14/2006 12:33:22 PM I am not a newbie to SQL Server but a newbie to creating DTS packages.
I have a directory which will contain an undetermined number of Excel
spreadsheets (with an undetermined amount of tabs within each) that I
will have to on a regular basis import into SQL. I have it grabbing
the first file, ...more >>
Commit transaction after each updated record Posted by Brenda at 6/14/2006 11:53:18 AM Hi
I have a master table in SQL with its corresponding detail tables (more
than one).
I want to scan the master table and for each record I have to update
other related tables, but when it finishes all the processing of one
record, it should commit a transaction in order not to loose the whole
...more >>
SSIS Export to Excel job fails with error code 0x80040154 Posted by Timothy Le at 6/14/2006 11:37:03 AM I have an export to Excel package created through SQL Server Import/Export
wizard. While it works by execute it manually on SQL Server\Integration
Services, it fails when schedule it to run as a job with the following errors
(see end of message).
Steps to reproduce:
1. Create an expor...more >>
SSIS - Scheduled Job weird problem Posted by Christian Hamel at 6/14/2006 12:00:00 AM Hello,
I have a scheduled job that runs an SSIS package. Works fine so far. In
that job, I add a second step that runs another SSIS package. If I run the
job, the 1st step runs well but fails as soon as the second step starts.
However, If I start the job and tell it to start at step #2, it ...more >>
How do you debug a VBScript in DTS ? Posted by Gordon at 6/13/2006 7:31:01 PM Hi;
I want to load 36k records into a SQL table from a text file.
The VBscript that I am using loads 6K records before encountering a problem
with
the transfromation.
I have tried using msgBox but this is no way to deal with 30K worth of
records.
Could I run a SELECT to start in a ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Urgent dtsrun.exe help Posted by Ashok at 6/13/2006 2:50:02 PM Hi,
We moved to new domain and moved all the dts pkg.. updated SID also. My DTS
package runs the cube processing. It uses dynamic properties, email etc. My
cube process is fine but after last step is done update log file and send
email my dtsrun.exe keep running it never finish. If you know t...more >>
Urgent: DTS pkg. moved to new domain Posted by Ashok at 6/13/2006 2:46:01 PM Hi,
We moved to new domain. Moved all dts pacakges. updated new SID etc. In
enterprise manager I see new domain\login. Problem is when I save the DTS
package some how it is taking my old domain name.
Thank you - Ashok...more >>
Importing from a password protected Excel file Posted by jonefer at 6/13/2006 2:08:02 PM I receive an Excel file weekly among 30 other files that are password
protected. I'd like to set up a DTS so that I can automate the imports
without having to tell my client to remove the password each time - is this
possible?...more >>
SQL Server 2005 - Simple package - Integration Services Posted by niagara_man NO[at]SPAM hotmail.com at 6/13/2006 1:57:09 PM Hi!
I am creating a simple package, which I run in SQL Server 2005 (in
development mode). I want to transfer data from a flat file to an SQL
Server 2005 Database table. I get the errors listed below. I get the
same (or similar) errors when I use an OLE DB Connection or an SQL
Server Connection...more >>
Execute same Transform data task multiple times Posted by vinay.singhania NO[at]SPAM gmail.com at 6/13/2006 11:58:20 AM Hi,
I have a DTS package that has 12 data transform tasks. All Tasks use
same query except that each tasks gets data for different months.
I would like to convert this into one step and add active X script or
dynamic property to loop through the same task 12 times.
Can someone please help...more >>
DTS Hanging - End Execution when ODBC hangs. Posted by TaraDinNC at 6/13/2006 10:55:42 AM I am working at a client site where they have MANY DTS packages that
connect to FACTS using a ProvideX 32Bit ODBC driver. Periodically the
FACTS server will be unavailable for one reason or another and the DTS
hangs and so the Job it is in hangs. This job should be executing
every two hrs.
...more >>
Are DTS packages text editable? Posted by Peter at 6/13/2006 8:31:03 AM SQL Server 2000
XP Pro client
Existing DTS package called [POS SO], I want to add a task of delet all
rec's in a table
Are DTS packages text editable similar to T-SQL and SP's where you can
actually type in what you want instead of using the Ent Mgr GUI?...more >>
SSIS Audit Transformation error Posted by Lawrence at 6/13/2006 7:30:01 AM Hello all,
I am getting an error that I am stuck on. I dragged the Audit
Transformation for error handling (Flat File Source); however, the Audit
Transformation is returning an error for one of the standard column "User
name". I tried to change the length or take out this column, but the ...more >>
how can i read/write data in to .xls Posted by mohan_kasturi2000 NO[at]SPAM yahoo.co.in at 6/13/2006 3:51:22 AM hi buddys,
I have a problem with writing data in to the excel using
vbscript.
i need to pick some part of the data from excel and write in to the
another excel sheet.
please any can help me in these.
with regards,
mohan babu.k
...more >>
how to add 100,000 or more records into a SQL table daily with many indexes Posted by LeAnne at 6/13/2006 12:00:00 AM I have a table into which over 100,000 records will be inserted on a daily
basis.
This table will have many indexes.
The records come from another SQL server table.
Whats the best way to insert these records into the SQL table?
How can i disable or ensure that the indexes will NOT slow down ...more >>
Importing string dates into a table's small date colums. Posted by Gordon at 6/12/2006 8:28:02 PM Hi;
I have been trying to import several date fields from a text file into a
table where
the receiving columns are defined as small date.
Here is an example of the data that I am trying to import :
column1 = 111111111
column2 = 01/2/06
column3 = 04/14/06
column4 = (Null)
column5 = 02...more >>
DTS package locked by access database Posted by Schuml at 6/12/2006 2:32:02 PM I have a DTS package that deletes data from a table and then re-populates the
table with fresh data from our ERP system. The problem is this particular
table is linked to an access database, and if a user has the table open in
access the DTS package will not delete the data, it does not error...more >>
VBScript Loop goes too quick Posted by jstgod NO[at]SPAM hotmail.com at 6/12/2006 1:00:05 PM I have a script with this code in it:
For Each objSc in objXml.DocumentElement.ChildNodes
strUrl = objSc.Attributes.GetNamedItem("Url").Text
strFileName = "G:\backup\Migrate\" & Replace(Replace(strUrl,
"http://", ""), "/", "_") & _
".fwp"
strCmd = Migrate_Path & " -w """ +...more >>
DTS Error: Not enough storage is available to complete this operat Posted by Boro at 6/12/2006 10:19:02 AM When trying to import a larger text (400 MB) file into my database using DTS
Import I am getting the following error:
Error at Source for Row number 450063. Errors encountered so far in this
task: 1. Not enough storage is available to complete this operation.
I successfully imported two larg...more >>
DTS package anomaly in SQL Server 2000 Posted by stainless at 6/12/2006 2:10:50 AM I have a package that has the following steps:
Transform data task : EXEC_usp_CreateDPDistancesHTM (stored proc)
Connection properties : Create htm data file ( file created from stored
proc output)
on success
Execute SQL Task : Rename Data file to territory name (renames file
created ab...more >>
Select Distinct for 1 Column Posted by PokerJoker at 6/9/2006 3:01:02 PM I'm pulling a list of customers from out database for a mailing list... it
has to keep a specific format to work with the mailing program that we use.
Problem is, many of our users have the same email address if they work
together at a small company. The emailer we user doesn't filter for th...more >>
Adding logic to check for existence of soource tables Posted by carolus.holman at 6/9/2006 6:38:02 AM I am runnng into a situtation with a vendor who does not load their database
consistently. Sometimes a table is missing from their db. It is a lookup
table so is not critical. What I want to do is check for the existence of the
table in the source db, before I drop my local table. My package f...more >>
How to Change The Source On Transferred DTS Packages Posted by Mark at 6/8/2006 3:35:28 PM Thanks in Advance,
I recently had to move about 200 DTS packages from one server to
another in a hurry. The Source to Destination task worked fine with at
least one exception. Many of the tasks refer to the old server in the
Source connection and have to be changed. If I redo this, what is ...more >>
Invalid Pointer Posted by bhorwitz at 6/8/2006 11:23:02 AM In my Dts Package Im trying to run a Data Transformaion using the following
select statements:
tblICItemMaster.ItemNumber, tblICItemMaster.ItemID,
tblZStorItemLocation.Location, tblZStorItemLocation.Quantity, Getdate () as
Updated,
tblZStorItemLocation.RecordId, tblZStorItemLocati...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |